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.
Give me CSV or give me death
csv is a pretty good data sharing format, but not very well suited for spreadsheets. Just because you can shove anything you want in there doesn’t mean you should.
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 ;)
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.
The technical term is sheet. The many sheets form a workbook (your file).
Just like opening a .doc file in notepad, technically all the information is there
i will also accept LibreOffice’s format for formula purposes