with French regional settings the function DATEVAL("02.04.1945") gives an error: 502 instead of code 16529 OK for the other dates
Same as bug 79663, but this one (dup of 63230) is tagged fixed in 4.5. It seems that he cames back. Reproducible also with 5.0.6
So let's put regression here.
=DATEVALUE("01.04.1945") gives 16528 =DATEVALUE("02.04.1945") fails with Err:502 =DATEVALUE("03.04.1945") gives 16530
Investigating.
Actually any of "01.04.1945" or "02.04.1945" or "03.04.1945" is an invalid date input in a French fr-FR locale and consistently I get Err:502 for all three function calls, not only for "02.04.1945". fr-Fr date pattern is M/D/Y However, it does work if under Tools - Options - Language Settings - Languages the "Date acceptance pattern" includes D.M.Y and with that I get 16528, 16529 and 16530. Note that using the ISO 8601 notation works in all locales, =DATEVALUE("1945-04-02") BUT, with TZ=Europe/Paris that one results in error. Not a regression though because the date input as of bug 79663 still works. Likely DATEVALUE("1945-04-02") never worked with TZ=Europe/Paris but has a similar cause.
(In reply to Eike Rathke from comment #5) > Not a regression though because the date input as of bug 79663 still works. > Likely DATEVALUE("1945-04-02") never worked with TZ=Europe/Paris but has a > similar cause. Darn, or maybe not. Date input results in string instead of date serial number.
Great fun.. on 1945-04-02 02:00:00 Paris entered a Double DST – Clocks were turned ahead another hour when DST was already in force (2 hours ahead of standard time). Single DST of 1944 actually was never ended. See https://www.timeanddate.com/time/change/france/paris?year=1945 https://www.timeanddate.com/time/change/france/paris?year=1944 Likely this confuses the "set 1945-04-02 00:00:00 and if the result differs resubmit corrected by the reported timezone and DST values" approach.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=22dceea0ca3cd68463e390395aa8de479b680240 add test data from tdf#79663, tdf#100046 related It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8e91b0177cbf6554acf7ccfbcc573f647e7fcf4d Resolves: tdf#100046 the dreaded 1945-04-02 Double DST, also tdf#79663 It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=157b56a049a9a5f868d1f3b9856a631a40043a14 activate the remaining 1945-04-02 test cases, tdf#100046 It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/27559 for 5-2
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8ae23d952433fbc07cb13364619d316f15bbac92&h=libreoffice-5-2 Resolves: tdf#100046 the dreaded 1945-04-02 Double DST, also tdf#79663 It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.