About the Product Assemblies Components and Parent-Child Relationships Key Features List of Features Migrate from Previous Versions Product Components Use XAML Assembly Reference Designer Context Menus Designer Dialogs Cell Styles Dialog Conditional Formatting Dialog Create Pivot Table Dialog Applying and Customizing Styles Customizing Layout for Pivot Table Customizing Pivot Table Fields Field Settings and Value Field Settings Pivot Table Context Menu Pivot Table Options Create Table Dialog Data Validation Dialog Format Cells Dialog Format CellTypes Dialog Group Dialog Name Manager Dialog Page Setup Dialog Protect Workbook Dialog Sort Dialog Designer Tabs Getting Started End-User License Agreement Redistribution Product Installation License Activation System Requirements Technical Support Spread for WPF Overview Quick Start Add Components to Toolbox Features Cells Cell Types Button Cell Checkbox Cell Combo Box Cell Data Template Cell Date-Time Cell Image Cell Mask Cell Number Cell Drop-Down Calculator Text Cell Charts Chart Elements 3-D Rotation Axes Chart Area Chart Title Data Label Data Series Data Table Error Bar Legend Chart Lines Plot Area Trendline Up-Down Bar Walls Chart Styles Chart Types Basic Charts Area Chart Bar Chart Column Chart Doughnut Chart Line Chart Pie Chart Combination Charts Specialized Charts Funnel Chart Radar Chart Stock Chart Sunburst Chart Surface Chart Treemap Chart Statistical Charts Box and Whisker Chart Bubble Chart Histogram Chart Pareto Chart Scatter Chart Waterfall Chart Column Conditional Formatting Copy and Paste Data Binding Database Connection Tutorial Step 1: Create a WPF Application Step 2: Add a Data Source Step 3: Bind Controls to Data Source Data Validation Validation Error Indicators Drag and Drop Edit File Operations Load Files Save Files Filter Formulas and Functions Add Formula to Cell Add a Formula Bar Array Formulas AutoFormat Formulas Auto-Recalculation and Updates Circular References Define Custom Names Dynamic Array Formulas External Variables Goal Seek Language Packages Nested Functions Group Headers Keyboard Operations Command List Undo and Redo Pivot Table Built-in Dialogs Configuring Pivot Table Fields Creating Pivot Tables Filtering Pivot Table Fields Pivot Table Layout Setting Pivot Table Styles Sorting Pivot Table Fields Print Header and Footer Settings Page Settings Print Dialogs Print Options Row Scroll Search Data Selection Sort Table Table Styles Structured References Table Binding Undo/Redo Workbook Worksheet Zoom