Bug 141001 - 4 digits year in dates by default or user defined default date format in calc
Summary: 4 digits year in dates by default or user defined default date format in calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.1.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2021-03-13 17:43 UTC by Juan Pablo Berdejo
Modified: 2023-04-22 19:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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