Bug 70111 - CSV files to keep the original text delimiters and separators
Summary: CSV files to keep the original text delimiters and separators
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
: 71376 101173 (view as bug list)
Depends on:
Blocks: CSV
  Show dependency treegraph
Reported: 2013-10-04 04:56 UTC by oliver nadj
Modified: 2020-08-06 08:12 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description oliver nadj 2013-10-04 04:56:15 UTC
I think it would be useful if Spreadsheet editor can keep the original text delimiters and separators of CSV documents.

It is a related to this question: http://ask.libreoffice.org/en/question/23332/csv-files-lose-formatting-after-save/

People use CSV files to import/export records from different apps and hardware. These tools often do not prepared to handle different kind of formatting. I know it is possible with additional "Save As" steps but it is not user-friendly.
Comment 1 Pedro 2013-10-04 10:28:06 UTC
I agree that the default should be to keep the same field and text delimiters. If the user wants to change then it should be his/hers *option*, not a software decision.
Comment 2 Maxim Monastirsky 2013-11-08 08:16:32 UTC
*** Bug 71376 has been marked as a duplicate of this bug. ***
Comment 3 Urmas 2015-04-25 10:18:00 UTC
Files saved in this way become corrupted, so that is not just an 'enhancement'.
Comment 4 m.a.riosv 2016-07-28 22:27:57 UTC
*** Bug 101173 has been marked as a duplicate of this bug. ***
Comment 5 QA Administrators 2018-07-21 02:40:33 UTC Comment hidden (obsolete)
Comment 6 aljosha.papsch 2018-07-30 10:58:58 UTC
Yes, the issue persists to this day.

Build-ID: 6.0.5-1
CPU-Threads: 4; BS: Linux 4.17; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group

Steps to reproduce:

1. Create a file test.csv with the contents:


2. Open the file in Calc, leaving the import settings untoched.
3. Write "baz" in A2, "quux" in B2.
4. Choose File | Save and confirm CSV format.

Expected file contents:


Actual file contents:

Comment 7 QA Administrators 2019-07-31 02:53:51 UTC Comment hidden (obsolete)
Comment 8 sam tygier 2020-08-06 08:12:27 UTC
This is fixed. I can't reproduce the problem following the instructions in comment 6.

I think it was fixed in LO 5.4 by the patch for #55236 which saves the formatting settings from the open dialog.