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 Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/391572 Title: [Upstream] Edit Date format does not match configured date format Status in LibreOffice Productivity Suite: Fix Released Status in The OpenOffice.org Suite: Unknown Status in “libreoffice” package in Ubuntu: Fix Committed Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org-calc 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 is expected to be displayed? September 2, 2005: my wedding day. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/391572/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
