Description: I believe Calc 25.2.0.3 introduced new automatic/detected separator option, which is now default when opening Text Import dialog. Previously "Separated By" was the default option and worked very well for me, because I needed to paste a lot of columns separated by '='. So I request to make Text Import dialog remember previous separator option. Steps to Reproduce: 1. Paste some text using import dialog 2. Choose "Separated By" 3. Click "Ok" 4. Paste text using import dialog again Actual Results: Automatic is selected by default (sorry don't remember the exact name of that new 3rd option) Expected Results: "Separated By" is selected by default Reproducible: Always User Profile Reset: No Additional Info: Reproducible since libreoffice-25.2.0.3 flatpak version
Status will not be changed due to enhancement request. Options are no longer retained from the following commit. commit 565b619d57a3b98b0826c4b49dee6606f9ae70e0 author Gabriel Masei <gabriel.masei@1and1.ro> Tue Apr 09 13:07:18 2024 +0300 tdf#160582 Preserve settings saving in csv import dialog Also, improve detection algorithm by replacing the limit of 20 lines with a time limit of 500ms.
This is not reproducible when importing a csv (text) file. However, it reproduces on text pasting use case. I took a short look and it seems that the dialog's save function is called but for whatever reason the data is not saved (or not read correctly).
It seems that the property "SeparatorType" was added only to CSVImport schema group but not to ClipboardTextImport and TextToColumnsImport in Calc.xcs. Adding it should make saving separator type options in all use cases.
*** Bug 165961 has been marked as a duplicate of this bug. ***
Bogdan Visanescu committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/19f3b72f34c487dc97d582712d21734a7e055fd5 tdf#165744 Added SeparatorType to ClipboardTextImport and TextToColumnsImport It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 166606 has been marked as a duplicate of this bug. ***