[Bug 391572] Re: [Upstream] Edit Date format does not match configured date format
Launchpad has imported 47 comments from the remote bug at https://issues.apache.org/ooo/show_bug.cgi?id=5556. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2002-06-04T20:50:45+00:00 Njglin wrote: When a cell date format is set to -mm-dd, the input line will show US format mm/dd/. Also, when the cell is doubleclicked it also changes to US format (from -mm-dd) until Enter is pressed. To reproduce: 1. Open a new spreadsheet. 2. Format a cell A1 to Date in the format -mm-dd - Highlight cell A1 - on the menu select "format->cells..." - select Category: Date Format : 1999-12-31 Language: Default Note: The Format Code shows -MM-DD 3. In the cell enter date 2002-06-04; press "Enter" 4. Highlight the cell again THE INPUT LINE SHOWS DATE AS: 06/04/2002 5. Doubleclick the cell THE CELL SHOWS DATE AS: 06/04/2002 A. The cell should ALWAYS show the date in the format set for the cell. B. The input line should ALWAYS show the date in the format set for the cell. My OS is Windows 2000 US version. The regional options are: -General - Your locale: English (United States) -Date - Short date format: -MM-dd - Long date format: , dd , (since -mm-dd, is not available) Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/0 On 2002-06-10T10:13:52+00:00 Peter-junge wrote: I'll have a look, Peter Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/1 On 2002-09-25T14:09:43+00:00 Peter-junge wrote: @Jacek: AFAIK the current behaviour is right and desired. In edit mode the cell always shows the default format because the user should see the exact content. Example: Fill two cells with your example (06/04/2002) and my example (04/13/2002) and format both as 'QQ YY'. If we would use the edit view you're suggesting you couldn't tell any difference between both cells. Peter Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/2 On 2003-02-10T16:33:13+00:00 Peter-junge wrote: no further comment -> closed Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/3 On 2005-03-09T22:21:19+00:00 Njglin wrote: Peter refers to my example wrongly. My example is 2004-04-29 format type. Just checked 2.0 Beta obtained from Openoffice.org(shows as Staroffice 8 Beta). Behaviour is the same as described in the problem description. In Short: If I format cells to use -MM-dd format then this format should be used and displayed consistently and always. Both in the cell, even when double clicked, as well as in the input line. I hope this bug can still make 2.0 release Trying to change a date when one format is displayed, but then another when trying to edit the cell is very trying. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/4 On 2005-03-31T08:08:15+00:00 Frank-l wrote: *** Issue 46348 has been marked as a duplicate of this issue. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/5 On 2005-09-14T16:53:57+00:00 Peter-junge wrote: Because this behaviour is currently intended it shoud be handled as requirement. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/6 On 2006-03-07T13:22:43+00:00 Frank-l wrote: *** Issue 61720 has been marked as a duplicate of this issue. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/7 On 2007-09-07T10:07:20+00:00 Frank-l wrote: *** Issue 79609 has been marked as a duplicate of this issue. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/391572/comments/8 On 2007-11-10T14:26:00+00:00 Marcsinclair wrote: Hi, Is anything going to be done about this obvious flaw? at the very least the default format should be the machine locale setting. as it is the odd format used is at best annoying and practically unusable for most of th
[Bug 391572] Re: [Upstream] Edit Date format does not match configured date format
Fixed as per upstream 3.5.0 released with precise. ** Changed in: libreoffice (Ubuntu) Status: Fix Committed => Fix Released ** Changed in: libreoffice (Ubuntu) Assignee: (unassigned) => Björn Michaelsen (bjoern-michaelsen) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: [Upstream] Edit Date format does not match configured date format To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/391572/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 391572] Re: [Upstream] Edit Date format does not match configured date format
Launchpad has imported 6 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=37978. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2011-06-06T10:00:28+00:00 Marcsinclair wrote: After nearly TEN YEAR of this BUG in Open Office - perhaps Libreoffice has the will to do something about it - The issue is that date handling in the spreadsheet is a dogs breakfast. 1 - Open a new Spreadsheet on a machine with ISO dates as the native date format 2 - Enter the (valid) date 2011-06-05into a cell 3 - Press return 4 - cell shows 05/06/11 (whatever that means, is it May, June or November?) 5 - Select the cell 6 - The Input line now says 05/06/2011 (aha! so it is either May or June) 7 - Double click the cell and it changes to the second format 02/01/2008 trying to edit in this unusual format is problematic and almost useless for practical puposes. Marc Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/1 On 2011-06-06T10:06:13+00:00 Marcsinclair wrote: After nearly TEN YEAR of this BUG in Open Office - perhaps Libreoffice has the will to do something about it - The issue is that date handling in the spreadsheet is a dogs breakfast. 1 - Open a new Spreadsheet on a machine with ISO dates as the native date format 2 - Enter the (valid) date 2011-06-05into a cell 3 - Press return 4 - cell shows 05/06/11 (whatever that means, is it May, June or November?) 5 - Select the cell 6 - The Input line now says 05/06/2011 (aha! so it is either May or June) 7 - Double click the cell and it changes to the second format 05/06/2011# trying to edit in this unusual format is problematic and almost useless for practical purposes. Marc Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/2 On 2011-12-21T17:04:06+00:00 Erack wrote: *** Bug 41042 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/4 On 2011-12-21T17:08:39+00:00 Erack wrote: Fixed in master http://cgit.freedesktop.org/libreoffice/core/commit/?id=6c37252eb93db161edfd234696604774e9ee1d8c and 3-5 http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5&id=9c1d304d0df21b6ae63dbd4db737f0d21a51f227 Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/5 On 2011-12-21T18:42:27+00:00 Freedesktop-org wrote: > Fixed in master > I cannot believe it! This has been one of three or four serious show- stoppers in OOo for the organizations where I have integrated OOo. I really thought that we would never see it fixed. Eike, your work is very, very appreciated! Thank you! Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/6 On 2011-12-22T11:09:12+00:00 Mike Evans wrote: Thank you for fixing this bug. I too have been waiting many years for this fix. Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/391572/comments/9 ** Changed in: df-libreoffice Status: Unknown => Fix Released ** Changed in: df-libreoffice Importance: Unknown => High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: [Upstream] Edit Date format does not match configured date format To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/391572/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 391572] Re: [upstream] Edit Date format does not match configured date format
** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Summary changed: - [upstream] Edit Date format does not match configured date format + Edit Date format does not match configured date format -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: Edit Date format does not match configured date format To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/391572/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 391572] Re: [upstream] Edit Date format does not match configured date format
** Also affects: df-libreoffice Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: [upstream] Edit Date format does not match configured date format To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/391572/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 391572] Re: [upstream] Edit Date format does not match configured date format
** Changed in: openoffice.org (Ubuntu) Status: Triaged => Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: [upstream] Edit Date format does not match configured date format To manage notifications about this bug go to: https://bugs.launchpad.net/openoffice/+bug/391572/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 391572] Re: [upstream] Edit Date format does not match configured date format
** Changed in: openoffice Status: Unknown => Confirmed -- [upstream] Edit Date format does not match configured date format https://bugs.launchpad.net/bugs/391572 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs