Bug 146654

Summary: Imported tsv file saved as csv is saved as tsv.
Product: LibreOffice Reporter: John Andrea <bugzilla.report>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 7.2.4.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description John Andrea 2022-01-08 14:17:00 UTC 
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.
Comment 1 Mike Kaganski 2022-01-08 16:15:54 UTC 
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.