ECMA-376 - Office Open XML - 1
st
Edition
c-rex.net
Introduction
About c-rex.net
Features
Frequently Asked Questions
License
Additional Resources
Known Issues
Office Open XML Overview
Introduction
Purposes for the standard
Structure of the standard
Properties of the standard
Structure of an Office Open XML Document
Summary
Citations
Part 1: Fundamentals
Foreword
Introduction
Scope
Conformance
Normative References
Definitions
Notational Conventions
Acronyms and Abbreviations
General Description
Overview
Packages
Markup Compatibility and Extensibility
WordprocessingML
SpreadsheetML
PresentationML
DrawingML
Shared
Bibliography
Index
Part 2: Open Packaging Conventions
Foreword
Scope
Normative References
Definitions
Notational Conventions
Acronyms and Abbreviations
General Description
Overview
Package Model
Physical Package
Core Properties
Thumbnails
Digital Signatures
Resolving Unicode Strings to Part Names
Pack URI
ZIP Appnote.txt Clarifications
Schemas - XML Schema
Schemas - RELAX NG
Standard Namespaces and Content Types
Physical Model Design Considerations
Conformance Requirements
Bibliography
Index
Part 3: Primer
Foreword
Introduction
Scope
Introduction to WordprocessingML
Introduction to SpreadsheetML
Introduction to PresentationML
Introduction to DrawingML
Introduction to VML
Introduction to Shared MLs
Miscellaneous Topics
Part 4: Markup Language Reference
Foreword
Introduction
Part Overview
WordprocessingML Reference Material
SpreadsheetML Reference Material
PresentationML Reference Material
DrawingML Reference Material
VML Reference Material
Shared MLs Reference Material
Custom XML Schema References
Office Schemas – XML Schema
Schemas – RELAX NG
Additional Syntax Constraints
Predefined SpreadsheetML Style Definitions
Example Predefined DrawingML Shape and Text Geometries
Root Element Locations
Part 5: Markup Compatibility and Extensibility
Foreword
Scope
Normative References
Definitions
Notational Conventions
Acronyms and Abbreviations
General Description
Overview
Markup Compatibility Fundamentals
Markup Compatibility Attributes and Elements
Namespace Subsumption
Application-Defined Extension Elements
Preprocessing Model for Markup Consumption
Validation Using NVDL
Bibliography
Index
Index
Search
Home
Part 4: Markup Language Reference
SpreadsheetML Reference Material
Pivot Tables
Pivot Tables
Pivot Tables
This section describes the definition of PivotTables in SpreadsheetML.
Part 4: Markup Language Reference
Foreword
Introduction
Part Overview
WordprocessingML Reference Material
SpreadsheetML Reference Material
Table of Contents
Workbook
Worksheets
Shared String Table
Tables
Calculation Chain
Comments
Styles
Metadata
Pivot Tables
Pivot Tables
<autoSortScope> (AutoSort Scope)
<b> (Boolean)
<cacheField> (PivotCache Field)
<cacheFields> (PivotCache Fields)
<cacheHierarchies> (PivotCache Hierarchies)
<cacheHierarchy> (PivotCache Hierarchy)
<cacheSource> (PivotCache Source Description)
<calculatedItem> (Calculated Item)
<calculatedItems> (Calculated Items)
<calculatedMember> (Calculated Member)
<calculatedMembers> (Calculated Members)
<chartFormat> (PivotChart Format)
<chartFormats> (PivotChart Formats)
<colFields> (Column Fields)
<colHierarchiesUsage> (Column OLAP Hierarchy References)
<colHierarchyUsage> (Column OLAP Hierarchies)
<colItems> (Column Items)
<conditionalFormat> (Conditional Formatting)
<conditionalFormats> (Conditional Formats)
<consolidation> (Consolidation Source)
<d> (Date Time)
<dataField> (Data Field Item)
<dataFields> (Data Fields)
<dimension> (OLAP Dimension)
<dimensions> (OLAP Dimensions)
<discretePr> (Discrete Grouping Properties)
<e> (Error Value)
<entries> (Entries)
<field> (Field)
<fieldGroup> (Field Group Properties)
<fieldsUsage> (Fields Usage)
<fieldUsage> (PivotCache Field Id)
<filter> (PivotTable Advanced Filter)
<filters> (Filters)
<format> (PivotTable Format)
<formats> (PivotTable Formats)
<group> (OLAP Group)
<groupItems> (OLAP Group Items)
<groupLevel> (OLAP Grouping Levels)
<groupLevels> (OLAP Grouping Levels)
<groupMember> (OLAP Group Member)
<groupMembers> (OLAP Group Members)
<groups> (OLAP Level Groups)
<i> (Row Items)
<item> (PivotTable Field Item)
<items> (Field Items)
<kpi> (OLAP KPI)
<kpis> (OLAP KPIs)
<location> (PivotTable Location)
<m> (No Value)
<map> (OLAP Measure Group)
<maps> (OLAP Measure Group)
<measureGroup> (OLAP Measure Group)
<measureGroups> (OLAP Measure Groups)
<member> (Member)
<members> (Members)
<mp> (OLAP Member Property)
<mpMap> (Member Properties Map)
<mps> (OLAP Member Properties)
<n> (Numeric)
<page> (Page Items)
<pageField> (Page Field)
<pageFields> (Page Field Items)
<pageItem> (Page Item)
<pages> (Page Item Values)
<pivotAreas> (Pivot Areas)
<pivotCacheDefinition> (PivotCache Definition)
<pivotCacheRecords> (PivotCache Records)
<pivotField> (PivotTable Field)
<pivotFields> (PivotTable Fields)
<pivotHierarchies> (PivotTable OLAP Hierarchies)
<pivotHierarchy> (OLAP Hierarchy)
<pivotTableDefinition> (PivotTable Definition)
<pivotTableStyleInfo> (PivotTable Style)
<query> (Query)
<queryCache> (OLAP Query Cache)
<r> (PivotCache Record)
<rangePr> (Range Grouping Properties)
<rangeSet> (Range Set)
<rangeSets> (Range Sets)
<rowFields> (Row Fields)
<rowHierarchiesUsage> (Row OLAP Hierarchy References)
<rowHierarchyUsage> (Row OLAP Hierarchies)
<rowItems> (Row Items)
<s> (Character Value)
<serverFormat> (Server Format)
<serverFormats> (Server Formats)
<set> (OLAP Set)
<sets> (Sets)
<sharedItems> (Shared Items)
<sortByTuple> (Sort By Tuple)
<tpl> (Tuple)
<tpls> (Tuples)
<tupleCache> (Tuple Cache)
<worksheetSource> (Worksheet PivotCache Source)
<x> (Member Property Index)
<x> (Shared Items Index)
Shared Pivot Table Data
Shared Workbook Data
QueryTable Data
External Data Connections
Supplementary Workbook Data
***
Custom XML Mappings
Formulas
Simple Types
PresentationML Reference Material
DrawingML Reference Material
VML Reference Material
Shared MLs Reference Material
Custom XML Schema References
Office Schemas – XML Schema
Schemas – RELAX NG
Additional Syntax Constraints
Predefined SpreadsheetML Style Definitions
Example Predefined DrawingML Shape and Text Geometries
Root Element Locations
Close