https://issues.apache.org/ooo/show_bug.cgi?id=125135
Issue ID: 125135
Issue Type: DEFECT
Summary: Input in ISO date format is not recognized as a date
depending on TimeZone
Product: Calc
Version: 4.1.0
Hardware: PC
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83588
--> https://issues.apache.org/ooo/attachment.cgi?id=83588&action=edit
screenshot
In OpenSUSE Linux 13.1 x64, 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. Start scalc with LC_ALL=en_US TZ=Europe/Paris as follows:
$ LC_ALL=en_US TZ=Europe/Paris /opt/openoffice4/program/scalc
2. Input =DATEVALUE("1945-04-02") to A1
3. The cell shows Err:502
Expected result:
The cell shows 16529
Also, following combination reproduces the 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/Enderbury | 1995-01-01 |
| Pacific/Kwajalein | 1993-08-20 |
+ ------------------------+------------+
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
