[Libreoffice-bugs] [Bug 49745] FORMATTING Date parsing does not honour date format setting
https://bugs.freedesktop.org/show_bug.cgi?id=49745 Eike Rathke er...@redhat.com changed: What|Removed |Added Platform|Other |All Status|UNCONFIRMED |RESOLVED Resolution||NOTABUG Keywords|NEEDINFO| --- Comment #3 from Eike Rathke er...@redhat.com 2012-05-15 11:31:37 PDT --- That is because the en_CA locale's date order is YMD, not DMY. Probably previously you were working in an en_US locale with date order MDY, for which input of D-MMM-YY was accepted as expected as it is unambiguous. There's not much we can do about. For ambiguous input the locale's date order takes precedence over the applied format, as otherwise with an empty cell the user has no hint of what the input should look like. An unambiguous input in your case would be 11-May-2012 with four digit year. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 49745] FORMATTING Date parsing does not honour date format setting
https://bugs.freedesktop.org/show_bug.cgi?id=49745 --- Comment #4 from Dan Ciarniello da...@ciarniello.ca 2012-05-15 14:27:10 PDT --- The date I entered is only ambiguous in the absence of a format code. If this is not a bug then it is a design flaw. It would be a reasonable assumption that if one wants to display dates in a given format then one would also want to be able to enter dates in that format. It would make more sense to try to parse a date against the desired format and failing that, use the locale's date order. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 49745] FORMATTING Date parsing does not honour date format setting
https://bugs.freedesktop.org/show_bug.cgi?id=49745 Eike Rathke er...@redhat.com changed: What|Removed |Added Keywords||NEEDINFO --- Comment #1 from Eike Rathke er...@redhat.com 2012-05-11 03:07:23 PDT --- Which locale are you working in, and which locale is the date format chosen in? And until recently exactly means what? It stopped working with 3.4.5.2-13.fc16? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 49745] FORMATTING Date parsing does not honour date format setting
https://bugs.freedesktop.org/show_bug.cgi?id=49745 --- Comment #2 from Dan Ciarniello da...@ciarniello.ca 2012-05-11 09:07:09 PDT --- I thought that this was caused by the latest Fedora update because of the timing of the update and my noticing the problem but it wasn't. It looks like it is a locale issue. Here are the steps to reproduce the behaviour: 1. Set the locale to English(Canada) 2. Go to Format|Cells and enter a format code of DD-MMM-YY 3. Type 11-May-12 and hit enter 4. Note that the date is parsed as 2011-05-12 The expected value is, of course, 2012-05-11. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs