https://bugs.documentfoundation.org/show_bug.cgi?id=150836
Bug ID: 150836
Summary: CSV save-mode is different from the one used for
opening
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I use CSV+formulas as a plain-text format that can be stored in git and
wouldn't require typing formulas anew. Unfortunately, when using Ctrl+s to save
an edited CSV file, all formulas are lost. They shouldn't be, because LO knows
the exact format it used for loading the file.
Repro with latest 7.4.0.3
# Steps to reproduce
1. Execute `echo "2,=A1*A1" > test.csv`
2. Open the created `test.csv` in LO Calc `localc ./test.csv`
3. A window with file load configuration will pop up: make sure a `✓ Evaluate
formulas` checkbox is checked and press `Ok`
4. Press Ctrl+s to save the file. LO will only ask if you're sure about the
format, press `Use Text CSV Format`
5. In terminal execute `cat test.csv`
## Expected output
2,=A1*A1
## Actual output
2,4
# Workarounds
Use `Save as` (Shift + Ctrl +s), then in popped up window make sure a "✓ Edit
filter settings" is set. When through a few windows the filter settings appear,
make sure a "✓ Save cell formulas instead of calculated values" is set.
Fun thing: the checkbox is set by default. But apparently Ctrl+s disagrees.
--
You are receiving this mail because:
You are the assignee for the bug.
