https://bugs.freedesktop.org/show_bug.cgi?id=82757
--- Comment #1 from Lionel Elie Mamane <[email protected]> --- You are using text controls with an ambiguous format for dates. Don't do that. It is fragile, and has always been. If it worked in your precise setup before, it was by pure luck (or dare I say pure accident). It likely didn't work in previous versions if you only changed the locale of the computer (e.g. from English to German, and with associated default date format from M/D/Y to D/M/Y). I have successfully reproduced the problem in LibreOffice 4.1 in some configurations. The issue resolves around what date is "18/08/14". Depending on context and locale, this could be: * 14 August 18 * 14 August 2018 * 14 August 1918 * 18 August 14 * 18 August 2014 * 18 August 1914 * 8th day of month number 18 of year 14 * 8th day of month number 18 of year 2014 * 8th day of month number 18 of year 1914 And in processing the Commit, several different interpretations are used, some fixed by the SQL standard and some fixed by the current locale and some fixed by the default locale (American English). I regret the fact that several different interpretations are used, but I don't think I can easily fix that. Replace the text field by a Date field (plus a time field), this will be much more robust. An IMHO inferior solution which seems to work is to use a formatted field instead of a text field. Probably (but I didn't check in the code) the formatted field knows its format, so it avoids the issue of several differing string-to-date interpretations. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
