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 apothegm on Monday January 15, 2024 @09:20AM (#39001268)

My biggest pain point is inability (as in refusal, not failure) to open files with more than N rows even if plenty of memory is available. (I forget what the exact value of N is.) Especially annoyingly, this limitation didn’t seem to exist 20 years ago.

[ Parent | on HN ]

Re:Ask HN: What are your most common tasks and painpoints in... by daneel951 on Monday January 15, 2024 @09:51AM (#39001596)

Power Pivot Excel add-inshould be able to manage million of rows.

See https://support.microsoft.com/en-us/office/data-model-specif... and https://support.microsoft.com/en-us/office/create-a-memory-e...

[ Parent | on HN ]

Re:Ask HN: What are your most common tasks and painpoints in... by apothegm on Monday January 15, 2024 @10:55AM (#39002256)

First off, that article seems to be specific to web versions and pivot tables. Secondly, yeah, a few million rows isn’t that much for some use cases. I have at times needed support for mid 9 figures.

[ Parent | on HN ]