Bug 160582

Summary:	FILEOPEN: CSV, locale setting is not preserved in the import window (regression tdf#152336)
Product:	LibreOffice	Reporter:	m_a_riosv <miguelangelrv>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, erack
Priority:	medium	Keywords:	bibisectRequest, regression
Version:	24.8.0.0 alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=152336
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:	152336
Bug Blocks:	109239
Attachments:	Sample file csv to test

Description m_a_riosv 2024-04-08 08:57:00 UTC

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.

Comment 1 m_a_riosv 2024-04-08 08:57:38 UTC

Created attachment 193564 [details]
Sample file csv to test

Comment 2 ady 2024-04-08 19:56:12 UTC

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

Comment 3 m_a_riosv 2024-04-09 21:00:10 UTC

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.