Bug 160742 - Saving a CSV with tab delimiter, saves with coma delimiter
Summary: Saving a CSV with tab delimiter, saves with coma delimiter
Status: RESOLVED DUPLICATE of bug 152336
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-20 08:55 UTC by Bert
Modified: 2024-04-22 06:50 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Bert 2024-04-20 08:55:09 UTC 
Description:
When I save a sheet from my calc ods file as csv, I choose tab delimited.
I check the file with a text editor and can confirm tabs are used as delimiter
I open the csv file again to do some editing and save it again.
The file is now comma delimited.

Steps to Reproduce:
1) Create a spreadsheet in calc.
2) Save sheet as C as csv, Choose tab delimited in the dialog box
3) Ceck the file with a text editor and confirm tabs are used as delimiter
4) Open the csv file again to do some editing and save it again.
5) The file is now comma delimited.

Actual Results:
A comma delimited CSV file

Expected Results:
A tab delimited CSV file


Reproducible: Always


User Profile Reset: No

Additional Info:
This is slightly anoying when using the files in an other program that doesn'
t autodetect the delimiter correctly. Or if there are commas in the data, which was the reason for choosing tab delimited
Comment 1 Mike Kaganski 2024-04-20 09:21:18 UTC 

*** This bug has been marked as a duplicate of bug 152336 ***
Comment 2 Gabriel Masei 2024-04-22 06:50:12 UTC 
We are aware of this issue and working on it. The previous feature of allowing saving/loading the entire configuration of Import dialog will be preserved.

@Bert Could you provide the csv source file that generated current issue ? Or something similar if you cannot share the original one? It could help us improve the detection algorithm.