DocumentID: ECMA-376/Part4/3.1 Title: ECMA-376, Part4: 3.1 Table of Contents Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006 Warning: Coverted to HTML format by a script known to have bugs
This subclause is informative.
3.2.1 bookViews (Workbook Views)
3.2.2 calcPr (Calculation Properties)
3.2.3 customWorkbookView (Custom Workbook View)
3.2.4 customWorkbookViews (Custom Workbook Views)
3.2.5 definedName (Defined Name)
3.2.6 definedNames (Defined Names)
3.2.8 externalReference (External Reference)
3.2.9 externalReferences (External References)
3.2.10 extLst (Future Feature Data Storage Area)
3.2.11 fileRecoveryPr (File Recovery Properties)
3.2.12 fileSharing (File Sharing)
3.2.13 fileVersion (File Version)
3.2.14 functionGroup (Function Group)
3.2.15 functionGroups (Function Groups)
3.2.16 oleSize (Embedded Object Size)
3.2.17 pivotCache (PivotCache)
3.2.18 pivotCaches (PivotCaches)
3.2.19 sheet (Sheet Information)
3.2.21 smartTagPr (Smart Tag Properties)
3.2.22 smartTagType (Smart Tag Type)
3.2.23 smartTagTypes (Smart Tag Types)
3.2.24 webPublishing (Web Publishing Properties)
3.2.25 webPublishObject (Web Publishing Object)
3.2.26 webPublishObjects (Web Publish Objects)
3.2.28 workbookPr (Workbook Properties)
3.2.29 workbookProtection (Workbook Protection)
3.2.30 workbookView (Workbook View)
3.3.1.1 autoFilter (AutoFilter Settings)
3.3.1.4 cellSmartTag (Cell Smart Tag)
3.3.1.5 cellSmartTagPr (Smart Tag Properties)
3.3.1.6 cellSmartTags (Cell Smart Tags)
3.3.1.7 cellWatch (Cell Watch Item)
3.3.1.8 cellWatches (Cell Watch Items)
3.3.1.9 cfRule (Conditional Formatting Rule)
3.3.1.10 cfvo (Conditional Format Value Object)
3.3.1.11 chartsheet (Chart Sheet)
3.3.1.12 col (Column Width & Formatting)
3.3.1.13 colBreaks (Vertical Page Breaks)
3.3.1.14 color (Data Bar Color)
3.3.1.15 colorScale (Color Scale)
3.3.1.16 cols (Column Information)
3.3.1.17 conditionalFormatting (Conditional Formatting)
3.3.1.18 control (Embedded Control)
3.3.1.19 controls (Embedded Controls)
3.3.1.20 customPr (Custom Property)
3.3.1.21 customProperties (Custom Properties)
3.3.1.22 customSheetView (Custom Chart Sheet View)
3.3.1.23 customSheetView (Custom Sheet View)
3.3.1.24 customSheetViews (Custom Chart Sheet Views)
3.3.1.25 customSheetViews (Custom Sheet Views)
3.3.1.27 dataConsolidate (Data Consolidate)
3.3.1.28 dataRef (Data Consolidation Reference)
3.3.1.29 dataRefs (Data Consolidation References)
3.3.1.30 dataValidation (Data Validation)
3.3.1.31 dataValidations (Data Validations)
3.3.1.32 dialogsheet (Dialog Sheet)
3.3.1.33 dimension (Worksheet Dimensions)
3.3.1.35 evenFooter (Even Page Footer)
3.3.1.36 evenHeader (Even Page Header)
3.3.1.38 firstFooter (First Page Footer)
3.3.1.39 firstHeader (First Page Header)
3.3.1.43 headerFooter (Header Footer Settings)
3.3.1.44 hyperlink (Hyperlink)
3.3.1.45 hyperlinks (Hyperlinks)
3.3.1.47 ignoredError (Ignored Error)
3.3.1.48 ignoredErrors (Ignored Errors)
3.3.1.49 inputCells (Input Cells)
3.3.1.50 is (Rich Text Inline)
3.3.1.51 legacyDrawing (Legacy Drawing Reference)
3.3.1.52 legacyDrawingHF (Legacy Drawing Reference in Header Footer)
3.3.1.53 mergeCell (Merged Cell)
3.3.1.54 mergeCells (Merge Cells)
3.3.1.55 oddFooter (Odd Page Footer)
3.3.1.56 oddHeader (Odd Header)
3.3.1.57 oleObject (Embedded Object)
3.3.1.58 oleObjects (Embedded Objects)
3.3.1.59 outlinePr (Outline Properties)
3.3.1.60 pageMargins (Page Margins)
3.3.1.61 pageSetup (Page Setup Settings)
3.3.1.62 pageSetup (Chart Sheet Page Setup)
3.3.1.63 pageSetUpPr (Page Setup Properties)
3.3.1.65 picture (Background Image)
3.3.1.66 pivotArea (Pivot Area)
3.3.1.67 pivotSelection (PivotTable Selection)
3.3.1.68 printOptions (Print Options)
3.3.1.69 protectedRange (Protected Range)
3.3.1.70 protectedRanges (Protected Ranges)
3.3.1.72 rowBreaks (Horizontal Page Breaks (Row))
3.3.1.74 scenarios (Scenarios)
3.3.1.75 selection (Selection)
3.3.1.76 sheetCalcPr (Sheet Calculation Properties)
3.3.1.77 sheetData (Sheet Data)
3.3.1.78 sheetFormatPr (Sheet Format Properties)
3.3.1.79 sheetPr (Sheet Properties)
3.3.1.80 sheetPr (Chart Sheet Properties)
3.3.1.81 sheetProtection (Sheet Protection Options)
3.3.1.82 sheetProtection (Chart Sheet Protection)
3.3.1.83 sheetView (Worksheet View)
3.3.1.84 sheetView (Chart Sheet View)
3.3.1.85 sheetViews (Sheet Views)
3.3.1.86 sheetViews (Chart Sheet Views)
3.3.1.87 smartTags (Smart Tags)
3.3.1.88 sortCondition (Sort Condition)
3.3.1.89 sortState (Sort State)
3.3.1.90 tabColor (Sheet Tab Color)
3.3.1.91 tablePart (Table Part)
3.3.1.92 tableParts (Table Parts)
3.3.1.94 webPublishItem (Web Publishing Item)
3.3.1.95 webPublishItems (Web Publishing Items)
3.3.1.96 worksheet (Worksheet)
3.3.2.1 colorFilter (Color Filter Criteria)
3.3.2.2 customFilter (Custom Filter Criteria)
3.3.2.3 customFilters (Custom Filters)
3.3.2.4 dateGroupItem (Date Grouping)
3.3.2.5 dynamicFilter (Dynamic Filter)
3.3.2.7 filterColumn (AutoFilter Column)
3.3.2.8 filters (Filter Criteria)
3.3.2.9 iconFilter (Icon Filter)
3.4.3 phoneticPr (Phonetic Properties)
3.4.9 sst (Shared String Table)
3.4.10 strike (Strike Through)
3.4.14 vertAlign (Vertical Alignment)
3.5.1.1 calculatedColumnFormula (Calculated Column Formula)
3.5.1.3 tableColumn (Table Column)
3.5.1.4 tableColumns (Table Columns)
3.5.1.5 tableStyleInfo (Table Style)
3.5.1.6 totalsRowFormula (Totals Row Formula)
3.5.1.7 xmlColumnPr (XML Column Properties)
3.5.2.1 singleXmlCell (Table Properties)
3.5.2.2 singleXmlCells (Single Cells)
3.5.2.3 xmlCellPr (Cell Properties)
3.5.2.4 xmlPr (Column XML Properties)
3.6.2 calcChain (Calculation Chain Info)
3.7.4 commentList (List of Comments)
3.8.3 bgColor (Background Color)
3.8.8 cellStyles (Cell Styles)
3.8.9 cellStyleXfs (Formatting Records)
3.8.18 fgColor (Foreground Color)
3.8.23 gradientFill (Gradient)
3.8.24 horizontal (Horizontal Inner Borders)
3.8.26 indexedColors (Color Indexes)
3.8.31 numFmts (Number Formats)
3.8.33 protection (Protection Properties)
3.8.39 styleSheet (Style Sheet)
3.8.40 tableStyle (Table Style)
3.8.41 tableStyleElement (Table Style)
3.8.42 tableStyles (Table Styles)
3.8.44 vertical (Vertical Inner Border)
3.9.2 bk (Future Metadata Block)
3.9.3 cellMetadata (Cell Metadata)
3.9.4 futureMetadata (Future Metadata)
3.9.6 mdx (MDX Metadata Record)
3.9.7 mdxMetadata (MDX Metadata Information)
3.9.9 metadataStrings (Metadata String Store)
3.9.10 metadataType (Metadata Type Information)
3.9.11 metadataTypes (Metadata Types Collection)
3.9.13 n (Member Unique Name Index)
3.9.14 p (Member Property MDX Metadata)
3.9.17 valueMetadata (Value Metadata)
3.10.1.1 autoSortScope (AutoSort Scope)
3.10.1.3 cacheField (PivotCache Field)
3.10.1.4 cacheFields (PivotCache Fields)
3.10.1.5 cacheHierarchies (PivotCache Hierarchies)
3.10.1.6 cacheHierarchy (PivotCache Hierarchy)
3.10.1.7 cacheSource (PivotCache Source Description)
3.10.1.8 calculatedItem (Calculated Item)
3.10.1.9 calculatedItems (Calculated Items)
3.10.1.10 calculatedMember (Calculated Member)
3.10.1.11 calculatedMembers (Calculated Members)
3.10.1.12 chartFormat (PivotChart Format)
3.10.1.13 chartFormats (PivotChart Formats)
3.10.1.14 colFields (Column Fields)
3.10.1.15 colHierarchiesUsage (Column OLAP Hierarchy References)
3.10.1.16 colHierarchyUsage (Column OLAP Hierarchies)
3.10.1.17 colItems (Column Items)
3.10.1.18 conditionalFormat (Conditional Formatting)
3.10.1.19 conditionalFormats (Conditional Formats)
3.10.1.20 consolidation (Consolidation Source)
3.10.1.22 dataField (Data Field Item)
3.10.1.23 dataFields (Data Fields)
3.10.1.24 dimension (OLAP Dimension)
3.10.1.25 dimensions (OLAP Dimensions)
3.10.1.26 discretePr (Discrete Grouping Properties)
3.10.1.30 fieldGroup (Field Group Properties)
3.10.1.31 fieldsUsage (Fields Usage)
3.10.1.32 fieldUsage (PivotCache Field Id)
3.10.1.33 filter (PivotTable Advanced Filter)
3.10.1.35 format (PivotTable Format)
3.10.1.36 formats (PivotTable Formats)
3.10.1.38 groupItems (OLAP Group Items)
3.10.1.39 groupLevel (OLAP Grouping Levels)
3.10.1.40 groupLevels (OLAP Grouping Levels)
3.10.1.41 groupMember (OLAP Group Member)
3.10.1.42 groupMembers (OLAP Group Members)
3.10.1.43 groups (OLAP Level Groups)
3.10.1.45 item (PivotTable Field Item)
3.10.1.49 location (PivotTable Location)
3.10.1.51 map (OLAP Measure Group)
3.10.1.52 maps (OLAP Measure Group)
3.10.1.53 measureGroup (OLAP Measure Group)
3.10.1.54 measureGroups (OLAP Measure Groups)
3.10.1.57 mp (OLAP Member Property)
3.10.1.58 mpMap (Member Properties Map)
3.10.1.59 mps (OLAP Member Properties)
3.10.1.62 pageField (Page Field)
3.10.1.63 pageFields (Page Field Items)
3.10.1.64 pageItem (Page Item)
3.10.1.65 pages (Page Item Values)
3.10.1.66 pivotAreas (Pivot Areas)
3.10.1.67 pivotCacheDefinition (PivotCache Definition)
3.10.1.68 pivotCacheRecords (PivotCache Records)
3.10.1.69 pivotField (PivotTable Field)
3.10.1.70 pivotFields (PivotTable Fields)
3.10.1.71 pivotHierarchies (PivotTable OLAP Hierarchies)
3.10.1.72 pivotHierarchy (OLAP Hierarchy)
3.10.1.73 pivotTableDefinition (PivotTable Definition)
3.10.1.74 pivotTableStyleInfo (PivotTable Style)
3.10.1.76 queryCache (OLAP Query Cache)
3.10.1.77 r (PivotCache Record)
3.10.1.78 rangePr (Range Grouping Properties)
3.10.1.79 rangeSet (Range Set)
3.10.1.80 rangeSets (Range Sets)
3.10.1.81 rowFields (Row Fields)
3.10.1.82 rowHierarchiesUsage (Row OLAP Hierarchy References)
3.10.1.83 rowHierarchyUsage (Row OLAP Hierarchies)
3.10.1.84 rowItems (Row Items)
3.10.1.86 serverFormat (Server Format)
3.10.1.87 serverFormats (Server Formats)
3.10.1.90 sharedItems (Shared Items)
3.10.1.91 sortByTuple (Sort By Tuple)
3.10.1.94 tupleCache (Tuple Cache)
3.10.1.95 worksheetSource (Worksheet PivotCache Source)
3.10.1.96 x (Member Property Index)
3.10.1.97 x (Shared Items Index)
3.10.2 Shared Pivot Table Data
3.10.2.1 reference (Reference)
3.10.2.2 references (References)
3.11.1.2 headers (Revision Headers)
3.11.1.4 ndxf (New Formatting Information)
3.11.1.6 odxf (Old Formatting Information)
3.11.1.7 oldFormula (Old Formula)
3.11.1.8 raf (Revision AutoFormat)
3.11.1.9 rcc (Revision Cell Change)
3.11.1.10 rcft (Revision Merge Conflict)
3.11.1.11 rcmt (Revision Cell Comment)
3.11.1.12 rcv (Revision Custom View)
3.11.1.13 rdn (Revision Defined Name)
3.11.1.15 reviewedList (Reviewed List)
3.11.1.16 revisions (Revisions)
3.11.1.17 rfmt (Revision Format)
3.11.1.18 ris (Revision Insert Sheet)
3.11.1.19 rm (Revision Cell Move)
3.11.1.20 rqt (Revision Query Table)
3.11.1.21 rrc (Revision Row Column Insert Delete)
3.11.1.22 rsnm (Revision Sheet Name)
3.11.1.24 sheetIdMap (Sheet Id Map)
3.11.2 Shared Workbook User Data
3.11.2.1 userInfo (User Information)
3.12.1 deletedField (Deleted Field)
3.12.2 queryTable (Query Table)
3.12.3 queryTableDeletedFields (Deleted Fields)
3.12.4 queryTableField (QueryTable Field)
3.12.5 queryTableFields (Query table fields)
3.12.6 queryTableRefresh (QueryTable Refresh Information)
3.13 External Data Connections
3.13.1 connection (Connection)
3.13.2 connections (Connections)
3.13.3 dbPr (Database Properties)
3.13.5 olapPr (OLAP Properties)
3.13.6 parameter (Parameter Properties)
3.13.7 parameters (Query Parameters)
3.13.10 textField (Text Import Field Settings)
3.13.12 textPr (Text Import Settings)
3.13.13 webPr (Web Query Properties)
3.14 Supplementary Workbook Data
3.14.1 cell (External Cell Data)
3.14.2 ddeItem (DDE Item definition)
3.14.3 ddeItems (DDE Items Collection)
3.14.4 ddeLink (DDE Connection)
3.14.5 definedName (Defined Name)
3.14.6 definedNames (Named Links)
3.14.7 externalBook (External Workbook)
3.14.8 externalLink (External Reference)
3.14.9 oleItem (OLE Link Item)
3.14.10 oleItems (OLE Link Items)
3.14.13 sheetData (External Sheet Data Set)
3.14.14 sheetDataSet (Cached Worksheet Data)
3.14.15 sheetName (Sheet Name)
3.14.16 sheetNames (Supporting Workbook Sheet Names)
3.14.19 values (DDE Name Values)
3.15.2 stp (Strings in Subtopic)
3.15.5 volType (Volatile Dependency Type)
3.15.6 volTypes (Volatile Dependency Types)
3.16.1 DataBinding (XML Mapping)
3.16.2 Map (XML Mapping Properties)
3.17.2.7 Single- and Multi-Cell Formulas
3.17.4.3 Combined Date and Time Representation
3.17.5.3 Lexical Representation
3.17.6.4 Formula Evaluation Order
3.17.7 Predefined Function Definitions
3.18.1 ST_Axis (PivotTable Axis)
3.18.2 ST_BorderId (Border Id)
3.18.3 ST_BorderStyle (Border Line Styles)
3.18.4 ST_CalcMode (Calculation Mode)
3.18.5 ST_CalendarType (Calendar Type)
3.18.6 ST_CellComments (Cell Comments)
3.18.7 ST_CellFormulaType (Formula Type)
3.18.8 ST_CellRef (Cell Reference)
3.18.9 ST_CellSpan (Cell Span Type)
3.18.10 ST_CellSpans (Cell Spans)
3.18.11 ST_CellStyleXfId (Cell Style Format Id)
3.18.12 ST_CellType (Cell Type)
3.18.13 ST_CfType (Conditional Format Type)
3.18.14 ST_CfvoType (Conditional Format Value Object Type)
3.18.15 ST_Comments (Comment Display Types)
3.18.16 ST_ConditionalFormattingOperator (Conditional Format Operators)
3.18.17 ST_CredMethod (Credentials Method)
3.18.18 ST_DataConsolidateFunction (Data Consolidation Functions)
3.18.19 ST_DataValidationErrorStyle (Data Validation Error Styles)
3.18.20 ST_DataValidationImeMode (Data Validation IME Mode)
3.18.21 ST_DataValidationOperator (Data Validation Operator)
3.18.22 ST_DataValidationType (Data Validation Type)
3.18.23 ST_DateTimeGrouping (Date Time Grouping)
3.18.24 ST_DdeValueType (DDE Value Types)
3.18.25 ST_DvAspect (Data View Aspect Type)
3.18.27 ST_DynamicFilterType (Dynamic Filter)
3.18.28 ST_ExternalConnectionType (Text Field Datatype)
3.18.29 ST_FieldSortType (Field Sort Type)
3.18.30 ST_FileType (File Type)
3.18.32 ST_FilterOperator (Filter Operator)
3.18.34 ST_FontScheme (Font scheme Styles)
3.18.35 ST_FormatAction (PivotTable Format Types)
3.18.37 ST_FormulaExpression (Formula Expression Type)
3.18.38 ST_GradientType (Gradient Type)
3.18.39 ST_GroupBy (Values Group By)
3.18.40 ST_GrowShrinkType (Grow Shrink Type)
3.18.41 ST_Guid (Globally Unique Identifier)
3.18.42 ST_HorizontalAlignment (Horizontal Alignment Type)
3.18.43 ST_HtmlFmt (HTML Formatting Handling)
3.18.44 ST_IconSetType (Icon Set Type)
3.18.45 ST_ItemType (PivotItem Type)
3.18.46 ST_MdxFunctionType (MDX Function Type)
3.18.47 ST_MdxKPIProperty (MDX KPI Property)
3.18.48 ST_MdxSetOrder (MDX Set Order)
3.18.49 ST_NumFmtId (Number Format Id)
3.18.50 ST_Objects (Object Display Types)
3.18.51 ST_OleUpdate (OLE Update Types)
3.18.52 ST_Orientation (Orientation)
3.18.53 ST_PageOrder (Page Order)
3.18.55 ST_PaneState (Pane State)
3.18.56 ST_ParameterType (Parameter Type)
3.18.57 ST_PatternType (Pattern Type)
3.18.58 ST_PhoneticAlignment (Phonetic Alignment Types)
3.18.59 ST_PhoneticType (Phonetic Type)
3.18.60 ST_PivotAreaType (Rule Type)
3.18.61 ST_PivotFilterType (Pivot Filter Types)
3.18.62 ST_PrintError (Print Errors)
3.18.63 ST_Qualifier (Qualifier)
3.18.64 ST_Ref (Cell References)
3.18.65 ST_RefA (Single Cell Reference)
3.18.66 ST_RefMode (Reference Mode)
3.18.67 ST_RevisionAction (Revision Action Types)
3.18.68 ST_rwColActionType (Row Column Action Type)
3.18.69 ST_Scope (Conditional Formatting Scope)
3.18.70 ST_SheetState (Sheet Visibility Types)
3.18.71 ST_SheetViewType (Sheet View Type)
3.18.72 ST_ShowDataAs (Show Data As)
3.18.73 ST_SmartTagShow (Smart Tag Display Types)
3.18.75 ST_SortMethod (Sort Method)
3.18.76 ST_SortType (Set Sort Order)
3.18.77 ST_SourceType (PivotCache Type)
3.18.78 ST_Sqref (Reference Sequence)
3.18.79 ST_TableStyleType (Table Style Type)
3.18.80 ST_TableType (Table Type)
3.18.81 ST_TargetScreenSize (Target Screen Size Types)
3.18.82 ST_TimePeriod (Time Period Types)
3.18.83 ST_TotalsRowFunction (Totals Row Function Types)
3.18.84 ST_Type (Top N Evaluation Type)
3.18.85 ST_UnderlineValues (Underline Types)
3.18.86 ST_UnsignedIntHex (Hex Unsigned Integer)
3.18.87 ST_UnsignedShortHex (Unsigned Short Hex)
3.18.88 ST_UpdateLinks (Update Links Behavior Types)
3.18.89 ST_VerticalAlignment (Vertical Alignment Types)
3.18.90 ST_VerticalAlignRun (Vertical Alignment Run Types)
3.18.91 ST_Visibility (Visibility Types)
3.18.92 ST_VolDepType (Volatile Dependency Types)
3.18.93 ST_VolValueType (Volatile Dependency Value Types)
3.18.94 ST_WebSourceType (Web Source Type)
3.18.95 ST_XmlDataType (XML Data Types)
3.18.96 ST_Xstring (Escaped String)
End of informative text.