LibreCalc: Date Format input method reversed

[JohnDoe558]

My spreadsheet files have the date format in DD-MM-YYYY (example, 01-01-2025). The date format is user defined. Before the recent update (which one I cannot recall), I simply used to enter “1-1-25” into the field and it would automatically translate it to “01-01-2025”.

Recently, all spreadsheets have reversed this format, entering “1-1-25” now results in “25-01-2001” instead of “01-01-2025”. This has become a real annoyance since my muscle memory is set to enter D-M-YY, which should automatically form into “DD-MM-YYYY” as is in the user defined date format.

How do I fix it?

Thank you.

[Zizi64]

@JohnDoe558

Recently, all spreadsheets have reversed this format, entering “1-1-25” now results in “25-01-2001”

The date strings separated by “-” are ISO (International Standard) format with only one acceptable order: YYYY-MM-DD or YY-MM-DD.
The localised date formats has not a “-” separator. They use “.” or other separator characters.
A brand new spreadsheet document always will recognise the order (YY)YY-MM-DD as a date. Do not use the “-” separator with a different order. It is possible to use “-” character in some custom date style (with various order), but it will cause such problem what you have now.

[EarnestAl]

See if you can train yourself to enter 1/1/25, or 21/1/25, on the numeric keypad it is only one key away.

There are more requests from users here for the default to be ISO 8601, for that the dashes would need to be reserved. See also ISO 8601 - Wikipedia, in existence since 1988