Format
OpenDocument Spreadsheet
Summary
- Name
- OpenDocument Spreadsheet
- Version
- 1.2
- Identifiers
-
- MIME: application/vnd.oasis.opendocument.spreadsheet
- PUID: fmt/295
- Format type
- Spreadsheet
- Disclosure
- Full
- Description
- OpenDocument (ODF) format is a generic format for office documents, such as text, spreadsheets, presentations, drawings, and databases. It was developed by OASIS, based on the original OpenOffice document format. The format is an open standard, and is supported by a variety of office software packages. ODF is an XML format, which may comprise a single XML document, or a collection of subdocuments within a package. The package format is the commonly used form, and comprises a standard ZIP package containing the XML content and any associated binary data, together with a manifest which lists the package content. An ODF spreadsheet document contains spreadsheet data. The content is contained in a 'content' xml subdocument. Additional subdocuments contain style information, document metadata, and application-specific settings.
- File extensions
-
ods,ots - Source
- Digital Preservation Department / The National Archives
- Developed by
- OASIS
Relationships
- Has priority over
Internal signatures
ODF 1.2 spreadsheet
- Note
- ZIP header + MIME-type declaration + version number. ODF versions without version number detail are assumed to be version 1.1
Byte sequences
- Min Frag Length
- Absolute from BOF
- Offset
- 0
- Max offset
- None
- Byte Sequence
504B0304{26}6D696D65747970656170706C69636174696F6E2F766E642E6F617369732E6F70656E646F63756D656E742E7370726561647368656574504B030414*6F66666963653A76657273696F6E3D22312E3222- Endianness
- None
Container signatures
Type: ZIP
7020 - Open Document Spreadsheet 1.2
- File path
- META-INF/manifest.xml
Byte sequence reference
BOFoffset
Sub sequences
- Min Frag Length
- Position
- 1
- Sub sequence min offset
- 0
- Sub sequence max offset
- 1024
- Sequence
'manifest:media-type="application/vnd.oasis.opendocument.spreadsheet'
- File path
- content.xml
Byte sequence reference
BOFoffset
Sub sequences
- Min Frag Length
- Position
- 1
- Sub sequence min offset
- 0
- Sub sequence max offset
- 128
- Sequence
'office:document-content'
- Min Frag Length
- Position
- 2
- Sub sequence min offset
- 0
- Sub sequence max offset
- Sequence
'office:version=' (22|27) '1.2' (22|27)
Changelog
-
Updated in V108
- Release date
- 5 September 2022
OpenDocument Spreadsheet 1.2: Minor container signature syntax adjustment to align with official PRONOM syntax. Submitted by Preservica.
-
Updated in V66
- Release date
- 18 December 2012
OpenDocument Spreadsheet 1.2: MIME-Type information added.
-
Updated in V60
- Release date
- 11 June 2012
OpenDocument Spreadsheet 1.2: Container signature statement added to record notes.
-
Added in V42
- Release date
- 5 November 2010
OpenDocument Spreadsheet 1.2: Signature developed through PRONOM Research
OpenDocument Spreadsheet 1.2: Full entry added.