Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Formula bar: ability to set default date format on formula bar | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | bijugc <bijumaillist> | ||||||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||||||
Status: | CONFIRMED --- | QA Contact: | |||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | elish, issues, kpalagin, rb.henschel | ||||||||
Version: | OOo 2.3.1 RC1 | ||||||||||
Target Milestone: | --- | ||||||||||
Hardware: | All | ||||||||||
OS: | Windows XP | ||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Issue Depends on: | 51662 | ||||||||||
Issue Blocks: | |||||||||||
Attachments: |
|
Description
bijugc
2007-12-10 08:36:13 UTC
Created attachment 50198 [details]
RegionalOptions.png
Created attachment 50199 [details]
OOoCalcDate.png
Created attachment 50200 [details]
excel.png
I think this issue in essence is duplicate to http://qa.openoffice.org/issues/show_bug.cgi?id=51662. *** This issue has been marked as a duplicate of 51662 *** Closing. Please vote for 51662. Fix for issue 51662 may fix this. But 51662 is only talking about the decimals As issue 50670, issue 39898, issue 38494, issue 31663, issue 45312, issue 1820 are similar and some of them are fixed, but it did not automatically fix issue 51662. Hence I am little skeptical about this getting fixed automatically when 51662 get fixed. So I am reopening this and adding this as depended to 51662, we should only close this after testing and find it got fixed. I agree that this issue needs to be tested after 51662 gets fixed. I am having similar problems on an Ubuntu machine running KDE. Calc does not respect the locale's LC_TIME setting for date formatting in the edit bar. Dates are always formatted MM/DD/YYYY regardless of locale. In this example, I use locale "en_DK.utf8" which has the date format YYYY-MM-DD. $ locale LANG=en_DK.utf8 LANGUAGE=en_DK.utf8 LC_CTYPE="en_DK.utf8" LC_NUMERIC="en_DK.utf8" LC_TIME="en_DK.utf8" LC_COLLATE="en_DK.utf8" LC_MONETARY="en_DK.utf8" LC_MESSAGES="en_DK.utf8" LC_PAPER="en_DK.utf8" LC_NAME="en_DK.utf8" LC_ADDRESS="en_DK.utf8" LC_TELEPHONE="en_DK.utf8" LC_MEASUREMENT="en_DK.utf8" LC_IDENTIFICATION="en_DK.utf8" LC_ALL=en_DK.utf8 $ openoffice.org2.3 -calc Now, I select column A -> Format Cells -> Numbers -> Category -> Date -> Format -> 1999-12-31. I now enter "2008-01-16" into cell A1 and hit enter. The cursor moves to cell A2 and I see "2008-01-16" in cell A1. So far so good. Now, I click on cell A1. The cell still says "2008-01-16" however the input line reads "01/16/2008". The edit bar should format dates as they are formatted for display in the cell. Failing that, it should display in the locale's preferred format. Note: the problem _may_ be that Gnome's date format is not configured properly. I use KDE on Ubuntu, with Gnome installed as the default desktop. However, due to a poorly written ATI driver I cannot open Gnome and change the setting. Googling and locating has not led me to discover which config file I should edit in VI to change this setting. In any case, Gnome's setting should _not_ be the deciding factor in which date format to use. Not everyone uses Gnome, and that is specifically what LC_TIME is for. *** Issue 85361 has been marked as a duplicate of this issue. *** Please have a look at issue 5556 and issue 72229. You should move with your votes to one of them. I think this issue is duplicate to issue 5556 and it should be closed therefore. Actually, as this issue is requesting a separately configurable date format for the formula bar, I think it is a dupe of bug 72229. Bug 5556 requests that the formula bar use the same date format as the cell is configured for. At least, that is the difference that I perceive between the two bugs. EVEN WORSE: I opened one of those XLS files with dates. I MANUALLY selected all cells contained dates and did "format cells" and selected "date" and "31/12/2010". Then I entered some more data into the document and the disastrous spontaneous change didn't happen, even after scrolling, so the workaround seemed to have worked. Then as soon as I SAVED the document, all dates were changed to numbers. There's NO WAY to keep updating an old XLS file generated with a previous version. This makes OpenOffice Calc unusable. I'll look for another spreadsheet program. ** SORRY I DIDN'T MEAN TO POST IT HERE ** Please delete my previous comment. I thought I was editing another issue, not this one. I posted it here by mistake. (Shame that one cannot edit or delete his/her own comments btw) cell = 2007-11-30 bar = 11/30/2007 Rev. 1520602 Win 7 |