Issue 85095

Summary: Excel XML import filter loses times
Product: Calc Reporter: bz922x <tdgoodman>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: amy2008, issues
Version: OOo 2.3.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Excel showing date and time in the cell
none
OO Calc showing only the date - time has been zeroed by import
none
Excel xml file with a date and time value none

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