Issue 117578 - Incorrect Display of Custom Date Format
Summary: Incorrect Display of Custom Date Format
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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