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
Worksheets
Worksheets
Worksheets
The following elements define a sheet and its contents:
Part 4: Markup Language Reference
Foreword
Introduction
Part Overview
WordprocessingML Reference Material
SpreadsheetML Reference Material
Table of Contents
Workbook
Worksheets
Worksheets
<autoFilter> (AutoFilter Settings)
<brk> (Break)
<c> (Cell)
<cellSmartTag> (Cell Smart Tag)
<cellSmartTagPr> (Smart Tag Properties)
<cellSmartTags> (Cell Smart Tags)
<cellWatch> (Cell Watch Item)
<cellWatches> (Cell Watch Items)
<cfRule> (Conditional Formatting Rule)
<cfvo> (Conditional Format Value Object)
<chartsheet> (Chart Sheet)
<col> (Column Width & Formatting)
<colBreaks> (Vertical Page Breaks)
<color> (Data Bar Color)
<colorScale> (Color Scale)
<cols> (Column Information)
<conditionalFormatting> (Conditional Formatting)
<control> (Embedded Control)
<controls> (Embedded Controls)
<customPr> (Custom Property)
<customProperties> (Custom Properties)
<customSheetView> (Custom Chart Sheet View)
<customSheetView> (Custom Sheet View)
<customSheetViews> (Custom Chart Sheet Views)
<customSheetViews> (Custom Sheet Views)
<dataBar> (Data Bar)
<dataConsolidate> (Data Consolidate)
<dataRef> (Data Consolidation Reference)
<dataRefs> (Data Consolidation References)
<dataValidation> (Data Validation)
<dataValidations> (Data Validations)
<dialogsheet> (Dialog Sheet)
<dimension> (Worksheet Dimensions)
<drawing> (Drawing)
<evenFooter> (Even Page Footer)
<evenHeader> (Even Page Header)
<f> (Formula)
<firstFooter> (First Page Footer)
<firstHeader> (First Page Header)
<formula> (Formula)
<formula1> (Formula 1)
<formula2> (Formula 2)
<headerFooter> (Header Footer Settings)
<hyperlink> (Hyperlink)
<hyperlinks> (Hyperlinks)
<iconSet> (Icon Set)
<ignoredError> (Ignored Error)
<ignoredErrors> (Ignored Errors)
<inputCells> (Input Cells)
<is> (Rich Text Inline)
<legacyDrawing> (Legacy Drawing Reference)
<legacyDrawingHF> (Legacy Drawing Reference in Header Footer)
<mergeCell> (Merged Cell)
<mergeCells> (Merge Cells)
<oddFooter> (Odd Page Footer)
<oddHeader> (Odd Header)
<oleObject> (Embedded Object)
<oleObjects> (Embedded Objects)
<outlinePr> (Outline Properties)
<pageMargins> (Page Margins)
<pageSetup> (Page Setup Settings)
<pageSetup> (Chart Sheet Page Setup)
<pageSetUpPr> (Page Setup Properties)
<pane> (View Pane)
<picture> (Background Image)
<pivotArea> (Pivot Area)
<pivotSelection> (PivotTable Selection)
<printOptions> (Print Options)
<protectedRange> (Protected Range)
<protectedRanges> (Protected Ranges)
<row> (Row)
<rowBreaks> (Horizontal Page Breaks (Row))
<scenario> (Scenario)
<scenarios> (Scenarios)
<selection> (Selection)
<sheetCalcPr> (Sheet Calculation Properties)
<sheetData> (Sheet Data)
<sheetFormatPr> (Sheet Format Properties)
<sheetPr> (Sheet Properties)
<sheetPr> (Chart Sheet Properties)
<sheetProtection> (Sheet Protection Options)
<sheetProtection> (Chart Sheet Protection)
<sheetView> (Worksheet View)
<sheetView> (Chart Sheet View)
<sheetViews> (Sheet Views)
<sheetViews> (Chart Sheet Views)
<smartTags> (Smart Tags)
<sortCondition> (Sort Condition)
<sortState> (Sort State)
<tabColor> (Sheet Tab Color)
<tablePart> (Table Part)
<tableParts> (Table Parts)
<v> (Cell Value)
<webPublishItem> (Web Publishing Item)
<webPublishItems> (Web Publishing Items)
<worksheet> (Worksheet)
AutoFilter Settings
Shared String Table
Tables
Calculation Chain
Comments
Styles
Metadata
Pivot Tables
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