The Foundation sees this as a contradiction to the EU’s own interoperability goals. Although XLSX is standardized as OOXML according to ISO/IEC 29500, Microsoft’s implementations often deviate from the specifications. Furthermore, features often change undocumented, which complicates compatibility with open-source software such as LibreOffice.
CSV does not allow storing formulas, just results. It is a good format to share data, but it is not a good format to store spreadsheets which very often contain such formulas.
Formulas are just strings, no reason you couldn’t store over in a CSV.
Maybe your software doesn’t want you to do that, but that’s a problem with that specific software.
Do you know of any software which stores formulas in CSV?
It’s an option when saving in LibreOffice Calc.
Would be a pretty straightforward macro to (un)quote the formulas in Excel or Google Sheets etc.
I didn’t know calc could do that, cool!
you can store anything in CSV, it’s just not always very practical ;)
Just like opening a .doc file in notepad, technically all the information is there
I don’t think you can have spreadsheets with multiple “sub sheets” (can’t think of an unambiguous name for them - basically the equivalent of browser tabs)
Pretty sure there’s no way to have graphical charts either.
technically you could do both, it’s just not practical at all :)
The technical term is sheet. The many sheets form a workbook (your file).