Description: A tsv file opened then output via "save as" selecting format csv creates a tab delimited file rather than a comma delimited file. Steps to Reproduce: 1. create tsv example 2. open in calc 3. select "save as" csv format 4. open created file in text editor Actual Results: Output file has tabs, not commas Expected Results: Expected to have commas as field delimiters with quotes around fields containing commas Reproducible: Always User Profile Reset: No Additional Info: Should have created fields as expected.
There's no "TSV" file type in LibreOffice. CSV is a common name for any plain-text structured data imported into Calc, where import and export filter may use different separator characters and other settings. When you imported the tab-separated file, the import filter has saved the settings used for its import, to keep on export. That is reasonable, since *most of the time* users open files, make edits, and save, expecting the file structure to be kept, just the data be changed according to the edits. The use case that you describe is different, and it needs the export filter settings to be changed. For that, Save As dialog, where you define the file type, has "Edit filter settings" checkbox, checking which will open the filter settings after you click Save. There you may define comma as separator, to override the values stored from import. https://help.libreoffice.org/latest/en-US/text/scalc/guide/csv_files.html?DbPAR=CALC Closing NOTABUG.