@dryak @AngelaScholder @petrillic @robinadams @mhoye
I would be shocked if LibreOffice came close enough to work for anything that used some of the weirder Excel features.
I was at Microsoft when they were on a big push to improve Excel Online. The original version ran a complete Windows VM running Excel for each open spreadsheet. I think they worked out that if 1% of users switched to the online version it would bankrupt the company. They improved that hosting density a lot but had problems with latency.
In Google Sheets, all of the calculations run in JavaScript in the browser. Excel Online did the same thing but only for a preview. You’d see some instances where changing a cell would trigger a big recalculation, all of the cells would get updated and then, a few seconds later, get updated with the correct values.
The team next to mine had a big project to rewrite Excel’s calc engine in TypeScript. This was a neat project, but also very hard. There was no specification of the behaviour other than ‘what this 1980s C function does’. A somewhat terrifying codebase that included an 8087 emulator. The reimplementation came close, but the telemetry that compared its results to original version was still showing errors. I think their final solution was to compile the original calc engine to WebAssembly and embed it in the page.
EDIT: Although there is no good test suite, the Enron lawsuits entered an enormous number of Excel sheets into evidence, which means that they’re now public. The ‘Enron Corpus’ is the closest thing anyone has to a test suite for Excel. I suspect the ‘NVIDIA Corpus’ will be similar in a few years.