[Issue 125745] New: cellType="d" not supported when reading MS Excel files

[bu...@apache.org]

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: issues@openoffice.apache.org
          Reporter: charlie.clark@clark-consulting.eu

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.

[Issue 125745] cellType="d" not supported when reading MS Excel files

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125745

--- Comment #2 from Charlie Clark <ch...@clark-consulting.eu> ---
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"/>
    </xsd:restriction>
</xsd:simpleType>

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125745] cellType="d" not supported when reading MS Excel files

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=125745

oooforum <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum <oo...@free.fr> ---
Don't understand that means cellType.
In Calc and MS-Excel, the function is CELL.
Both supports format codes as date.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.