Description: One should be able to export CALC spreadsheets as a CSV file, not just via save. The reason is that the ODF format contains a lot of formatting info, not to mention potentially multiple sheets. CSV is useful for input to some programs but chances are good that the ODF should be the "master". But if you get a CSV via 'save as' that becomes the default save type and it is easy to make a number of changes, then save and exit without saving the changes to the master ODF file. Steps to Reproduce: 1. Create a spreadsheet of any time 2. Save as an ODF file (or Excel for that matter) 3. Save as CSV 4. Save (without as). Actual Results: CSV is updated but not ODF. Expected Results: That behavior is expected but often not what is wanted. Reproducible: Always User Profile Reset: No Additional Info: My proposal is to allow export to do CSV without affecting the default format type.
You can use menu File > Save a Copy... to generate a CSV-file, and keep the current document as ods file.
Thanks. Never thought of that over years of being annoyed at this. I'll give it a try and close this if it does what I'm looking for.
Ok, save a copy seems to work fine. I have no idea why I never thought of that before. Thanks!
Changing to resolved