Bug 78414 - Dates decrement themselves when spreadsheet is updated after FILESAVE
Summary: Dates decrement themselves when spreadsheet is updated after FILESAVE
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.2.2 release
Hardware: x86 (IA32) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-08 00:21 UTC by Brian
Modified: 2014-08-22 20:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
This is a copy of my actual bank spreadsheet from which personal data has been replaced with dummy data and example data. (97.10 KB, application/vnd.sun.xml.calc)
2014-05-08 00:21 UTC, Brian
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Brian 2014-05-08 00:21:27 UTC
Created attachment 98649 [details]
This is a copy of my actual bank spreadsheet from which personal data has been replaced with dummy data and example data.

When the FORMAT CELLS is set to DATE and the date is entered as year (dot) month (dot) day (e.g. 2014.05.08), the spreadsheet is saved and closed then reopened again either same day or some number of days later, the date is decremented by two days (e.g. 2014.05.06).  The bug manifests by decrementing the date by two days each time an entry is made or modified, and does not matter whether the year month date are separated by a dot (.) slash (/) or hyphen (-).

Under the FORMAT CELLS options, I have the date Format Code set as YYYY"年"MM"月"DD"日" so that it shows me the year followed by the Japanese character for year, then the month followed by the character for month, and date followed by character for date.

When I type "locale" in a terminal, the result returned is: 
LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC=ja_JP.UTF-8
LC_TIME=ja_JP.UTF-8
LC_COLLATE="en_US.UTF-8"
LC_MONETARY=ja_JP.UTF-8
LC_MESSAGES="en_US.UTF-8"
LC_PAPER=ja_JP.UTF-8
LC_NAME=ja_JP.UTF-8
LC_ADDRESS=ja_JP.UTF-8
LC_TELEPHONE=ja_JP.UTF-8
LC_MEASUREMENT=ja_JP.UTF-8
LC_IDENTIFICATION=ja_JP.UTF-8
LC_ALL=
Comment 1 Isamu Mogi 2014-06-15 12:13:59 UTC
Hi Braian,
This bug may be fixed in LibreOffice 4.0.4 (bug 59850).
Comment 2 Isamu Mogi 2014-06-15 12:23:25 UTC
Oops sorry, I missed that it occurs in Linux. And bug 59850 is Windows specific.
Comment 3 raal 2014-08-07 16:32:24 UTC
Hello,
the file format is .sxc, with LO 4.2 this format is not editable. I can not reproduce bug after resave to .ods format (linux, LO 4.2.4). Please could you test with newer version LO if bug still occurs?
Thank you
Comment 4 Brian 2014-08-10 00:50:43 UTC
Hello

In the meanwhile, I have also updated my software to L.O. 4.2.4.2 and therefore I am also unable to save in the .sxc format.  The same spreadsheet saved in .ods format does not produce the bug on my system either, so all is well on my side.  

Thank you for for your effort in looking into the matter.
Comment 5 raal 2014-08-22 20:52:11 UTC
Closing bug, in new version problem does not occurs.