Created attachment 100432 [details] screenshot I can't input "1945-04-02" to cells or functions as a date if timezone is Europe/Paris. But Inputting "1945-04-01" and "1945-04-03" works fine. Step to reproduce: 1. Install libreoffice 4.3 beta1 2. Start scalc with TZ=Europe/Paris as follows: $ TZ=Europe/Paris /opt/libreofficedev4.3/program/scalc 3. Input =DATEVALUE("1945-04-02") to A1 4. The cell shows Err:502 Expected result: The cell shows 16529
Confirmed on Ubuntu Linux 14.04 x86_64
*** This bug has been marked as a duplicate of bug 74869 ***
I was mistaken. It's a not a duplicate of bug 74869. On LibreOffice 4.2.4.2 OpenSUSE Linux 13.1 x64 following combination reproduces this bug: + ------------------------+------------+ | TZ environment variable | Input date | + ------------------------+------------+ | America/Montevideo | 1974-12-22 | | Asia/Colombo | 1942-09-01 | | Atlantic/Azores | 1942-04-25 | | Atlantic/Azores | 1943-04-17 | | Atlantic/Azores | 1944-04-22 | | Atlantic/Azores | 1945-04-21 | | Atlantic/Madeira | 1942-04-25 | | Atlantic/Madeira | 1943-04-17 | | Atlantic/Madeira | 1944-04-22 | | Atlantic/Madeira | 1945-04-21 | | Europe/Gibraltar | 1941-05-04 | | Europe/Gibraltar | 1942-04-05 | | Europe/Gibraltar | 1943-04-04 | | Europe/Gibraltar | 1944-04-02 | | Europe/Gibraltar | 1945-04-02 | | Europe/Gibraltar | 1947-04-13 | | Europe/Madrid | 1942-05-02 | | Europe/Madrid | 1943-04-17 | | Europe/Madrid | 1944-04-15 | | Europe/Madrid | 1945-04-14 | | Europe/Madrid | 1946-04-13 | | Europe/Monaco | 1941-05-05 | | Europe/Monaco | 1942-03-09 | | Europe/Monaco | 1943-03-29 | | Europe/Monaco | 1944-04-03 | | Europe/Monaco | 1945-04-02 | | Europe/Moscow | 1919-05-31 | | Europe/Paris | 1945-04-02 | | Pacific/Apia | 2011-12-30 | | Pacific/Enderbury | 1995-01-01 | | Pacific/Fakaofo | 2011-12-30 | | Pacific/Kiritimati | 1995-01-01 | | Pacific/Kwajalein | 1993-08-20 | + ------------------------+------------+ I think Bug 63230 is closely related to this bug because the patch uploaded by Bug 63230 Comment 9 also fixes this bug.
Strange bug, I reproduce the problem with LO 4.3.0.0beta2+ under Ubuntu 14.04 x86-64, Build ID: a442091e3a66b33ecbd461de3fe9afd7add5b107 Works for 1945-04-01 and 1945-04-03 but not for 1945-04-02. Best regards. JBF
Problem already there in LO 4.0.6 (x86-64 generic Linux version). Set version accordingly. Best regards. JBF
Fixed with bug 63230 *** This bug has been marked as a duplicate of bug 63230 ***
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 "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.