Comment by nradov
4 days ago
It's possible you found a bug in Excel somewhere but I guarantee that when working with large files it's generally faster and more reliable than the competition. I have successfully worked with files way larger than 20 MB which make competing products such as Apple Numbers or Google Sheets completely choke.
Compare with gnumeric, that's the only spreadsheet I can recommend. I have files with hundreds of plots, non-trivial fits, and logic. 100% of everything works always and it's much faster.
I have a direct comparison because the exact same computations were previously implemented in excel and libre office. Both dropped plots from files, had straight-up reference bugs once things got large, and would regularly crash attempting to render dozens of tiled plots in 4k. The idea of using Google sheets for this is laughable.