https://bugs.documentfoundation.org/show_bug.cgi?id=152332
Bug ID: 152332
Summary: tab delimited .txt and .tsv files are overwritten as
comma delimited by default
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Opening a tsv file (.tsv or .txt) that is tab delimited and then clicking save
will erase the formatting of the file and overwrite as a comma delimited file
by default.
A quick google shows this issue has been present in 2015
https://ask.libreoffice.org/t/calc-saving-my-tsv-file-as-a-csv-without-asking/19709
There is a work around: needing to use additional clicks to save as a .csv with
"edit filter settings" checked, then selecting field delimiter: "tab", and
finally renaming the file to the original file extension.
https://ask.libreoffice.org/t/how-to-generate-calc-tab-delimited-output/14591
Following this procedure to export the file correctly once seems to solve the
issue for subsequent saves of all files.
Steps to Reproduce:
1. Fresh install of Linux Mint 21.0
2. Open a .txt file that is tab delimited
3. Click the save icon
4. Re-open the file in a text editor to show that the formatting has been
changed to comma delimited
5. Reproducible until "save as" with filter 1 time
Actual Results:
Formatting was changed from tab to comma delimited (file extension still .txt)
Expected Results:
Formatting should be preserved as tab delimited
Reproducible: Always
User Profile Reset: No
Additional Info:
Once doing an export with filter set to tab delimited once, the issue appears
to be solved.
--
You are receiving this mail because:
You are the assignee for the bug.
