Structure of an OpenDocument spreadsheet

Unsupported properties (compared to .xlsx)

• The file format does not support embedded data connections. Migrating spreadshets i.e. a xlsx file with data connections will remove the data connection but preserve the cell values.
• The file format does not support RealTimeData (RTD) functions as a formula. Migrating spreadshets i.e. a xlsx file with RTD functions will not remove the formula, but convert the formula to a string. The unavailablity of a spreadsheet test sample with a working RTD function, limits our ability to conclude further regarding any possible loss of data.
• The file format does not support the absolute file path to the local directory, where the file was last saved. Migrating spreadshets i.e. a xlsx file with an absolute file path in workbook.xml will remove the information. Absolute file paths can contain sensitiive informatiion and therefore should be deleted no matter what and furthermore it is unknown what purpose saving this information has.

Data types

• Blank
• Boolean
• Formula
• Numeric
• String

Cell types

• Boolean
• Currency
• Date
• Float
• Percentage
• String
• Time

Standards

• ISO/IEC 26300-1:2015 - Part 1: OpenDocument Schema
• ISO/IEC 26300-2:2015 - Part 2: Recalculated Formula (OpenFormula) Format
• ISO/IEC 26300-3:2015 - Part 3: Packages