https://issues.apache.org/ooo/show_bug.cgi?id=125745
Issue ID: 125745
Issue Type: DEFECT
Summary: cellType="d" not supported when reading MS Excel files
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
According to 18.18.11 ST_CellType (Cell Type) of the ECMA specification it is
possible to set the type of the cell to "d" with a value formatted according to
ISO 8601.
"d (Date)
Cell contains a date in the ISO 8601 format."
Such cells will, however, be treated as empty cells by OpenOffice.org. This is
a pity as it would allow us to ignore Excel's broken 1900-based calendar and
simply pass ISO formats around.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.