https://bugs.documentfoundation.org/show_bug.cgi?id=100822
Bug ID: 100822
Summary: FILEOPEN: xlsx file: imported DateTime cells are empty
(Excel 2010 compatible)
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126132
--> https://bugs.documentfoundation.org/attachment.cgi?id=126132&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 LO Calc 4.3.3.2 in Debian 8 and LO Calc 5.1.3.2 in Windows 7.
(Document was created using ZEXMLSS 0.0.11)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
