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: libreoffice-bugs@lists.freedesktop.org Reporter: james....@gmail.com 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.