Bug 75404 - Problem in CALC with date 1st of May 1921
Summary: Problem in CALC with date 1st of May 1921
Status: RESOLVED DUPLICATE of bug 74869
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-23 17:39 UTC by Erkki
Modified: 2014-03-04 20:26 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Bug shown in a Calc document (11.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-23 18:30 UTC, Erkki
Details
Screenshot how I see. (257.60 KB, image/png)
2014-02-24 21:08 UTC, m_a_riosv
Details
Time zone UTC+2 Helsinki, Kiev, Riika, Tallinna, Vilna (19.01 KB, image/png)
2014-03-04 19:24 UTC, Erkki
Details
Time zone UTC+2 Jerusalem (23.31 KB, image/png)
2014-03-04 19:28 UTC, Erkki
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Erkki 2014-02-23 17:39:14 UTC
When writing in CALC the date May 1st 1921 (1.5.1921) CALC shows 30.4.1921

When making a list of dates, Calc shows 2 times 30.4.1921
26.04.1921
27.04.1921
28.04.1921
29.04.1921
30.04.1921
30.04.1921
02.05.1921
03.05.1921
04.05.1921

24. huhtikuuta 1921
25. huhtikuuta 1921
26. huhtikuuta 1921
27. huhtikuuta 1921
28. huhtikuuta 1921
29. huhtikuuta 1921
30. huhtikuuta 1921
30. huhtikuuta 1921
2. toukokuuta 1921
3. toukokuuta 1921
4. toukokuuta 1921
5. toukokuuta 1921
Comment 1 m_a_riosv 2014-02-23 18:00:51 UTC
Hi Erkki, thanks for reporting.

Please could you verified if it is same issue as here:
https://bugs.freedesktop.org/show_bug.cgi?id=74869
Comment 2 Erkki 2014-02-23 18:30:02 UTC
Created attachment 94615 [details]
Bug shown in a Calc document

May 1st is missing for the year 1921.
Instead 2 times 30.4.1921.

May 1st is present at other years.
Comment 3 Erkki 2014-02-23 18:33:15 UTC
Hi

I do not think that Bug 75404 is the same as Bug 74869.

I addes a file to the bug report.

Best regards Erkki

23.2.2014 20:00, bugzilla-daemon@freedesktop.org kirjoitti:
> m.a.riosv <mailto:mariosv@miguelangel.mobi> changed bug 75404
> <https://bugs.freedesktop.org/show_bug.cgi?id=75404>
> What 	Removed 	Added
> Status 	UNCONFIRMED 	NEEDINFO
> CC 	  	mariosv@miguelangel.mobi
> Ever confirmed 	  	1
> 
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=75404#c1> on
> bug 75404 <https://bugs.freedesktop.org/show_bug.cgi?id=75404> from
> m.a.riosv <mailto:mariosv@miguelangel.mobi> *
> 
> Hi Erkki, thanks for reporting.
> 
> Please could you verified if it is same issue as here:
> https://bugs.freedesktop.org/show_bug.cgi?id=74869 <show_bug.cgi?id=74869>
> 
> ------------------------------------------------------------------------
> You are receiving this mail because:
> 
>   * You reported the bug.
>
Comment 4 m_a_riosv 2014-02-23 19:48:25 UTC
Please don't answer through the email, usually makes unreadable the report, if you can answer here with a new comment, and you can attach the sample files here.

Also please report what is the User Interface that you are using and what is your time zone?
Comment 5 Erkki 2014-02-24 09:25:52 UTC
This problem is visible in 
Windows 7, 64 bit Finnish language
LibreOffice 4.1.5.3 Finnish language
Time Zone UTC+2 Helsinki

Problem is also visible in Windows 8, 64 bit, Finnish
LibreOffice 4.1.4.2 Finnish language
Time Zone UTC+2 Helsinki

Problem does not appear in Windows XP, 32 bit
LibreOffive 4.0.4.2
Same languages and time zone as above.
Nor it did not show up in Linux Ubuntu Live CD 12.04.4
Comment 6 m_a_riosv 2014-02-24 21:08:49 UTC
Created attachment 94685 [details]
Screenshot how I see.

As in the attached screenshot, I can't reproduce the issue, with Finnish UI+locale and time zone Helsinki.

Please try resetting the user profile, sometimes solve strange issues.
Comment 7 Julien Nabet 2014-02-24 22:17:21 UTC
Just to complete the Mario's comment, you'll find more information about LO directory profile here:
https://wiki.documentfoundation.org/UserProfile
Comment 8 m_a_riosv 2014-02-24 22:19:56 UTC
Thanks Julien, I forgot the link.
Comment 9 Erkki 2014-02-25 13:28:57 UTC
Hi
I did resetting of the user profile.
No help. The same behavior still.
It is enough you type the date 1.5.1921 (day.month.year) in a cell in LibreOffice CALC and immediately when clicking with mouse elsewhere the cell contents turns to 30.4.21 or 30.4.1921.

I have made a few other tests with other computers.
The same problem with 
Windows 8.1 64 bit, Swedish language, 
LibreOffice 4.2.1.1, Swedish language
This is a fresh installation, the whole PC is only 4 days old.
Time zone UTC+2 Helsinki

Also the same problem with normally installed Linux Ubuntu 12.04.4
Fresh installation mid February 2014 to that level, all updates installed after installation.
Finnish language, time zone UTC+2 Helsinki.

All LibreOffice Windows installation are from here http://fi.libreoffice.org/ 

Br Erkki
Comment 10 Erkki 2014-02-25 16:34:54 UTC
Forgot to say that the Linux Ubuntu 12.04.4 is 32 bit version.
Comment 11 Erkki 2014-03-04 19:24:48 UTC
Created attachment 95114 [details]
Time zone UTC+2 Helsinki, Kiev, Riika, Tallinna, Vilna
Comment 12 Erkki 2014-03-04 19:27:19 UTC
I made a few tests again.
Appeared that the problem exists (in Windows 7) if the time zone is UTC+2 Helsinki, Kiev, Riika, Tallinna, Vilna.

When I changed the time zone to anything else, even to e.g. UTC+2 Jerusalem, there is no problem in CALC.

Attached 2 screenshots.

I have not tested with Linux.
Comment 13 Erkki 2014-03-04 19:28:32 UTC
Created attachment 95115 [details]
Time zone UTC+2 Jerusalem
Comment 14 m_a_riosv 2014-03-04 20:26:39 UTC
Then I think it is same issue, at least the same root as in https://bugs.freedesktop.org/show_bug.cgi?id=74869, OS time zone affects some dates.

Please if you are not agree, reopen it.

*** This bug has been marked as a duplicate of bug 74869 ***