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.

Reply via email to