BS ISO IEC 26300 — Open Document Format for Office Applications (OpenDocument) v1.2 Series

📄 BS ISO/IEC 26300 is the British Standard series adopted by BSI from the ISO/IEC 26300 international standard, defining the Open Document Format for Office Applications (ODF). Developed by ISO/IEC JTC 1 Subcommittee SC 34 (Document description and processing language), with UK participation through Technical Committee IST/41, ODF is the international standard format for electronic documents (text documents, spreadsheets, presentations, drawings, and more), originating from the OASIS OpenDocument v1.2 specification produced by the OASIS Open Document Format TC. ODF uses an open architecture based on XML and ZIP packages, aiming to ensure office documents can be freely exchanged between different office suites and preserved long term.

1. Series Overview and Positioning 📌

This batch covers three parts of the BS ISO/IEC 26300 series: Part 1: OpenDocument Schema (2015 edition), Part 2: Recalculated Formula (OpenFormula) format (2015 edition), and Part 3: Packages format (2015 edition). Together they supersede the single edition of 2006 + A1:2012 amendment (withdrawn), formalizing the three-module structure of ODF v1.2 as an international standard. All three parts derive from the OASIS OpenDocument v1.2 specification (published September 2011), edited with participation from IBM, Oracle, and others.

The three modules of ODF v1.2 are: Schema (defines document content and structure elements), OpenFormula (defines the semantics and syntax of spreadsheet formulas), and Packages (defines how documents are organized in a ZIP package). They correspond respectively to “what the document is,” “how formulas are computed,” and “how the file is packaged.”

2. Series Structure and Part-Level Points 🔧

3. Part 1: OpenDocument Schema Core Content 🔍

Part 1 defines the XML schema for ODF documents, covering elements and structures of text, spreadsheet, presentation, drawing, and chart document types. Content includes: document root element and namespaces, shared document structure (styles, metadata, settings), text content model (paragraphs, headings, lists, tables, notes, etc.), table content model (cells, rows, columns, formula references), graphics and drawing objects, and so on. This part is the core of ODF interoperability: any document conforming to the schema can be correctly parsed and rendered by an ODF implementation.

The schema also defines the styles system (character, paragraph, page, table styles, etc.), events and hyperlinks, metadata and document settings, and other extensibility capabilities, allowing ODF to express complex documents while remaining structurally open.

4. Part 2: OpenFormula Format 🧮

Part 2 defines the Recalculated Formula format for spreadsheets, i.e., the OpenFormula specification. Formulas are the core of spreadsheet software, but different vendors’ implementations of functions, operators, and evaluation rules often differ, causing the same formula to produce different results in different software. OpenFormula specifies the exact semantics of formula syntax, operator precedence, reference semantics, error handling, and numerous built-in functions (mathematical, statistical, text, date/time, logical, financial, etc.), aiming to make formulas in documents yield consistent results across implementations.

5. Part 3: Packages Format 📦

Part 3 defines the Package format of ODF documents, specifying how the document is organized and stored internally. An ODF document is typically a ZIP archive containing content stream (content.xml), styles stream (styles.xml), metadata (meta.xml), settings (settings.xml), media objects, and a manifest file. Part 3 standardizes the package structure, part naming and types, MIME types, digital signatures and encryption, stream compression, and extension mechanisms, ensuring different implementations can consistently read and write complete document packages.

The package format also supports embedded objects (images, fonts, embedded documents, etc.) and stream processing, providing a basis for loading and incremental editing of large documents.

6. Application Practice and Selection 🛠️

• 📋 Document interoperability: in enterprise environments needing to exchange documents across office suites, adopt ODF as the standard exchange format to reduce conversion cost and data loss risk.
• 🔗 Integration development: when developing document processing, conversion, and archiving systems, implement read/write based on the 26300 schema and package specifications for format compliance.
• 🗄️ Long-term preservation: in electronic records archiving and government document preservation, ODF serves as an open long-term preservation format, avoiding the read risk of proprietary formats.
• 🧮 Formula consistency: in finance, engineering, and other calculation-sensitive scenarios, use OpenFormula to ensure consistent formula results across implementations.

7. Frequently Asked Questions ❓