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.
This seems weird indeed. When you check "Evaluate formulas", the opened CSV file shows the value 4 in cell B1, but if you select the cell and check its contents you'll notice that it does have a formula, not the value "4". So saving the file as CSV should save the formula as well.
(In reply to Konstantin Kharlamov from comment #0) > I use CSV+formulas as a plain-text format that can be stored in git and > wouldn't require typing formulas anew. Have you considered using Flat XML ODF Spreadsheet (.fods) for this purpose?
(In reply to Michael Warner from comment #2) > (In reply to Konstantin Kharlamov from comment #0) > > I use CSV+formulas as a plain-text format that can be stored in git and > > wouldn't require typing formulas anew. > > Have you considered using Flat XML ODF Spreadsheet (.fods) for this purpose? Oh, thanks! I didn't know about that format. Yeah, that's an interesting solution. Although it has lots of text compared to CSV, but on the upside, adding new columns will grow the file down, so it's easier to compare the diffs (CSV files would grow to the right). Thank you!
NEW per comment 1