Issue 80716 - Bad time import from Excel XML
Summary: Bad time import from Excel XML
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://impulzus.com/~joghurt/a.xml
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2007-08-15 21:44 UTC by joghurt
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
bugdoc (3.81 KB, text/xml)
2007-08-16 10:20 UTC, frank 		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 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'!