OnDoc
| sign
in
up
~
pub
|
pdf
txt
html
toc
url
|
<<
>>
1
~
10
11
12
13
14
15
16
~
129
Table of Contents
Contents
Acknowledgements
Foreword
Introduction
Who is this book for?
Code samples
ECMA Office Open XML
The Open XML standard
WordprocessingML
Creating digital documents
Setting up the main structure
The start part, document.xml
The content types list, [Content_Types].xml
The relationships part
The final zipped document
Adding text to the document
Text formatting
Run formatting
Paragraph formatting
Different break types
Tables
Cell borders and shading
Styling the document
Storing the styles part
Style types
The style hierarchy
The document defaults
Creating styles
Paragraph styles
Character styles
Table styles
Adding images
Inserting a DrawingML picture
Inserting a VML picture
Page layout
Creating sections
Adding headers and footers
Custom XML in documents
Custom XML
/Structured document tags
Data binding
Finalizing the document
Removing reviewing data
Removing comments
Marking as final
Advanced topics
Page background
Tables with merged cells
Numbered lists
Bookmarks and hyperlinks
Using fields
Table of Contents
Captions
WordprocessingML wrap-up
SpreadsheetML
Introduction
Elements of a simple spreadsheet
The workbook part
The worksheet part
The entire structure
Creating worksheets
Formulas
Worksheet optimizations
Sparse table markup
Shared strings
Shared formulas
Tables
Auto filters
Calculated columns
Pivot tables
The elements of a pivot table
Creating the pivot table shell
Creating the pivot cache definition
Defining cache records
Referencing the cache from the workbook
Creating the pivot table
Summing up
Adding and positioning the chart
Styling content
Elements of the styles part
Applying a cell style
Fonts, fills, borders and numbering
Border definitions
Fonts
Fills
Formatting records
Differential formatting records
Table styles
Conditional formatting
Highlighting rules
Top and bottom rules
Data bars
Color scales
Icon sets
Chart sheets
Supporting features
Defined names
Workbook properties
Wrap-up
PresentationML
Introduction
PresentationML document structure
Shapes
Figure shapes
Grouping shapes
The elements of a simple presentation
The slide part
The slide layout part
The slide master part
The theme part
The presentation part
Placeholders
Pictures
Tables, charts and diagrams
DrawingML
Introduction
Text
Formatting text
Bulleted Lists
Numbered lists
Graphics
The graphic geometry
The coordinate system
Specifying DrawingML colors
Shape effects
3D scenes
3D effects
Tables
Table elements
Merging cells
Formatting tables
Charts
/Elements of a simple chart
Data binding a chart
/Adding extra chart labels
Adding custom shapes
Creating 3D charts
Themes
Units of measure
The EMU
The twip