Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
CAN/CSA-ISO/IEC-ISP-15124-1-01: International Standardized Profile for Spreadsheet Document Interchange
A Technical Overview of Canada’s Adoption of the FOD26 Document Application Profile for Open Document Format Spreadsheets
Scope and Applicability
CAN/CSA-ISO/IEC-ISP-15124-1-01 is a Canadian adoption of the International Standardized Profile (ISP) ISO/IEC ISP 15124-1:2001, which belongs to the FOD26 series. This standard defines a Document Application Profile (DAP) for spreadsheet documents based on the Open Document Architecture (ODA). It specifies the interchange format, document structure, and content representation for spreadsheets to ensure cross-platform interoperability.
The profile addresses the following key aspects:
- Document structure – layout of spreadsheets, including tables, rows, columns, and cell-level formatting.
- Content types – text, numbers, formulas, charts, and embedded objects.
- Interchange format – compatible with ODF (Open Document Format) and earlier ODA-based systems.
- Conformance levels – to guarantee predictable rendering and editing across different software implementations.
The standard is intended for use by developers, integrators, and organizations that require a stable, internationally agreed-upon profile for exchanging spreadsheet data in heterogeneous environments.
Technical Requirements and Architecture
CAN/CSA-ISO/IEC-ISP-15124-1-01 defines a formal document profile comprising both mandatory and optional features. The architecture follows the ODA standard (ISO 8613) and extends it for spreadsheet-specific constructs. The profile is divided into several classes and functional units.
Key Architectural Components
| Component | Description | Mandatory/Optional |
|---|---|---|
| Document Profile | Defines the overall document class, character sets, default styles, and page layout. | Mandatory |
| Composition Object | Hierarchical structure of the spreadsheet (cells, rows, columns, sheets). | Mandatory |
| Content Architecture | Formats for text passages, numbers, and formulas within cells. | Mandatory |
| Layout Style | Page orientation, margins, headers/footers, print settings. | Optional |
| Presentation Attributes | Font, colour, borders, shading, alignment at cell level. | Mandatory |
| Formula Representation | Syntax and semantics for arithmetic, logical, and reference formulas. | Optional |
| Chart Object | Embedded chart definitions (title, axes, series, data ranges). | Optional |
Conformance Classes
The standard specifies three conformance classes, each targeting a different level of interoperability:
- Class A (Minimal) – Basic table structure and text content; no formulas or charts. Suitable for simple data interchange.
- Class B (Extended) – Adds numeric formatting, formula support, and limited presentation attributes.
- Class C (Full) – Supports all optional components including charts, embedded objects, and full presentation styles.
Important: Implementations must declare their conformance class. Interchange between systems of the same or higher class is guaranteed, but downgrading may result in loss of features.
Implementation Highlights
When implementing CAN/CSA-ISO/IEC-ISP-15124-1-01, developers should pay close attention to the following areas to ensure correct interchange.
Character Encoding and Default Language
The profile mandates support for ISO/IEC 10646 (Unicode) for character encoding. Default language identifiers follow ISO 639 and ISO 3166. This ensures that locale-specific data (e.g., decimal separators, date formats) is handled consistently.
Tip: Use the default language tag defined in the document profile to select the appropriate cultural formatting when rendering the spreadsheet. This avoids ambiguity with number and date formats.
Formula Semantics
Formulas are represented as structured token sequences, not as simple string expressions. The profile defines a reference mechanism based on cell coordinates (absolute and relative). Implementers must support the complete set of arithmetic, relational, and logical operators as defined in the standard’s reference model.
Caution: Non‑standard formula functions (e.g., financial or statistical) are not part of the profile. Using them may break interoperability unless both sender and receiver agree on an extension mechanism within the document profile.
Layout and Printing
While page layout is optional, it is critical for fidelity in paper or PDF output. The profile allows specification of printer metrics (e.g., logical page dimensions) and print ranges. Implementations should respect these even when viewing on screen.
Best Practice: For maximum compatibility, include a minimal layout style defining page size and orientation. This ensures that the spreadsheet can be printed without clipping or scaling distortion.
Compliance and Conformance Notes
Conformance to CAN/CSA-ISO/IEC-ISP-15124-1-01 is assessed through validation of a document or system against the profile’s abstract test suite, which is defined in the ISO/IEC ISP 15124-1 companion documents.
Document Conformance
A conforming document must:
- Adhere to the ODA syntax described in ISO/IEC 8613.
- Include a document profile descriptor containing the profile identifier for FOD26.
- Declare its conformance class (A, B, or C).
- Contain only those functional units that belong to the declared class.
Implementation Conformance
A conforming system (sender or receiver) must:
- Be able to generate or parse documents of at least one conformance class.
- Correctly interpret all mandatory attributes for the class.
- Handle optional attributes gracefully (ignore or process).
Note: Canadian adoption may include national deviation notes. Check the CAN/CSA‑ISO/IEC‑ISP‑15124‑1‑01 distribution for any Annex that specifies adjustments specific to Canadian federal procurement or bilingual requirements (e.g., French character handling).
Testing and Certification
Conformance testing typically involves running an ASN.1 schema check followed by a functional unit test. The Standardized Profiles community provides test vectors for each class. Certification is offered by some third-party organizations in coordination with the ISO/IEC JTC 1/SC 32/SC 34 committees.
Outcome: Successful conformance ensures that spreadsheet documents can be exchanged reliably between different applications without loss of content, structure, or formatting.
Q: Is CAN/CSA-ISO/IEC-ISP-15124-1-01 still active?
A: Yes, this standard remains current as an adopted profile. While later editions (e.g., ODF 1.2/ISO 26300) have gained traction, the FOD26 profile is still used in legacy and government interoperability frameworks.
A: Yes, this standard remains current as an adopted profile. While later editions (e.g., ODF 1.2/ISO 26300) have gained traction, the FOD26 profile is still used in legacy and government interoperability frameworks.
Q: What is the relationship between this ISP and ODF (ISO 26300)?
A: The FOD26 profile predates the ODF standard. ODF evolved from the ODA architecture and shares many concepts. CAN/CSA-ISO/IEC-ISP-15124-1-01 represents the earlier, but still interoperable, document profile for spreadsheets.
A: The FOD26 profile predates the ODF standard. ODF evolved from the ODA architecture and shares many concepts. CAN/CSA-ISO/IEC-ISP-15124-1-01 represents the earlier, but still interoperable, document profile for spreadsheets.
Q: Can I use this standard with modern spreadsheet software?
A: Some office suites support export to ODA-compliant formats. However, native support is limited. Use it primarily in environments that require strict conformance to the ISP (e.g., certain government archives or cross‑platform document exchange systems).
A: Some office suites support export to ODA-compliant formats. However, native support is limited. Use it primarily in environments that require strict conformance to the ISP (e.g., certain government archives or cross‑platform document exchange systems).
Q: Where can I obtain the full text of the standard?
A: The document is available from the CSA Group, ISO/IEC JTC 1 sales, and national standards bodies. The Canadian adoption includes the original ISO text plus a CSA preface.
A: The document is available from the CSA Group, ISO/IEC JTC 1 sales, and national standards bodies. The Canadian adoption includes the original ISO text plus a CSA preface.
Reference: CAN/CSA-ISO/IEC-ISP-15124-1-01: Information technology — International Standardized Profiles — FOD26 — Open Document Format: Spreadsheet Document — Document Application Profile. Published 2026.