https://bz.apache.org/ooo/show_bug.cgi?id=127034
Issue ID: 127034
Issue Type: DEFECT
Summary: xlsx file: imported DateTime cells are empty (Excel
2010 compatible)
Product: Calc
Version: 4.1.2
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Critical
Priority: P5 (lowest)
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 85603
--> https://bz.apache.org/ooo/attachment.cgi?id=85603&action=edit
xlsx with 2 datetime notation: 1 works fine and another is empty in Calc
Calc do not read DateTime in cells when date in ISO 8601 format (like
"1961-04-12T07:55:00.123")!
By documentation (Ecma Office Open XML paragraph 18.18.11) ST_CellType cell
type for DateTime are:
1. "n" and value for date is number (like "22383.32986")
example:
<c r="C3" s="5" t="n">
<v>22383.32986</v>
</c>
2. "d" and value for date is datetime (like "1961-04-12T07:55:00.123")
example:
<c r="C4" s="5" t="d">
<v>1961-04-12T07:55:00.123</v>
</c>
Calc ignores the second case.
In attachment xlsx in cells B3 and C3 datetime as number - and Calc ok, in
cells B4 and D4 datetime in ISO 8601 format - and Calc ignores dates.
In Excel 2010 all cells shown fine.
Tested in OO Calc 4.1.2 in Windows 7.
Also it's reproducible for LibreOffice Calc 4.3.3.2 in Debian 8 and 5.1.3.2 in
Windows 7: https://bugs.documentfoundation.org/show_bug.cgi?id=100822
(Document was created using ZEXMLSS 0.0.11)
--
You are receiving this mail because:
You are the assignee for the issue.
