Issue 80484 - SYLK: date export from Mac Quicken as Excel import as incorrect value
Summary: SYLK: date export from Mac Quicken as Excel import as incorrect value
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-08 20:18 UTC by pedz
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Report generated by Quicken that is suppose to be in Excel format (2.52 KB, text/spreadsheet)
2007-08-08 20:20 UTC, pedz 		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 pedz 2007-08-08 20:18:39 UTC 
I found this while testing on the new Mac Aqua build 20070630 but it was verified by someone else 
running on Linux.

I exported a report as an Excel spreadsheet from Mac Quicken 2007.  The top row is a sequence of 
dates.  When I opened the spreadsheet in OOo, the dates along the top read 1/1/03 2/1/03, etc.  They 
should be 2007.

I sent the file to another person.  He reported that the file opened as I described on his version of OOo 
running on Linux.  He also reported that the file opened properly on MS Excel running on a PC.

I was going to attach the file but, so far, I do not see how to do that.
Comment 1 pedz 2007-08-08 20:20:31 UTC 
Created attachment 47404 [details]
Report generated by Quicken that is suppose to be in Excel format
Comment 2 frank 2007-08-08 21:23:57 UTC 
Hi,

not a bug from OOo. The zero date from Excel on Mac is 01/01/1904 . This is
different to >Calc and more important also to Excel on x86. 

See my comment in desc5 of Issue 73810 too.

Frank
Comment 3 frank 2007-08-08 21:24:37 UTC 
closed invalid
Comment 4 pedz 2007-08-08 21:51:38 UTC 
All technical messmash aside, it is not trustworthy as it sits not.

You are going to have a hard uphill battle winning people over if people do not trust its ability to convert 
from Excel format.  If there is a problem, you have to at least warn people that the dates are screwed up.  
You can't just accept it without an error.
Comment 5 frank 2007-08-09 10:32:44 UTC 
Hi Eike,

Daniel told me that the file isn't an binary Excel but an SYLK file. Excel sets
the zero date for this file to 1904. Daniel thinks that this is a default by
Excel for slk files or the file itself contains special settings for this.

Frank
Comment 6 pedz 2007-08-09 13:36:03 UTC 
Thanks guys.  Sorry to be a pain in the butt but I want you guys to win and dealing with brain dead 
Quicken, Quickbooks, and Excel I think is going to be essential.
Comment 7 ooo 2007-08-09 15:36:44 UTC 
Just another undocumented Excel SYLK behavior :-(
If the Record Type Descriptor (RTD) ID has the Field Type Descriptor (FTD) ;P
set to XL, Excel assumes 1904 date base instead of 1900 if the (also
undocumented) RTD O option FTD ;V is not set. Any other ID;P value than XL seems
to lead to 1900 if ;V is not set. Windows Excel 2003 writes ID;PWXL.
Comment 8 Martin Hollmichel 2007-11-09 16:52:38 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 9 Marcus 2017-05-20 11:11:37 UTC 
Reset assigne to the default "issues@openoffice.apache.org".