LibreOffice Calc. I think it still has some performance issues vs Excel with extremely large files, and it can only do 1024 columns. Also LibreOffice Basic can do a lot of what VBA could but the syntax is different and I don’t think it integrates well with the rest of the system like VBA’s COM integration (as unsafe as that was)
What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?
I’ve made some truly Frankenstein sheets that I’m not sure could be stitched together elsewhere.
Why excel for super complex computations? At some point, just code your solution instead… It’s easier than troubleshooting Excel
I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college…
I don’t have any issues. It’s free to download to any operating system. So give it a try. See if it can open your existing Excel spreadsheets
world_cavve@lemmy.world 6 months ago
You could try SoftMaker office for 30 days to see if their version of Excel is better.
Yearly subscription: www.softmaker.com/en/products/…/download Perpetual license: www.softmaker.com/…/download-permanent-version Comparing the different versions: www.softmaker.com/en/products/…/order-all
Bonus is that the license will work regardless if you use Linux, Mac or Windows. And the 2024 version is GDPR compliant.