SahwaMar 8

LibreOffice criticizes EU Commission over proprietary XLSX formats

https://reddthat.com/post/61544796

LibreOffice criticizes EU Commission over proprietary XLSX formats - Reddthat

>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.

Show threadjdrMar 8
Give me CSV or give me death
Show threadranzispaMar 8
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.
Show threadjdrMar 8

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.

Show threadranzispaMar 8
Do you know of any software which stores formulas in CSV?
Show threadjdr

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.

Mar 8 at 11:47pmWeb
Show threadranzispaMar 9
I didn’t know calc could do that, cool!