4 ms·
Performance is affected by a myriad of factors, many of which aren't visible by looking at the worksheet. For example, XLS/XLSX support a special "shared formu
by sheetjs 7y ago
Performance is affected by a myriad of factors, many of which aren't visible by looking at the worksheet.
For example, XLS/XLSX support a special "shared formula" representation which tells Excel that a formula is structurally similar to other formulae. This is not always written, depending on how the file was generated and other factors. Without that, Excel will take an "inefficient" calculation approach. You can't figure it out from the UI or by inspecting the formula text -- you actually have to dig into the file to see it.
- magnifique 7y agoThat's really cool! How did you figure this out and what does this representation look like?
- bri3d 7y agohttps://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.cellformula?view=openxml-2.8.1 https://docs.microsoft.com/en-us/dotnet/api/documentformat.o... The OpenXML basis format for XSLX is an ISO standard. Most things are documented albeit in a somewhat obtuse way.