you can store anything in CSV, it’s just not always very practical ;)
Comment on LibreOffice criticizes EU Commission over proprietary XLSX formats
ranzispa@mander.xyz 1 day agoCSV 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.
raspberriesareyummy@lemmy.world 23 hours ago
rollin@piefed.social 22 hours ago
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.
raspberriesareyummy@lemmy.world 10 hours ago
technically you could do both, it’s just not practical at all :)
tristan@tarte.nuage-libre.fr 21 hours ago
The technical term is sheet. The many sheets form a workbook (your file).
Theoriginalthon@lemmy.world 23 hours ago
Just like opening a .doc file in notepad, technically all the information is there
jdr@lemmy.ml 23 hours ago
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.
ranzispa@mander.xyz 22 hours ago
Do you know of any software which stores formulas in CSV?
jdr@lemmy.ml 21 hours 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 20 hours ago
I didn’t know calc could do that, cool!