Calc csv format the formula e.g. =C7*L7 works fine. When I save the file and reopen it, the formula is lost and it shows the value of the calculatio. So saving the file loses the formula.
Version is 7.5.0.3
I tried ods format and it seems to save the cell formula.
This is the essence of a csv file. Open your csv file in a text editor such as “Nodpad”. What the text editor displays is all there is in that file. csv consists of plain text only. csv has nothing to do with spreadsheets.
If you choose "Text (*.csv) in the save-as dialog and then “Edit filter settings” you get an additional dialog where you can specify that formulas should be exported instead of formula results. This makes the csv useless for any software that does not interprete formulas.
1 Like
Thanks for the explanation. The WEB server that provides me this sheet creates csv an I just opened it and modified. Modifications were stored but as you explained, not the formulas. I noticed that I have some sheets I have created from scratch and suddenly they have been chosen to be odt and I have never met the problem unti now. So I stored the csv file as odt and the problem is no more an issue.
If you import a csv text file into a spreadsheet application, you fill a blank new spreadsheet with raw data. Whatever you do to the spreadsheet, should be stored as a spreadsheet in the native file format of the application you are using. Save your spreadsheet as Open Document Spreadsheet (*.ods) and nothing will be lost, modified, changed in any way.
1 Like