Issue 80716 - Bad time import from Excel XML
Summary: Bad time import from Excel XML
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:
Keywords: needhelp
Depends on:
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: ---

bugdoc (3.81 KB, text/xml)
2007-08-16 10:20 UTC, frank
no flags Details

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]
Comment 2 frank 2007-08-16 10:22:09 UTC
Hi Swante,

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

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

Marked with keyword 'needhelp'!