| Summary: | Date formatting in Spreadsheet is inconsistent | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | marc sinclair <marcsinclair> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | chris, libreoffice.org |
| Priority: | high | ||
| Version: | 3.3.1 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://launchpad.net/bugs/391572 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
|
Description
marc sinclair
2011-06-06 03:00:28 UTC
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. |