M.2 SpreadsheetML

The following changes occurred to the SpreadsheetML schema:

The algorithmName, hashValue, saltValue, and spinCount attributes were added to sheetProtection (18.3.1.85; 18.3.1.84), protectedRange (18.3.1.71), sheetProtection (18.3.1.85), and fileSharing (18.2.12) The anchor element (18.3.1.1) was added The characterSet attribute was added to the textPr element (18.13.12) and the webPublishing element (18.2.24) The codePage attribute was removed from the textPr element (18.13.12) The codePage attribute was removed from the webPublishing element (18.2.24) The commentPr element (18.7.5) was added The conformance attribute was added to the workbook element (18.2.27) The controlPr element (18.3.1.20) was added The drawingHF element (18.3.1.37) was added The end element (18.8.16) was added The left element was deleted The leftLabels attribute was removed from the dataConsolidate element (18.3.1.29) The legacyDrawing element was deleted The legacyDrawingHF element was deleted The objectPr element (18.3.1.56) was added The paperHeight and paperWidth attributes were added to the pageSetup element (18.3.1.63) The paperHeight and paperWidth attributes were added to the pageSetup element (18.3.1.64) The password attribute was removed from sheetProtection (18.3.1.85; 18.3.1.84), protectedRange (18.3.1.71), and the sheetProtection elements (18.3.1.85) The refreshedDate attribute was removed from the pivotCacheDefinition element (18.10.1.67) The refreshedDateIso attribute was added to the pivotCacheDefinition element (18.10.1.67) The reservationPassword attribute was removed from the fileSharing element (18.2.12) The right element was deleted The Schema element (18.16.4) now allows mixed content The SchemaLanguage attribute was added to the schema element (18.16.4) The securityDescriptor attribute was removed from the protectedRange element (18.3.1.71) The securityDescriptor element (18.3.1.77) was added The shapeId attribute was added to the comment element (18.7.3)

The ST_CalendarType simple type (22.9.2.1) now allows an enumeration value of saka The ST_CellType simple type (18.18.11) now allows an enumeration value of d The ST_FileType simple type (18.18.29) now allows enumeration values of lin and other The ST_PivotAreaType simple type (18.18.58) no longer allows an enumeration value of topRight The ST_PivotAreaType simple type (18.18.58) now allows an enumeration value of topEnd The ST_TextHAlign simple type (18.18.80) was added The ST_TextVAlign simple type (18.18.81) was added The ST_XmlDataType simple type (18.18.93) was modified to allow any xsd:string The start element (18.8.37) was added The startLabels attribute was added to the dataConsolidate element (18.3.1.29) The val and maxVal attributes were removed from the dynamicFilter element (18.3.2.5) The valIso and maxValIso attributes were added to the dynamicFilter element (18.3.2.5) The workbookPassword, workbookPasswordCharacterSet, revisionsPassword, and revisionsPasswordCharacterSet attributes were removed from the workbookProtection element (18.2.29) The workbookPasswordCharacterSet, revisionsPasswordCharacterSet, revisionsAlgorithmName, revisionsHashValue, revisionsSaltValue, revisionsSpinCount, workbookAlgorithmName, workbookHashValue, workbookSaltValue, and workbookSpinCount attributes were added to the workbookProtection element (18.2.29)