55
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 08 Mar 2026
55 points (100.0% liked)
Technology
82988 readers
1444 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
founded 2 years ago
MODERATORS
Give me CSV or give me death
i will also accept LibreOffice's format for formula purposes
Death it is, CSV is horrible effectively unstandardized trash that has led to uncountable hours of efforts wasted due to subtly corrupted data through incompatible serialization settings.
It actively makes the world a worse place by existing.
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.