Bug 71885 - Spreadsheet cell date value lag for years with every save. 1:3.5.7-0ubuntu4
Summary: Spreadsheet cell date value lag for years with every save. 1:3.5.7-0ubuntu4
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
(See in Summary)
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-21 16:55 UTC by bugipostit
Modified: 2013-11-22 14:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description bugipostit 2013-11-21 16:55:55 UTC 
Libreoffice will just ruin the dates. 

Case: Spreadsheet document with a certain date column.

1) Value for, say A29, was originally 19.02.2013 when I last time saved.

2) Open the spreadsheet and the date is 18.02.2009

3) Make some modification and save the document

4) Open the document, and the date for A29 is 17.02.2005

5) another iteration and the date will be 16.02.2001


The document is protected with a password.

Version of libreoffice (from dpkg -l) is 1:3.5.7-0ubuntu4
Comment 1 Ady 2013-11-21 22:02:39 UTC 
Thanks for reporting.

Could you please attach a file with the described behavior?

I am setting this as NEEDINFO. When you attach the requested file, please set the status from NEEDINFO back to UNCONFIRMED.

Thank you and Regards,
Ady.
Comment 2 m_a_riosv 2013-11-21 23:55:59 UTC 
I think you need to set up properly the option in:
Menu/Tools/Options/LibreOffice calc/Calculate/Date selecting 01/01/1904.
Please see the help for more information.

Changed to Resolved NotAbug, if you are not agree please reopen it.
Comment 3 bugipostit 2013-11-22 13:24:46 UTC 
(In reply to comment #2)
> I think you need to set up properly the option in:
> Menu/Tools/Options/LibreOffice calc/Calculate/Date selecting 01/01/1904.
> Please see the help for more information.
> 
> Changed to Resolved NotAbug, if you are not agree please reopen it.

The option selected is "01/01/1904".
Comment 4 bugipostit 2013-11-22 14:06:04 UTC 
I'm not sure if I did the previous test correctly, but when I tried this with the original spreadsheet the option was not the "01/01/1904". When I corrected the value the problem disappeared. 

Thanks for the help!