Create empty calc file, select first column and take "Format cells". Opt for language "Dutch Belgium" and select format "31/12/1999".
Now type in a cell "1/5/2019" and see that you get in the cell "05/01/2019". Type "23/4/2019" and you get the correct "23/04/2019".
Selecting format "31 dec 1999" and do the same input as above, and you get in the cells "5 jan 2019" and "23 apr 2019"
Date format is only respected if the first number is greater than 12, i.e. it cannot be a month. When the first number is 12 or less, then this number is taken for month.
The date info in the cells is not recorded correctly.
User Profile Reset: No
My system (Mageia 6) is configured in English with Belgian keyboard. This problem I never had on previous LO versions.
I dont reproduce with
Build ID: 547edd20e527fb02900f6174973770d26306e2e7
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win;
Locale: en-US (fr_FR); UI-Language: en-US
1 mei 2019
23 apr 2019
(In reply to herman.viaene from comment #0)
> Create empty calc file, select first column and take "Format cells". Opt for
> language "Dutch Belgium" and select format "31/12/1999".
> Now type in a cell "1/5/2019" and see that you get in the cell "05/01/2019".
maybe related to
[Bug 125109] Calc swaps day and month of edited dates if the format's DMY order does not match the locale's MDY order and date acceptance patterns match both.
That is not correct, if the format is applied correctly it should be 01/05/2019
The key here probably is "configured in English" en-US system (or default LibreOffice) locale with M/D/Y date order and "Dutch Belgium" nl-BE format with D/M/Y date order. Input always follows the system locale, only if there is no match (i.e. input does not result in a date as in 23/4/2019) the individual format is tried.
Reason is (and was before) that for an empty cell there is no user visible indicator what YMD order is expected (unless s/he looks up the format first).
The resolution for bug 125109 is to keep the system locale's YMD order processing (here M/D/Y) for new input in empty cells (again unless no match) but follow the format's locale's YMD order (here D/M/Y) if the cell already contains a date.
If you want to process always D/M/Y order in your constellation you can do two things under Tools -> Options -> Language Settings -> Languages:
* either set the Locale setting to Dutch (Belgium), which also changes the date acceptance patterns
* or set the (insert a) first date acceptance pattern with D/M/Y
*** This bug has been marked as a duplicate of bug 125109 ***