Issue 117578 - Incorrect Display of Custom Date Format
Summary: Incorrect Display of Custom Date Format
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.3 RC9
Hardware: PC Windows XP
: P4 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-03-28 14:52 UTC by t555764a
Modified: 2013-08-13 08:47 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

cell format image showing problem (42.58 KB, image/png)
2011-03-28 14:52 UTC, t555764a
no flags Details
Input line date wrong (183.24 KB, image/jpeg)
2013-08-13 08:46 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description t555764a 2011-03-28 14:52:10 UTC
Created attachment 76204 [details]
cell format image showing problem

a custom date format: DD-MMM-YY is created and applied to a cell. A date
(25-Mar-11)is entered into the cell. The date displays as: 2011-03-25 in the formula bar, but displays as: 11-Mar-25 in the cell. Date calculations using the cell date, use 11-Mar-25 for the calculation, rendering all calculations incorrect.

See attached image.
Comment 1 ooo 2011-03-29 10:36:38 UTC
It's hard to believe that the input line displayed 2011-03-25 while the DD-MMM-YY format displayed 11-Mar-25, I think the input line displayed 2025-03-11 instead.

Note that parsing the cell input attempts to follow the YMD order of the locale set, here English_Canada that uses YYYY-MM-DD ISO date format, so an input of 25-Mar-11 is parsed as 2025-Mar-11. The cell display format is not a data input mask.
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:18:52 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 Edwin Sharp 2013-08-13 08:46:49 UTC
Created attachment 81324 [details]
Input line date wrong
Comment 4 Edwin Sharp 2013-08-13 08:47:53 UTC
see attachment 81324 [details].

Rev. 1507307 Win 7