Issue 80716

Summary: Bad time import from Excel XML
Product: Calc Reporter: joghurt <joghurt>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.2.1Keywords: needhelp
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
URL: http://impulzus.com/~joghurt/a.xml
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
bugdoc none

Description joghurt 2007-08-15 21:44:01 UTC 
1. Export a time cell with zero value from Excel.
2. Open in OOo.
3. The cell content will be "1899-12-31 00:00:00" instead of "0:00:00".
No matter if the style in the XML file specifies "h:mm:ss" or "[hh]:mm:ss", etc.

If you export anything but 0, it is imported perfectly.
<Data ss:Type="DateTime">1899-12-31T00:00:00.000</Data>  ===>  BAD
<Data ss:Type="DateTime">1899-12-31T00:00:00.001</Data>  ===>  GOOD

See referenced file.
Comment 1 frank 2007-08-16 10:20:56 UTC 
Created attachment 47565 [details]
bugdoc
Comment 2 frank 2007-08-16 10:22:09 UTC 
Hi Swante,

one for you. Cells A1:B1 seems to be the problem.

Frank
Comment 3 svante.schubert 2007-08-17 18:57:41 UTC 
Thanks for the issue joghurt.
Although it is uncertain when I will ever be able to work on this filter again.
I really hope than someone of the community is able to provide some patches for
this.

Marked with keyword 'needhelp'!