Issue 125745 - cellType="d" not supported when reading MS Excel files
Summary: cellType="d" not supported when reading MS Excel files
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-10-13 14:29 UTC by Charlie Clark
Modified: 2014-10-23 08:58 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Charlie Clark 2014-10-13 14:29:50 UTC
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 This is a pity as it would allow us to ignore Excel's broken 1900-based calendar and simply pass ISO formats around.
Comment 1 oooforum (fr) 2014-10-23 08:41:25 UTC
Don't understand that means cellType.
In Calc and MS-Excel, the function is CELL.
Both supports format codes as date.
Comment 2 Charlie Clark 2014-10-23 08:58:51 UTC
The XSD for the "t" attribute of the cell.

<xsd:simpleType name="ST_CellType">
    <xsd:restriction base="xsd:string">
       <xsd:enumeration value="b"/>
       <xsd:enumeration value="d"/>
       <xsd:enumeration value="n"/>
       <xsd:enumeration value="e"/>
       <xsd:enumeration value="s"/>
       <xsd:enumeration value="str"/>
       <xsd:enumeration value="inlineStr"/>