Issue 116960 - Date cell decremented by 1462 when file opened
Summary: Date cell decremented by 1462 when file opened
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO330m20
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-14 17:58 UTC by steve73
Modified: 2017-05-20 09:57 UTC (History)
3 users (show)

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

Attachments
Spreadsheet containing decremented date cell (12.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-02-14 18:00 UTC, steve73 		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 steve73 2011-02-14 17:58:26 UTC 
I created a spreadsheet from a CSV file and saved it in ODS format. The sheet
contains a date cell (as well as other data!). 

When I make a change to the sheet, save it and later on reopen it, the value in
the date cell has been decremented by 1462 (just over 4 years). If I make
another change to the sheet, save it and reopen it, again the value in the date
cell is decremented by 1462. I started with a date cell having a year value of
2010 and after a number of edit save-open-cycles I now have a date cell with a
year value of 1982.

At no time do I make a direct edit of the date cell.

I notice that someone else reported a vaguely similar issue no.106789 sometime ago.

This problem seems different in that the date cell is affected when the sheet is
change, saved and reopened.
Comment 1 steve73 2011-02-14 18:00:36 UTC 
Created attachment 75841 [details]
Spreadsheet containing decremented date cell
Comment 2 ooo 2011-02-15 11:48:24 UTC 
Sounds pretty much like issue 115028.

@steve73: Can you please check if the date isn't changing anymore if the date
basis is set to 1899-12-30 before loading the document, as lined out in that issue?
Comment 3 Rob Weir 2013-07-30 02:14:43 UTC 
Reset assignee on issues not touched by assignee in more than 2000 days.
Comment 4 Edwin Sharp 2013-11-15 13:16:39 UTC 
Column C dates are unaffected by a change, save and reopen.

AOO410m1(Build:9750)  -  Rev. 1537113
Rev.1537113
Win 7