The default file format for new spreadsheets should be ODS, not CSV. For users not familiar with the details of the file formats, it is very annoying that all formatting and formulas are lost when saving in CSV. In addition, there should be a warning when saving as CSV to that effect. (Just as an example, an accountant friend who is not very computer savvy spent two days balancing the accounts between two spreadsheets imported from a bank, highlighting the matching rows with different colors and meticulously saving periodically, only to discover after closing the files and reopening them that all formatting was lost.)
The default file format for new spreadsheets *is* ODS. If you worked on already existing CSV, it's saved like that. It's upon user to understand file formats. LO has "Confirm File Format" warning. If you disagree and can add something to show it's LO issue, please explain in detail *with steps* and set back to Unconfirmed.
Created attachment 137013 [details] Save as dialog of new spreadsheet
Steps to reproduce: (on my installation under MacOS 10.12.6) 1) Create a new Calc document 2) select File menu -> Save as ... 3) the default file type is CSV
What is the setting of Options - "Load/Save" - "General" - "Default file format and ODF settings" - "Document type: Spreadsheet"?
You are so right! I never noticed that "Load/Save" - "General" - "Default file format and ODF settings" ... Sorry to have taken up your time ...