News for hackers. Stuff that matters.

A comment on Ask HN: What are your most common tasks and painpoints in spreadsheet software?.

Re:Ask HN: What are your most common tasks and painpoints in... by edlinfan on Monday January 15, 2024 @03:33PM (#39005716)
> Javascript

A quick note: your spreadsheet had better support arbitrary-precision currency math, if it doesn't already. That's table stakes for a spreadsheet.

To answer your real question, I'd suggest doubling down on the sqlite side and taking things in a relational direction. Spreadsheets are good at tracking 1:1 or 1:many relationships, but my spreadsheets inevitably grow in a many:many direction and I find myself wishing for queries and junction tables.

[ Parent | on HN ]
Re:Ask HN: What are your most common tasks and painpoints in... by phonon on Monday January 15, 2024 @08:10PM (#39008181)
All major spreadsheets use double-precision floating-point throughout. I'm not sure where you got the impression they "support arbitrary-precision currency math".

In fact they even typically truncate or round the last few bits.

[ Parent | on HN ]