OOXML: Transitional to Strict - Asbjoedt/CLISC GitHub Wiki

Converting from .xlsx Transitional to .xlsx Strict has several elements, which must be changed, because Strict does not allow compatibility with legacy Excel file formats.

If you are interested in converting from Strict to Transitional <- read this article.

Page 1, general

2.1 Document Conformance A document of conformance class Office Open XML Strict shall be a package of conformance class OPC, as specified in ISO/IEC 29500-2, for which all the > following shall hold:

  • The document obeys all constraints specified in this Part of ISO/IEC 29500

  • The document is of category Wordprocessing, Spreadsheet, or Presentation, as defined in §4

  • For each OPC Part of the document of the types listed in §11.3, §12.3, §13.3, §14.2 or §15.2, all the following shall hold:

  • i. The Part may contain markup in the Markup Compatibility namespace as specified in ISO/IEC 29500-3

  • ii. After the removal of any extensions by an MCE processor as specified in ISO/IEC 29500-3, the part is valid against the strict W3C XML Schema (Appendix A)

This Part of ISO/IEC 29500 uses the following further terms to refer to documents of conformance class Office Open XML Strict:

  • SML Strict, if the document is of category Spreadsheet

Namespaces

Strict namespaces (incomplete list)

http://purl.oclc.org/ooxml/spreadsheetml/main
http://purl.oclc.org/ooxml/officeDocument/relationships
http://purl.oclc.org/ooxml/officeDocument/extendedProperties
http://purl.oclc.org/ooxml/officeDocument/docPropsVTypes
http://purl.oclc.org/ooxml/officeDocument/relationships/styles
http://purl.oclc.org/ooxml/officeDocument/relationships/theme
http://purl.oclc.org/ooxml/officeDocument/relationships/worksheet
http://purl.oclc.org/ooxml/officeDocument/relationships/sharedStrings
http://purl.oclc.org/ooxml/officeDocument/relationships/externalLink
http://purl.oclc.org/ooxml/officeDocument/relationships/officeDocument
http://purl.oclc.org/ooxml/officeDocument/relationships/externalLinkPath
http://purl.oclc.org/ooxml/officeDocument/relationships/oleObject
http://purl.oclc.org/ooxml/officeDocument/relationships/image
http://purl.oclc.org/ooxml/drawingml/spreadsheetDrawing
http://purl.oclc.org/ooxml/drawingml/main
urn:schemas-microsoft-com:vml

Page 1575, conformance class

Specifies the conformance class (§2.1) to which the SpreadsheetML document conforms. If this attribute is omitted, its default value is transitional. [Example: Consider the following SpreadsheetML Workbook part markup:

<workbook conformance="strict">
…
</workbook>

This document has a conformance attribute value of strict, therefore it conforms to the SML Strict conformance class. end example] The possible values for this attribute are defined by the ST_ConformanceClass simple type (§22.9.2.2).

Page 4002, DrawingML schema

<xsd:complexType name="CT_GraphicalObjectData">
<xsd:sequence>
<xsd:any minOccurs="0" maxOccurs="unbounded" processContents="strict"/>
</xsd:sequence>
<xsd:attribute name="uri" type="xsd:token" use="required"/>
</xsd:complexType>
Schema conformance validation

Page 4129

A.6.9 Shared Simple Types This schema is available in the file shared-commonSimpleTypes.xsd.

<xsd:simpleType name="ST_ConformanceClass">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="strict"/>
<xsd:enumeration value="transitional"/>
</xsd:restriction>
</xsd:simpleType>

Page 4401-4402

B.6.9 Shared Simple Types This schema is available in the file shared-commonSimpleTypes.rnc

s_ST_ConformanceClass = string "strict" | string "transitional"

Page 1070

17.15.1.82 strictFirstAndLastChars (Use Strict Kinsoku Rules for Japanese Text) This element specifies that the strict set of Kinsoku rules shall be applied to Japanese text in this document when the kinsoku element (§17.3.1.16) is applied to that text. The resulting line breaking rules are provided on the kinsoku element.

If this element is omitted, then standard rules shall apply to Japanese text when the kinsoku element is applied to that text.

[Example: Consider a WordprocessingML document that specifies that strict Kinsoku rules must be applied to Japanese text. This requirement would be specified using the following WordprocessingML in the document settings part:

<w:strictFirstAndLastChars w:val="true"/>

The strictFirstAndLastChars element's val attribute has a value of true specifying that a document must apply the strict set of disallowed characters for the start and end of a line. end example] This element’s content model is defined by the common boolean property definition in §17.17.4.

Sources:

⚠️ **GitHub.com Fallback** ⚠️