Spreadsheet Objects Binding a Cell Range in Spread to an External Data Source Saving Data to a File Creating Conditional Formatting with Rules Understanding the Product Saving to a PDF File Adding Hyperlink in a Cell GcTimeSpan Tab Chart Object Model Allowing the User to Automatically Sort Rows Printing the Portion of the Sheet with Data Running Spread Designer Stand Alone Using External Variables with Text Box Control Using a Value Comparison Validator Connecting to Data Creating Data Type for Custom Objects Resizing a Table Customizing the Individual Sheet Appearance Adding Support for High DPI Settings Allowing the User to Resize Rows or Columns Opening the Chart Designer Adding a Comment to a Cell Selecting an Entire FpSpread Component Using Double Click to Fill Cells Using Touch Support with InputMan Cells Point Charts Combo Box Tab Allowing User Functionality Printing a Range of Cells on a Sheet Managing Cell Range Filtering Creating a Sunburst Chart Rows or Columns That Have Data Data Bar Rule Y Plot Types Working with Built-In Dialogs Developer's Guide Cells, Columns, and Rows Editor Using Serialization Pareto Charts Formatting a Cell Value SmartPrint Tab Spread Sparkline Regular Expression Tab ListBox Tab Vari Sparkline Input Data in Rows or Columns Resetting and Clearing Design Work Adding Custom Context Menu to a Component Home Menu Printing Auto Format Formulas Formulas in Cells Shape Actions Customizing the Selection Appearance Using Touch Support when Sorting Object Import from Spread COM Designing in the Data Area Using Validation Headers Preventing a Cell from Receiving Focus Setting Fixed (Frozen) Rows or Columns Error Bars Print Settings Imported Rich Text Tab Saving or Loading a Chart Cascade Sparkline LegendArea Collection Editor Default Map for ReadOnly and WhenAncestorOfFocused Saving and Opening Design Files Displaying Context Menu at Runtime View Type Allowing the User to Filter Rows Using Touch Support with Charts Understanding the Data Model InputMap Editor Rich Text Editing Removing Data from a Sheet Save/Load Chart Control Understanding Charts Understanding the Axis Model Precedents and Dependents Polar Stripe Charts Starting Spread Designer Rich Text Editing Working with Hierarchical Data Display Histogram Sparkline Managing Cell Range Sorting Handling Right-to-Left Layouts Opening a Custom Text File Product Requirements Working with Shapes in Code Repeatedly Filling a Range of Cells with Copied Cells Using Touch Support with Cell Notes Customizing the Group Bar Installing the Product Keyboard Interaction Headers tab Focus Indicator Editor Setting a GcComboBox Cell Setting up the Formula Provider Resizing the Row or Column to Fit the Data Working with 1-Based Indexing Understanding Cell Type Basics Changing an Input Map for a Child View Displaying Dialogs for Users Using a String Comparison Validator Adding a Table Formula Adding ChartSheet Margins tab Default Map for SingleSelect and WhenFocused Using a Surrogate Character Validator Placing a Formula in Cells Drawing (Rendering) Style Rows and Columns Creating a Pie Plot Modifying the PageSetup Dialog for the User Coloring a Cell Adding a Custom Sort Dialog Header Editor Sheet Context Menu Allowing the User to Zoom the Display of the Component Displaying a Print Dialog for the User Moving a Sheet Providing a Preview of the Printing Optimizing the Printing Using Size Color Picker Tab Customizing the Pop-Up Date-Time Control Working with Multiple Sheets Component and Sheet Settings Exported Text Rendering with GDI Moving a Shape Border Editor Pie Sparkline Formula Settings Imported Placing Child Controls on a Sheet Specifying What to Print Cell Types Color Scale Rules Chart Settings Exported Customizing the Sheet Name Tabs Filling Cells with Drag and Move Data Binding Row and Column Settings Exported Rotating a Shape Setting Properties in Spread Designer Creating a Y Plot GroupInfo Collection Editor Creating a Custom Sheet Model Using Touch Support with Grouping Row Height or Column Width Dialog Setting a Barcode Cell Using Touch Support with Shapes Creating a Treemap Chart Setting the Header Text Hiding the Selection When Focus is Lost SheetSkin Editor Using Touch Support Pie Plot Types Cell Settings Exported Using a Required Type Validator Managing Data on a Sheet Understanding How Cell Types Display and Format Data DefaultGroupFooter Editor Customizing the Input Maps Setting a Multiple-Column Combo Box Cell MultiColumnComboBox Tab BarCode Tab Allowing Cells to Merge Automatically Displaying Text Tips in a Cell Understanding Headers Table Context Menu Working With Dynamic Array Formulas Icon Set Rule Using an Encoding Validator Understanding the Spread Wizard Cell Settings Imported Setting a List Box Cell Import and Export Reference Chart Types and Views Adding and Customizing Sheets Customizing the Header Grid Lines XYZ Line Charts Using a Bound Data Source XY Stripe Charts Differences in Behavior and Operation Adding Custom Properties Using Windows Regional Settings or Options Adding a Tag to a Row or Column Default Map for RowMode and WhenAncestorOfFocused Displaying Spin Buttons Polar Line Charts Customizing Interaction Based on Events Sheet Print Settings Dialog Parsing Formulas in Custom XML Deserialization Using the Spread Wizard Migrate .NET Framework Project to .NET 8 Platform Customizing the Printed Page Header or Footer Header/Footer tab Customizing the Outline of the Component Customizing Header Label Text Allowing the User to Perform a Standard Search Auto Expand Row Headers Adding a Tag to a Cell Setting the Cell Types of the Register Go To Cell Dialog Using Shapes with Maps Formulas Imported from Spread COM Files Adding Spread to the Checkbook Project Using Touch Support with Filtering Printing an Area of the Sheet Using DataTable Formula Print Settings Exported Specifying a Cell Reference in a Formula Creating a Custom Skin for a Component Lighting, Shapes, and Borders Binding Spread to an External Data Set Storing Excel Summary and View Doughnut Charts Market Data (High-Low) Charts Customizing the Number of Rows or Columns Creating and Using a Visual Function General Style of the Sheet Corner Default Map for ExtendedSelect and WhenFocused Understanding the Underlying Models Light Collection Editor Formatter and Editor Setting a GcTextBox Cell Scroll Bars Tab Creating a Span of Cells Showing or Hiding a Sheet Interoperability of Outlines with Other Features Adding a Shape to a Sheet Customizing the Style of Header Cells Starting the Spread Wizard Understanding Touch Messages Recalculating and Updating Formulas Automatically Setting a Currency Cell Using the Exclude List Validator Adding Image in a Cell Allowing a Combo Box Cell to Handle a Double Click Fill Effects Using Touch Support with Zooming GcMask Tab Creating a Range of Cells Bar Charts Border Styles Substituted Conditional Formatting Dialog Saving and Loading a Skin Creating Custom Hierarchy Icons Allowing the User to Group Rows Specifying What the User Can Select Getting Started Designing Using Custom Filter Indicator Images Customizing Simple Filtering Using Drag Operations to Fill Cells Using an UnBound Data Source Selecting an Item in the Spread Designer Understanding Additional Features of Cell Types Customizing Interaction in Cells Insert Function Dialog Understanding the Built-in Shapes Creating Alternating Rows Named Style Editor Button Tab Customizing the Default Header Labels Using Touch Support with Selections Filling Cells with Drag and Drop Customizing Markers and Points Customizing a Line as an Arrow Number Tab Spread Designer Status Bar Using a Cell Comparison Validator Nesting Functions in a Formula Using the Touch Menu Bar Setting a Rich Text Cell Specifying an External Reference in a Formula Adding a Status Bar Spread Designer Property Window Chart Control Using the Include List Validator Hbar and Vbar Sparkline Using Touch Support with Drag and Fill Binding to Data Setting a Slider Cell Adding Charts Saving to an HTML File Binding a Combo Box to a DataReader Using Language Package Customizing the Sheet Appearance Text to Columns Month and Year Sparkline Sheet Settings Imported Radar Stripe Charts Background Tab XYZ Plot Types Setting a Check Box Cell GcDateTime Tab Default Map for ReadOnly and WhenAncestorOfFocused Handling Installation Radar Area Charts Applying Theme to Customize the Appearance Resetting Parts of the Interface Using Input Maps with Action Maps SmartPrintRule Collection Editor Setting a Combo Box Cell Creating an XYZ Plot Adding Hyperlink to a Shape Selecting a Sheet of Cells Customizing the User Error Messages Finding More Details on the Sheet Models Returning Information for a Clicked Cell Creating a Header with Multiple Rows or Columns Spread COM Property Equivalents in .NET Check Box Tab Box Whisker Charts Sorting a Table General tab Forecast Sheet Dialog Product Overview Adding a Gradient to Header Cells Adding a Page Break Row and Column Settings Imported Placing and Retrieving Data Mask Tab Alternating Row Collection Editor Setting the Appearance of the Display of the Filter Item List Legends Saving to an Image File Cells Workbook Settings Imported Working with Deselections Simple Example Using Spread Designer Percent Tab Plot area Split Box Tab Inherent Differences Based on Platform Settings Menu Managing Sorting of Rows of User Data Auto Updating Filters in Table Spread Designer Quick Access Toolbar Creating Camera Shapes Designing Shapes Adding NuGet Package in Spread Windows Forms Displaying Grid Lines on a Sheet Spread Designer Guide Working with a SubEditor Key Features Working with Graphical Cell Types Combining different types of plots Displaying a Footer for Columns or Groups Setting Up the Rows and Columns of the Register Help Menu Using the Array Formula Row or Column Insert or Delete Dialogs Using Edit Mode and Focus Printing Particular Pages Printing in Duplex Mode Understanding Applied Settings Customizing the Print Job Settings Creating a Hierarchical Display Manually Things to Do with Any Shape Print Actions Elevation and Rotation Touch Support with the Component Managing Outlines (Range Groups) of Rows and Columns Customizing the Appearance of the Printing Using a Regular Expression Validator Working with Editable Cell Types Setting the Properties Saving to a Spread XML File Understanding the Selection Model Using a Circular Reference in a Formula Implementing a Serializer Class Sorting Rows, Columns, or Ranges Aligning Cell Contents Creating an XY Plot Walls Allowing the User to Perform an Advanced Search Understanding Edit Mode in a Cell Highlighting Rules Area Charts Handling Data Using Cell Properties Edit tab Radar Line Charts Using Touch Support with the Tab Strip Setting a GcMask Cell Default Map for Normal and WhenAncestorOfFocused Printing a Sheet with Cell Notes Setting the Appearance of Grouped Rows Chart Designer Toolbar Default Keyboard Maps Copying and Inserting a Sheet Area Sparkline Shape Shadow Properties Dialog Using the Chart Designer Radar Point Charts Saving to an Excel File Showing or Hiding Headers Searching for Data with Code Calculations tab Opening an XML Data File Setting a Number Cell Customizing Data Binding Default Map for ExtendedSelect and WhenAncestorOfFocused Chart Collection Editors Using the Range Validator Customizing the User Interface Images Context Menu Customizing the Appearance of a Cell Using a Required Field Validator Cell-Type Settings Exported Cell Styles Dialog Customizing Row or Column Interaction Customizing Cell Types for Bound Sheets Creating Plot Types Showing or Hiding Filter Indicators Using a Touch Keyboard Insert Menu Chart Line Style Customizing User Selection and Deselection of Data Setting up Preview Rows Version Comparison Reference Understanding How Cell Types Work Understanding Simple Row Filtering Using Smart Tags Drop-Down Setting a Mask Cell Entering a Formula in Spread Designer Multi-Level Category Labels Remove Duplicates from Range Customizing Scroll Bar Tips Using Touch Support with Drop-Down Elements Cell Spans in the Sheet Corner Binding with cell range Column, Line, and Winloss Sparkline Using Table Filters Applying a Skin to a Sheet Setting a GcCharMask Cell Creating a Radar Plot Setting a Button Cell Customizable Cell in the Sheet Corner Repeating Rows or Columns on Printed Pages Allowing Cell Data to Overflow Creating a Polar Plot Saving to an HTML Table Working with Scroll Bars Understanding Parts of the Component Setting Table Styles Working with the Design Removing a Row or Column Displaying Error Icons in Cells or Rows Customizing Column and Field Binding Add Sparklines using Formulas Opening a Spread COM File Using Touch Support with Clipboard Operations Creating a Runtime License Ways to Improve Performance Printing an Entire Sheet Text Display in the Sheet Corner View Menu Interactivity Actions Setting up Conditional Formatting of a Cell Working with Collection Editors Using Conditional Formatting of Cells Protecting a Worksheet Table Display in the Sheet Corner Setting a Text Cell Tables Setting a Hyperlink Cell Determining Which Header Row Displays the Indicators Customizing the Filter List LabelArea Collection Editor General Tab Creating a Custom Compound Shape Default Map for MultiSelect and WhenFocused Adding a Watermark to a Printed Page Default Map for Excel Compatibility Goal Seek Dialog Validating User Input Clicking Actions Creating a Custom Filter Text Tab Polar Area Charts Printing to PDF Creating a Custom Group Saving and Loading Map Files Adding a Component to a Visual Studio 2019 or 2022 Project Using a Text Length Validator Object Parentage Spread Designer Editors Finding the Documentation Using Touch Support with Editable Cells Spread Designer Dialogs Customizing Particular Shapes Adding an Unbound Row to a Bound Sheet Plot Types Changing the Default Keyboard Map Creating and Using a Custom Language Package Working with the Formula Text Box Default Map for ReadOnly and WhenFocused Understanding the Span Model Moving Data on a Sheet Working with Pattern and Gradient Fill Effects Customizing Clipboard Operation Options Ribbon Control Zoom Dialog Customizing Drawing Migrate .NET Framework Project to .NET 6 Platform Printing a Sheet with Shapes BoxPlot Sparkline Creating a Custom Skin for a Sheet Spread Designer Menus Spread COM File Member Equivalents Managing External Reference Using a Pair Validator Customizing Automatic Completion (Type Ahead) Allowing the User to Change the Chart Image Tab Gauge KPI Sparkline Waterfall Charts General tab Adding a Drop Shadow Interoperability of Grouping with Other Features Form Controls Tutorial: Binding to a Corporate Database (Visual Studio 2013 or later) Advanced Topics for Shapes Showing or Hiding a Row or Column Creating Charts SpreadSkin Editor XYZ Point Charts Hyperlink Tab Loading a Skin Managing Filtering of Rows of User Data XY Point Charts PlotArea Collection Editor Adding a Table Cell Types Creating a Span in a Header Sort Dialog Add Sparklines Using Methods Bullet Sparkline Setting Table Properties in Spread Designer Adding Formulas to Calculate Balances Factors of Keyboard Map Usage Selecting Multiple Sheets Saving a Skin Radar Plot Types Swapping Data on a Sheet Customizing the Renderers Pie Charts Getting Started Spread COM Event Equivalents in .NET Using Touch Support with Range Grouping General Differences in Product Design Copying Data on a Sheet Optimizing the Printing Using Rules Adding a Note to a Cell Working With Shapes (Enhanced Shape Engine) TabStrip Editor Default Keyboard Navigation File Operations Setting a Percent Cell Creating a Complex Border with Multiple Lines Using an Outline (Range Group) of Rows or Columns Setting the Appearance of Sort Indicators XY Plot Types Footer Editor Getting More Practice Using Excel-compatible Keyboard Shortcuts Setting the Appearance of Filtered Rows Stripe Charts Customizing Undo and Redo Actions Displaying Formula in Cells Polar Point Charts XY Bubble Charts Pareto Sparkline Adding an Unbound Column to a Bound Sheet Finding a Value Using GoalSeek Setting the Height or Width of Header Setting Sheet Properties in Spread Designer Specifying Horizontal and Vertical Axes Navigating Sheet Tabs Setting an Image Cell Selecting an Individual Cell Image Sparkline Creating and Using a Custom Name Selecting a Column of Cells Label Tab Overview of Spread Designer Features Working with the Component Deactivating the Default Keyboard Map Setting a Progress Indicator Cell Tutorial: Creating a Checkbook Register Resizing a Cell to Fit the Data Default Map for Normal and WhenFocused Using Touch Support with AutoFit Understanding the Optional Interfaces Advanced chart settings Other Settings Imported from Spread COM Files Unhide Specific Row or Column Dialogs Formula Editor Selecting Actions Cell Type Dialog Underlying Models Setting a Multiple Option Cell Formula Bar Understanding Structured References Customizing Viewports Inserting Cells Displaying an Abort Message for the User Editing the Points of a Shape Adding a Row to a Bound Sheet Working with Sparklines Page Layout Menu Setting up the Name Box Previewing a Sheet in Spread Designer Setting a Color Picker Cell Defining the Order of the Items in the Filter Item List Colors tab Setting the Row Height or Column Width Working With Slicers Using Satellite Assemblies for Languages File Menu Formulas Menu Creating a Custom Cell Type Creating Enhanced Camera Shape Default Map for SingleSelect and WhenAncestorOfFocused Mapping Actions of COM in .NET Adding a Component to a Visual Studio 2017 Project Available Language Packages for WinForms Allowing the Display of Buttons in a Cell Setting Rich Text in a Cell Customizing the Display of the Pointer GcCharMask Tab Saving Spreadsheet Data to Simple XML Resizing the Data to Fit the Cell Optimizing the Printing Name Manager Dialog Currency Tab Polar Plot Types Understanding How Cell Type Affects Model Data Stacked Sparkline Understanding the Style Model Using Spread Designer in Runtime Using Validation in Cells Adding a Tag to a Sheet Spread Settings Dialog Introduction Setting Row Properties in Spread Designer Improving Performance by Suspending the Layout Printing a Sheet from Spread Designer Working with Cell Format Strings Using Verbs in the Properties Window Setting the Background Colors for a Sheet Understanding the Sheet Model Classes and Interfaces Histogram Charts Changing the Appearance of a Shape Using Touch Support when Resizing Columns or Rows MultiOption Tab Customizing the Dimensions of the Component Sparklines Underlying Keystroke Processing Customizing the Pop-Up Calculator Control Setting the Component to the Original Appearance Copying Size and Style of Row/Column on Insert General Tab Chart User Interface Elements Limiting Values for a Numeric Cell Selecting the Cells with Data Removing a Sheet Using Auto Row Height Locating the Pointer Using HitTest Selecting a Contiguous Range of Cells Using Automatic Sorting GcNumber Tab Events from User Actions Line Charts Using the Excel Compatibility Input Maps Understanding the Printing Options Using Touch Support with Viewports Setting a Background Image for a Sheet SpreadChart Collection Editor Binding a Cell Range in Spread as a Data Source to an External Control Labels Pagination tab Data Menu Customizing the Sheet Corner Appearance Saving to a Text File Spread Designer User Interface Resizing a Shape Applying and Customizing Themes Handling Redistribution Assembly Reference Creating and Applying a Style for Cells Binding a Table XYZ Surface Charts Funnel Charts Displaying Cell Data Customizing the Printed Page Layout Creating and Customizing Cell Borders Using Grouping Creating and Using a Custom Function Scatter Sparkline Setting a Regular Expression Cell Using the Chart Control Sheet-Level Actions Adding to Bound Data Using Keys with Shapes Customizing Text as a Shape Specifying a Sheet Reference in a Formula Setting the Appearance of Filter Indicators Date-Time Tab Creating Borders with Diagonal Lines Locking a Shape Understanding Structured Reference Syntax Rules Progress Tab Shape Properties Dialog Applying a Skin to the Component Spread COM Method Equivalents in .NET Borders Imported from Spread COM Files Working with Selections Working with the Active Sheet Allowing the User to Enter Formulas Customizing a Polygon Customizing the Appearance of an Outline (Range Group) Opening an Excel File Using Touch Support when Moving Columns or Rows Accessing Data from Header or Footer Pie Charts Setting a GcTimeSpan Cell Spread Windows Forms 18 Product Documentation Selecting a Row of Cells Setting a General Cell Top, Bottom, or Average Rules Working with Images Setting a Background Image to a Cell Axis Customizing the Position in the Display Adding a Row or Column Excel-Formatted Files Export SheetView Collection Editor Using Operators and Special Items Customizing the Filter Bar Customizing the Overall Component Appearance Series Customizing User Searching of Data Using Pictures in Shapes Using a Character Format Validator Filling Cells with Drag and Fill Excel-Formatted Files Import Series Collection Editor Font tab Setting Cell Properties in Spread Designer Output tab View Tab Setting Column Properties in Spread Designer GcComboBox Tab Defining the Contents of the Filter Item List Cell Types Imported from Spread COM Files GcTextBox Tab Applying the Design to the Form Adding a Component to a Visual Studio 2013 Project Customizing Split Boxes Custom File Options Dialog Setting a Date-Time Cell End-User License Agreement Customizing Column Headers for Bound Sheets Formatted versus Unformatted Data Adding a Title and Subtitle to a Sheet Handling Data Using Sheet Methods Adding a Sheet Wrapping the Header Text Entering Data Actions Sheets Activating the Product Customizing the Print Preview Dialog Customizing Painting of Parts of the Component Getting Technical Support Using XP Themes with the Component Moving Rows or Columns Spread Designer Data Area Chart Settings Imported Grid Lines tab Data Plot Types Customizing the Focus Indicator for a Cell Shortcut Collection Editor Locking a Cell Allowing the User to Draw with a Tablet PC Header Count Synchronization in the Sheet Corner XY Line Charts Creating and Using External Variable Managing Grouping of Rows of User Data Printing a Child View of a Hierarchical Display Using Structured References Customizing the Appearance of Headers Using Visible Indicators in the Cell Opening Existing Files Customizing the Scroll Bars Using the Chart Control on sheet Default Map for MultiSelect and WhenAncestorOfFocused Sheet Settings Dialog Slider Tab Using Touch Support with Scrolling Customizing Enhanced Filtering Setting a GcNumber Cell Setting a GcDateTime Cell XYZ Stripe Charts Working with the Active Cell Shortcut Objects