Issue 125745

Summary: cellType="d" not supported when reading MS Excel files
Product: Calc Reporter: Charlie Clark <charlie.clark>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: oooforum
Version: 4.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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"/>