Comment on LibreOffice criticizes EU Commission over proprietary XLSX formats
jdr@lemmy.ml 3 weeks agoFormulas 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.
ranzispa@mander.xyz 3 weeks ago
Do you know of any software which stores formulas in CSV?
jdr@lemmy.ml 3 weeks ago
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.
ranzispa@mander.xyz 3 weeks ago
I didn’t know calc could do that, cool!