Re:Benchmarking Spreadsheet Systems
by rolling_roland on Friday December 13, 2019 @03:34AM
(#21780035)
I was struggling with spreadsheet performance some time ago, trying to open csv with over million of rows, which made my excel cough. To help with this I built collection of tools for myself (https://blocksheet.io) so I could at least split my csv files to smaller ones and then edit with excel.
>In a similar vein, sorting causes problems on very small datasets (less than 10K rows):
Reading this made me wonder just how much excel prioritizes formulas and other fancy features over basic utilities such as sorting. For comparison, I just tried sorting csv with over 2 million rows on blocksheet and even though it took few seconds and made my laptop fan do extra jumps (it's a static site), it still managed to do it in reasonable time.
For me it's such a rare problem to run into huge spreadsheets, that it's a bit overkill to build my own software for it. So if anyone knows any good ones that deal well with rearranging large spreadsheets, I'd be happy to hear about them.
>In a similar vein, sorting causes problems on very small datasets (less than 10K rows):
Reading this made me wonder just how much excel prioritizes formulas and other fancy features over basic utilities such as sorting. For comparison, I just tried sorting csv with over 2 million rows on blocksheet and even though it took few seconds and made my laptop fan do extra jumps (it's a static site), it still managed to do it in reasonable time.
For me it's such a rare problem to run into huge spreadsheets, that it's a bit overkill to build my own software for it. So if anyone knows any good ones that deal well with rearranging large spreadsheets, I'd be happy to hear about them.