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 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
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.
I think it’s perfectly well suited to spreadsheet. It’s more-or-less perfect for tabular human-readable data. If you want to embed fancy things like OLE objecta and ActiveX controls and helpful animated characters then you may well be better served with another format.