Bug 141001

Summary:	4 digits year in dates by default or user defined default date format in calc
Product:	LibreOffice	Reporter:	Juan Pablo Berdejo <jpberdejo>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	buzea.bogdan, jbfaure, miguelangelrv
Priority:	medium
Version:	7.1.1.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=46448
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108253

Description Juan Pablo Berdejo 2021-03-13 17:43:07 UTC

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.

Comment 1 m_a_riosv 2021-03-15 19:36:43 UTC

If you enter the date as ISO8601 (EN 28601) YYYY-MM-DD, then 4 digits for the year remain.

Comment 2 Jean-Baptiste Faure 2022-08-24 14:34:46 UTC

(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

Comment 3 ocleyr2lalune@zaclys.net 2022-08-24 19:45:13 UTC

(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