Background
I’m using LibreOffice 24.8.3.2 on Windows 10.
I’m in the UK, but always use YYYY-MM-DD as my date format. In Windows Settings, my “Region” is United Kingdom but I override the “Regional format data” so that short dates are formatted as YYYY-MM-DD. Excel respects this, so for example if I create a new Excel file and enter the formula “TODAY()”, the result is correctly formatted as “2024-12-17”.
I know that LibreOffice ignores these “Regional format data” settings, so in LibreOffice I set my locale to “English (Canada)”, because that defaults to YYYY-MM-DD settings.
This works fine for a file natively created in Calc. For example, if I create a new Calc file and enter the formula “TODAY()”, the result is correctly formatted by default as “2024-12-17”.
Issue
If I use Calc to open an .xlsx file that was created in Excel, dates that were correctly formatted by default as YYYY-MM-DD in Excel are misformatted as DD-MM-YYYY in Calc.
That’s incorrect because (a) it doesn’t correspond to the format configured in Windows, (b) it doesn’t correspond to the default format for the locale in LibreOffice, (c) neither in Excel nor Calc was any formatting applied that would override the default.
Steps to reproduce
-
In Windows, set the region to “United Kingdom”, then modify the “Regional format data” so the short date format is YYYY-MM-DD.
-
In LibreOffice settings, set the locale to “English (Canada)”.
-
Create a new file in Excel. In cell A1 enter the formula “TODAY()”. The result is displayed as (for example) “2024-12-17”. Save and close the file.
-
Open the above file in Calc. Cell A1 now displays “17-12-2024”.
Is there a setting I can change to fix this, or should it be raised as a bug?