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
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
*** Bug 41042 has been marked as a duplicate of this bug. ***
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
> 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!
Thank you for fixing this bug. I too have been waiting many years for this fix.