With Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5ebdcc60701ca5f2d267f92fa69ac06202309c52 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded After tdf#152336 improvement. The issue is that now, locale setting is not preserved in the import window. As was the case until 24.2. Seems it is reset to the default locale in my case es-ES.
Created attachment 193564 [details] Sample file csv to test
Using 24.8 alpha built 2024-04-08, I can confirm that the regional setting in the import dialog is taken from menu Tools > Options > Languages and Locales > (Formats) Locale setting. I modified both the UI language and the Locale setting Options to different values. After restarting LO, the "Locale" setting in the import dialog changed according to the "Locale setting:" field used in Options. I have not tested the other field in the import dialog, "Character set". Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 748561425774fa40ab685fed80d113f7e8301158
I don't know if bibisectRequest is right here. We know that the issue was introduced with the tdf#152336 improvement. And Gabriel is working on it.
Locale is the option where the guess is most likely to be wrong. But the same problem (bad guess) can just as well apply to the other options. The user should have a way to choose whether they want to use their specific settings or have LibreOffice take a guess. Full-fledged templates (bug 62828) would be one possible solution. But I think it would be enough to have one of these options: a) automatically guess, but offer a button to restore last manually chosen options b) always use the last manually chosen option, but offer a "Guess" button My personal preference would be (b).
(In reply to Markus Keller from comment #4) > Locale is the option where the guess is most likely to be wrong. > But the same problem (bad guess) can just as well apply to the other options. > > The user should have a way to choose whether they want to use their specific > settings or have LibreOffice take a guess. > > Full-fledged templates (bug 62828) would be one possible solution. But I > think it would be enough to have one of these options: > > a) automatically guess, but offer a button to restore last manually chosen > options > b) always use the last manually chosen option, but offer a "Guess" button > > My personal preference would be (b). And we chose the second option. Take a look at this proposed patch: https://gerrit.libreoffice.org/c/core/+/165905 Best, Gabriel