Issue 125135 - Input in ISO date format is not recognized as a date depending on TimeZone
Summary: Input in ISO date format is not recognized as a date depending on TimeZone
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0
Hardware: PC Linux, all
: P3 Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-06-22 05:33 UTC by Isamu Mogi
Modified: 2014-07-19 21:12 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
screenshot (31.68 KB, image/png)
2014-06-22 05:33 UTC, Isamu Mogi 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Isamu Mogi 2014-06-22 05:33:52 UTC 
Created attachment 83588 [details]
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 |
+ ------------------------+------------+
Comment 1 Joe Smith 2014-07-19 00:43:43 UTC 
Testing AOO 4.1 on Fedora Linux:

I see the problem when using =DATEVALUE("1945-04-02") but not when I just enter the date directly, in ISO format: 1945-04-02

If I enter the date in US format, 4/2/45, then it is not recognized as a date and goes in as literal text.

Is it valid to set LC_ALL and TZ to incongruous values? I don't know.
Comment 2 Kay 2014-07-19 21:12:46 UTC 
I think this may be tied to your settings for dates.

Using openSUSE, 12.3 with 4.1.1M2.

In my case, I had US mm/dd/yy setting, and when I input 1945-04-02, it converted to 04/02/45.

Look at Format-> Cells -> Number -> Date to see what your current setting is.