Issue 103041 - Date edit format does not match configured date format
Summary: Date edit format does not match configured date format
Status: CLOSED DUPLICATE of issue 5556
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: oooqa
Depends on:
Reported: 2009-06-23 15:06 UTC by Dotan Cohen
Modified: 2009-06-23 21:11 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Dotan Cohen 2009-06-23 15:06:40 UTC
When editing a date in Calc, the date format used to edit the date does not
match the date format configured for the cell.

Steps to reproduce:
1) Right-Click on a cell -> Format Cells -> Numbers -> Category -> Date ->
Choose format 31/12/1999
2) Enter into that cell my wedding day: September 2, 2005: 2/9/2005

What is displayed?
February 9, 2005: the day of a car bombing.

What did I expect to be displayed?
September 2, 2005: my wedding day.

I presume that Calc is using the OS's configured locale for entering dates,
alas, this is _not_ the expected behaviour. I expect the OS's configured locale
to be used right up until the point that the user configures a different format.
When that different format is configured, I expect it to be used in all relevant
situations. That means both viewing _and_ editing.

Comment 1 Dotan Cohen 2009-06-23 15:14:17 UTC
This was tested on Kubuntu 9.04 with OOo 3.1.

jaunty2@laptop:~$ locale

Note that the point of this bug is that when the user configures a date format
for a cell, it should be used instead of the locale default. So please do not
close this bug on account that OOo is using the locale default. It should not do
that once the user has configured a different date format. Thanks.
Comment 2 Regina Henschel 2009-06-23 18:57:48 UTC
This problem has been reported already. Issue 5556 and issue 72229 are
candidates for duplicate. Please decides yourself, which to use.
Comment 3 Dotan Cohen 2009-06-23 20:49:47 UTC
Thanks, Regina, I was certain that I had seen this reported once. I was
searching on the wrong keywords, apparently.
Comment 4 Dotan Cohen 2009-06-23 20:55:56 UTC
I have tried twice to mark as dupe, but it appears that I do not have the
permissions for that (even though I have the interface). Please mark as a dupe
of bug 5556. Thanks.
Comment 5 Regina Henschel 2009-06-23 21:11:28 UTC
set as duplicate to issue 5556

*** This issue has been marked as a duplicate of 5556 ***
Comment 6 Regina Henschel 2009-06-23 21:11:59 UTC
closing, duplicate