Description: By default when enter a date in Calc, changes the year to 2 digits and the user have to manualy change de date format every single time a date is write in a cell. Steps to Reproduce: 1. Write a date in Calc with 4 digits year. 2. The date changes to 2 digits year. 3. Actual Results: Always need to manualy change the date format. Expected Results: Don't need to manualy change the date format every time. Reproducible: Always User Profile Reset: No Additional Info: Change the system wide date format don't help.
If you enter the date as ISO8601 (EN 28601) YYYY-MM-DD, then 4 digits for the year remain.
(In reply to m.a.riosv from comment #1) > If you enter the date as ISO8601 (EN 28601) YYYY-MM-DD, then 4 digits for > the year remain. Yes, but that does not work with function TODAY() or when you type only the day and the month to obtain the date for the current year. I see often this enhancement request on users mailing list or forums. I think that that is a valid enhancement request because would be useful to be able to set that the default year format is 4 digits. So set status as NEW. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #2) > > I see often this enhancement request on users mailing list or forums. I > think that that is a valid enhancement request because would be useful to be > able to set that the default year format is 4 digits. > > So set status as NEW. > > Best regards. JBF if we want to take into account all the use cases, I think it would be better to make the default number formats configurable, and not change the default year format for all users. First in the advanced configuration Second, if possible, by enriching the cell style to choose the format to apply according to the type of number (date, currency, number...) It's better if users can choose. Thanks Claire