Issue 91856 - date format bug
Summary: date format bug
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2008-07-19 17:25 UTC by stippo
Modified: 2017-05-20 10:27 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 stippo 2008-07-19 17:25:43 UTC
I was so enthused to get openoffice - really, really excited.  Then found the 
dealbreaker.  The date format issue just crushed my dreams.  The U.S. default 
date format issue as described in Wikipedia is a non-starter for the rest of 
the world and some folks in the U.S. too, I'm sure.  It's gotta be able to be 
somehow linked to Regional Options or its useless to any application that's 
heavy into date sensitivity.

What a shame.  Sure hope it's fixed soon.
Comment 1 Regina Henschel 2008-07-19 22:24:33 UTC
I don't understand your description. Please describe step by step. What do you
do, what does OOo show and what do you expect to see.

Because date format depends on language and local please add: What is your
setting in Tools > Options > Language Settings > Languages? What is your setting
in the cell style 'Default' on the Numbers tab in the category All and in the
category Date?

What date format do you have set in operating system? 
Comment 2 stippo 2008-07-20 16:37:43 UTC
Regina, actually, I don't do anything.  Kinda mislead you.  While I was 
enthused to download OOo, I haven't done so because of the following criticism 
in Wikipedia re OO0 Calc.  At the bottom of the entry it states - 

" Calc has been criticized for:

When editing a date, the date is displayed in US date format irrespective of 
the users' Locale, which is surprising given its international aspirations. 
Users can enter ISO 8601 dates, but may only edit them in another format."

I've checked other links re this issue and there are quite a few with the same 
issue stymieing them. 

That's why I'm choosing to hold off until it's fixed. 

Were I to download it, my settings currently within Windows OS are:

Regional and Language Settings - English (Canada) - which has its date values 
set to:

Short Date:  20 Jul 2008

Long Date: Sunday, 20 July 2008

Perhaps if I were running Linux there wouldn't be an issue?
Comment 3 kyoshida 2008-07-20 17:52:16 UTC
Note: this is technically not a valid bug report since the user has not even
used OOo to confirm the validity of an alleged bug.

That said, he is referring to this wikipedia article:

which refers to Issue 5556 about the said bug.

That means this is a duplicate report of Issue 5556.

*** This issue has been marked as a duplicate of 5556 ***
Comment 4 kyoshida 2008-07-20 17:52:50 UTC
closing a dupe.
Comment 5 stippo 2008-07-20 18:04:22 UTC
Sorry, don't know how this works.  But was/is Issue 5556 a valid bug and is it 
being worked on?  Do I continue to follow 5556 to see if/when it's 
resolved/worked around?

Comment 6 kyoshida 2008-07-20 19:15:52 UTC
>Do I continue to follow 5556 to see if/when it's resolved/worked around?

Yes.  You can CC yourself to that bug to track its progress.  You are only
supposed to open a new bug when you encounter a new one yourself, not when you
read a web page that says the bug exists (because the information may not be
current).  If it's still current, then it's likely that the bug has already been
reported so that you don't have to file a new one.
Comment 7 stippo 2008-07-20 19:31:14 UTC
Thanks a lot.