Issue 85095 - Excel XML import filter loses times
Summary: Excel XML import filter loses times
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-01-09 02:28 UTC by bz922x
Modified: 2013-01-29 21:40 UTC (History)
2 users (show)

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


Attachments
Excel showing date and time in the cell (31.22 KB, image/png)
2008-01-09 02:29 UTC, bz922x
no flags Details
OO Calc showing only the date - time has been zeroed by import (26.83 KB, image/png)
2008-01-09 02:30 UTC, bz922x
no flags Details
Excel xml file with a date and time value (1.68 KB, text/xml)
2008-01-09 02:31 UTC, bz922x
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bz922x 2008-01-09 02:28:06 UTC
When importing Excel XML files, the time portion of all date+time entries are
ignored. See Screenshots. You can test with the example file.
Comment 1 bz922x 2008-01-09 02:29:11 UTC
Created attachment 50745 [details]
Excel showing date and time in the cell
Comment 2 bz922x 2008-01-09 02:30:30 UTC
Created attachment 50746 [details]
OO Calc showing only the date - time has been zeroed by import
Comment 3 bz922x 2008-01-09 02:31:28 UTC
Created attachment 50747 [details]
Excel xml file with a date and time value
Comment 4 chl207 2008-09-05 08:08:04 UTC
In OOO300_m3 On WinXP,the issue still exists.
Open the XML file by Insert - Sheet From File… or Open_button in Calc, both 
does the same.
Comment 5 amy2008 2008-09-19 09:44:06 UTC
Confirmed in OOo3.0_RC1 on WinXP