Bug 68774 - Wrong year shows when entering dates
Summary: Wrong year shows when entering dates
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Reported: 2013-08-30 23:36 UTC by baasha
Modified: 2015-12-15 10:53 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description baasha 2013-08-30 23:36:15 UTC
Problem description: 

Steps to reproduce:
1. ....Date acceptance pattern set to DD/MM/YY
2. ....Date format set DD/MM/YY
3. ....Enter 28/8

Current behavior:28/08/14 shows in cell

Expected behavior:Should show 28/08/13

Operating System: Ubuntu
Version: release
Last worked in: release
Comment 1 Julien Nabet 2013-10-03 20:21:00 UTC
baasha: I'm not a Calc expert, could you explain the difference between 1. and 2. ? (for me 2. = Format Cell, Date + format description)
Comment 2 Jorendc 2013-10-04 10:15:45 UTC
@Julien: Date acceptance pattern (1.) is a setting in Tools > Options > Language Settings > Languages. Date format (2.) is the cell format :).

I fail to reproduce this bug. Did step 1 and 2, but after entering 28/08 LibreOffice isn't "recognizing" this as a date (so it stays 28/08 and left aligned in the cell).

Tested using Mac OSX 10.8.5 with LibreOffice and rc.

Kind regards,
Comment 3 baasha 2013-10-05 23:58:51 UTC
Symptoms have changed slightly since automatic upgrade to vs.

Now it is as Jorendc has reported: If you enter the day/month it isn't being recognized as a date. In vs. and earlier this entry would automatically fill in the year giving 28/08/13. After vs. it started to put in 28/08/14 with an entry of 28/8. This latter symptom has now disappeared in vs. but the entry is still not being recognized as a date.
Comment 4 Robinson Tryon (qubit) 2013-10-16 23:59:16 UTC
Changing 'regression' -> 'PossibleRegression' until we have independent confirmation of a regression.
Comment 5 QA Administrators 2014-05-17 00:33:55 UTC
Dear Bug Submitter,

Please read the entire message before proceeding.

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team
Comment 6 baasha 2014-05-17 19:38:13 UTC
Maybe I'm missing something but I don't see any requests for more info.  Another user confirmed the bug (although he says he failed to do so, and then says the entry is not recognized as a date).

I am happy to supply more info but I don't know what more I can say.

To reiterate:
1. OS Ubuntu
2. LO vs
3. Set date acceptance pattern to DD/MM/YY
4. Set date format to DD/MM/YY
5. Enter 17/5
6. In LO vs and earlier this would result in a cell entry of 17/05/14    (recognized as a date).
7. Since vs the result is a text entry of 17/5
Comment 7 Jorendc 2014-05-17 20:07:07 UTC
(In reply to comment #6)
> To reiterate:
> 1. OS Ubuntu
> 2. LO vs
> 3. Set date acceptance pattern to DD/MM/YY
> 4. Set date format to DD/MM/YY
> 5. Enter 17/5
> 6. In LO vs and earlier this would result in a cell entry of
> 17/05/14    (recognized as a date).
> 7. Since vs the result is a text entry of 17/5

Well, I really fail to reproduce this one... If I do this, I get 17/05/14 when I enter '17/5'.

Tested using Windows 8.1 with LibreOffice
Comment 8 Julien Nabet 2014-05-17 20:12:44 UTC
Baasha: what localization options do you use?
Menu Tools/Options/Language Settings/Languages:
More precisely what are your values for these 3 options:
- User Interface
- Locale Setting
- Date Acceptance patterns
Comment 9 Joel Madero 2014-05-21 04:18:37 UTC
Setting back to NEEDINFO.

Please answer the last questions, also reset your profile, and then if you are still experiencing and answer the questions mark as UNCONFIRMED. Apologies for the back and forth but we're having a hard time confirming this one.
Comment 10 baasha 2014-05-23 19:11:06 UTC
Sorry for the delay in getting back to you.  Here is the information you requested:

User interface: Default English USA
Locale: English Canada
Date Acceptance Pattern DD/MM/YY

Under my old profile an entry 23/5 appears in the cell as text 23/5

With a brand new profile entering 23/5 appears in the cell as a date but with the wrong year 23/5/15

New profile entry of 23/5/ appears a a date with the correct year 23/5/14

Upon further investigation it appears the Date Acceptance pattern has an effect on this problem.  Using a new profile I noted that the default date acceptance patterns with the UI and Locale as noted above are: Y-M-D; M-D; M/D.Y; M/D.  To these I added my desired pattern of DD/MM/YY and got the results as shown above.  However, if I removed the default patterns and only used DD/MM/YY then I got 23/5 (no year) when I entered 23/5.  I looked up the format for that cell and it showed as a date (DD/MM/YY).  If I entered 23/5/ I got 23/5/14 with the same formatting as the previous example.

As previous noted in version and earlier, an entry of 23/5 would automatically fill in the year and appear as 23/5/14.
Comment 11 Florian Reisinger 2014-09-04 13:53:14 UTC
In the DE locale the Accaptence pettern are "D.M.Y;D.M."
"12.12.12" -> 12th of December 12
"11.12" -> 11th of  December 14
So Tested with Windows 7 with Version: Build ID: 5ef4bdc7b15686e55fa19f2e98a828763a0cfae6 TinderBox: Win-x86@42, Branch:master, Time: 2014-09-03_10:10:14. Failed reproducing the bug
Comment 12 Robinson Tryon (qubit) 2015-12-15 10:53:34 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)