Issue 110020 - Exporting cell in date format yyyy.mm.dd fails for pre 1900's
Summary: Exporting cell in date format yyyy.mm.dd fails for pre 1900's
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO320m12
Hardware: HP (PA-RISC) Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-10 14:56 UTC by johnds
Modified: 2013-08-08 09:50 UTC (History)
2 users (show)

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

Attachments
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 johnds 2010-03-10 14:56:49 UTC 
I have a spreadsheet with one column defined as date in the format yyyy.mm.dd

If I enter dates from before the 1900 century , e.g. 1873-04-18, and export the 
sheet to EXCEL the cell gets corrupted with ####### (actual -9752). The actual 
value seems to be the result of a calculation.
Comment 1 johnds 2010-03-10 15:53:10 UTC 
Same problem using the Sun ODF Plugin for Microsoft Office 3.2 to import ODF
into Excel 2003 SP3.
Comment 2 johnds 2010-03-12 10:13:01 UTC 
I realize that Excel doesn't seem to be able to handle dates earlier than Jan 1,
1900.

Maybe there a warning should be omitted, when a user tries to export dates
before jan 1, 1900.
Comment 3 Edwin Sharp 2013-08-08 09:50:58 UTC 
Format cells to YYYY.MM.DD
Type 1873-04-18
result is 1873.04.17

Rev. 1507307 Win 7

PS open in Excel 2007 gives -1930.09.13 with Use 1904 date system.