Issue 85095 - Excel XML import filter loses times
Summary: Excel XML import filter loses times
Status: CLOSED DUPLICATE of issue 82849
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: 2023-02-15 02:05 UTC (History)
4 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
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 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
Comment 6 damjan 2023-02-14 17:52:51 UTC 
This was fixed recently in bug 82849.

Resolving duplicate.

Thank your bug report and sample document :-).

*** This issue has been marked as a duplicate of issue 82849 ***