Spread for ASP.NET 18 Product Documentation Assembly Reference Client-Side Scripting Reference Scripting Members Events CellClicked CellDoubleClicked ActiveCellChanged ActiveCellChanging AutoFilteringColumn AutoFilteredColumn CallBackStart CallBackStopped ColumnDragMove ColumnDragMoveCompleted ColWidthChanged ContextMenuClosed ContextMenuOpened ContextMenuOpening CopyData DataChanged EditStart EditStopped ErrorMessageShown LoadRowsStart LoadRowsStopped MenuClicked RowHeightChanged Scroll SelectionChanged TouchStripClosed TouchStripOpened TouchStripOpening RowDragMove RowDragMoveCompleted Methods Add AddKeyMap AddSelection CallBack Cancel Cells Clear ClearSelection Columns Copy CopyLikeExcel CutLikeExcel Delete Edit EndEdit ExpandRow GetActiveChart GetActiveChildSheetView GetActiveCol GetActiveRow GetCellByRowCol GetChildSpread GetChildSpreads GetColByKey GetColCount GetColKeyFromCol GetCurrentPageIndex GetFormula GetHiddenCellValue GetHiddenValue GetLeftColIndex GetLocked GetPageCount GetParentRowIndex GetParentSpread GetRowByKey GetRowCount GetRowKeyFromRow GetSelectedRange GetSelectedRanges GetSheetColIndex GetSheetRowIndex GetSpread GetTitleInfo GetTopRowIndex GetTotalRowCount GetValue HideMessage Insert IsValid LoadData MoveToFirstColumn MoveToLastColumn MoveToNextCell MoveToNextRow MoveToPrevCell MoveToPrevRow Next Paste PasteLikeExcel Prev Print PrintPDF RemoveKeyMap ResumeLayout Rows ScrollTo SetActiveCell SetActiveChart SetBackColor SetColWidth SetForeColor SetFormula SetHiddenCellValue SetHiddenValue SetLocked SetSelectedRange SetValue ShowMessage SizeToFit SortColumn StartEdit SuspendLayout Update UpdatePostBackData Properties ActiveCol ActiveRow TapToAddSelection Classes ContextMenu MenuItem TouchStrip TouchStripItem Scripting Overview Developing a Custom HTC File Validating Date on the Client Formatting Percent Value on the Client Using a Client Scripting Method Some Simple Uses of Client Scripting Getting the Value of a Cell Finding the Cell Under the Cursor Retrieving the Text in Headers Locking a Column Doing a Quick Validation Before Postback Using Client-Side Scripting Using Attributes Background on HTC Files and Scripting Handling Invalid Client-Side Entries Mapping an Event to a Client-Side Script Typical Uses of Scripting Developer's Guide Customizing the Appearance Customizing the Appearance of a Cell Assigning a Cascading Style Sheet to a Cell Working with the Active Cell Aligning Cell Contents Allowing Cells to Merge Automatically Customizing Cell Borders Customizing the Colors of a Cell Creating a Range of Cells Customizing the Margins and Spacing of the Cell Spanning Cells Creating and Applying a Custom Style for Cells Using Sparklines Adding a Sparkline to a Cell Specifying Horizontal and Vertical Axes Working with Sparklines Customizing Markers and Pointers Customizing the Appearance of the Overall Component Customizing the Default Initial Appearance Resetting Parts of the Interface Using the jQuery Theme Roller with Spread Customizing the Outline of the Component Customizing the Dimensions of the Component Customizing the Appearance of Headers Customizing the Default Header Labels Customizing Header Label Text Customizing the Style of Header Cells Customizing the Header Empty Areas Showing or Hiding Headers Creating a Header with Multiple Rows or Columns Setting the Size of Header Cells Creating a Span in a Header Customizing the Appearance of Rows and Columns Creating Row Templates (Multiple-Line Columns) Adding a Row or Column Showing or Hiding Rows or Columns Removing a Row or Column Creating Alternating Rows Customizing the Number of Rows or Columns Setting the Row Height or Column Width Setting the Top Row to Display Customizing the Appearance of the Sheet Customizing the Sheet Corner Displaying a Footer for Columns or Groups Working with the Active Sheet Adding a Sheet Setting the Background Color of the Sheet Displaying Grid Lines on the Sheet Showing or Hiding a Sheet Adding an Image to the Sheet Working with Multiple Sheets Customizing the Page Size (Rows to Display) Removing a Sheet Applying a Skin to a Sheet Creating a Skin for Sheets Adding a Title and Subtitle to a Sheet Working with the Chart Control Creating Charts Using the Chart Control Creating the Chart Control Rendering or Saving the Chart Control to an Image Loading or Saving the Chart Control to XML Creating Plot Types Combining Plot Types Creating a Pie Plot Creating a Polar Plot Creating a Radar Plot Creating an XY Plot Creating an XYZ Plot Creating a Y Plot Creating a Sunburst Chart Creating a Treemap Chart Connecting to Data Using a Bound Data Source Using Raw Data Versus Represented Data Using an Unbound Data Source Using the Chart Designer Creating a Chart Control Using the Chart Collection Editors LabelArea Collection Editor LegendArea Collection Editor Light Collection Editor PlotArea Collection Editor Series Collection Editor Opening the Chart Designer Using the Spread Designer Using the Chart Control in Spread Creating the Chart Control with Code Using the Chart Context Menu Binding the Chart Control with Spread Setting the Chart Control Border in Spread Moving and Resizing the Chart Control in Spread Selecting the Chart Control in Spread Setting the Chart View Type Understanding and Customizing Charts Axis and Other Lines Elevation and Rotation Fill Effects Labels Legends Lighting, Shapes, and Borders Plot Types Data Plot Types Pie Plot Types Doughnut Charts Pie Charts Polar Plot Types Area Charts Line Charts Point Charts Stripe Charts Radar Plot Types Area Charts Line Charts Point Charts Stripe Charts XY Plot Types Bubble Charts Line Charts Point Charts Stripe Charts XYZ Plot Types Line Charts Point Charts Stripe Charts Surface Charts Y PlotTypes Box Whisker Charts Funnel Charts Histogram Charts Area Charts Bar Charts Line Charts Market Data (High-Low) Charts Pareto Charts Point Charts Stripe Charts Waterfall Charts Series Size - Height, Width, and Depth Chart Types and Views Chart User Interface Elements Walls Understanding the Product Concepts Overview Cell Types Formatted versus Unformatted Data Zero-Based Indexing Underlying Models Object Parentage Shortcut Objects Client-Side Scripting Maintaining State SheetView versus FpSpread Features Overview Theme Roller Validation Controls ASP.NET AJAX Extenders AJAX Support Cell Types Chart Control Client-Side Scripting Footers for Columns or Groups Conditional Formatting Context Menu Data Binding Floating Images Formula Extender Control Built-In Functions Frozen Rows and Columns Goal Seeking Grouping Hierarchical Display Import and Export Capabilities Load on Demand Multiple-Line Columns Headers with Multiple Columns and Rows Multiple Sheets Printing PDF Support Row Filtering Row Preview Row Template Editor Searching Features Corner Customization Customized Appearance (Skins) Sorting Capabilities Spannable Cells Sparklines Spread Designer Spread Wizard Title and Subtitle Touch Support Product Overview Managing Data Binding Binding to a Data Source Setting the Cell Types for Bound Data Displaying Data as a Hierarchy Model Data Binding in ASP.NET 4.5 Data Binding Overview Limiting Postbacks When Updating Bound Data Binding to a Range Handling Row Expansion Adding an Unbound Row Tutorial: Binding to a Corporate Database Managing Data in the Component Placing and Retrieving Data Handling Data Using Sheet Methods Handling Data Using Cell Properties Saving Data to the Server Server-Side Scripting Understanding Effects of Client-Side Validation Understanding the Effect of Mode on Events Understanding Postback and Page Load Events Managing File Operations Opening Existing Files Opening an Excel-Formatted File Opening a Spread XML File Opening a Text File Saving Data to a File Saving to an Excel File Saving to a PDF File Setting PDF Security Options Setting PrintInfo Class Properties Setting Smart Print Options Saving to PDF Methods Setting Headers and Footers Saving to a Spread XML File Saving to a Text File Saving to an HTML File Managing Formulas Setting Calculation Culture Specifying a Cell Reference Style in a Formula Using a Circular Reference in a Formula Creating a Custom Function Creating a Custom Name Using the Formula Extender Control Finding a Value with Goal Seeking Nesting Functions in a Formula Placing a Formula in Cells Recalculating and Updating Formulas Automatically Customizing User Interaction Working with AJAX Using ASP.NET AJAX Extenders Enabling AJAX support Customizing Interaction with Cells Locking a Cell Adding a Note to a Cell Adding a Tag to a Cell Using Conditional Formatting in Cells Conditional Formatting of Cells Creating Conditional Formatting with Rules Top or Average Rules Color Scale Rules Data Bar Rule Highlighting Rules Icon Set Rule Customizing Interaction with the Overall Component Adding a Context Menu Customizing the Graphical Interface Using the Formula Extender Control Customizing Interaction Based on Events Allowing Load on Demand Customizing the Scroll Bar Colors Searching for Data with Code Displaying Scroll Bars Displaying Scroll Bar Text Tips Handling the Tab Key Managing Filtering of Rows of User Data Using the Filter Bar Using Enhanced Filtering Customizing Simple Filtering of Rows of User Data Customizing the List of Filter Items Creating a Completely Custom Filter Using Row Filtering Creating Filtered Rows and Setting the Appearance Customizing Grouping of Rows of User Data Allowing the User to Group Rows Setting the Appearance of Grouped Rows Customizing the Group Bar Compatibility with Other Features Creating a Custom Group Using Grouping Managing Printing Printing a Spreadsheet Adding Headers and Footers to Printed Pages Customizing Interaction with Rows and Columns Allowing the User to Move Rows Freezing Rows and Columns Setting up Preview Rows Allow the User to Move Columns Allowing the User to Resize Rows or Columns Setting up Row Edit Templates Customizing Selections of Cells Working with Selections of Cells Customizing the Appearance of Selections Specifying What the User Can Select Customizing Sorting of Rows of User Data Allowing User Sorting Customizing the Toolbars Customizing the Command Bar on the Component Customizing the Command Buttons Hiding a Specific Command Button Changing the Command Button Images Customizing the Hierarchy Bar Customizing Page Navigation Buttons on the Client Customizing Page Navigation Displaying the Sheet Names Working with the SaveExcel button on the CommandBar Namespaces Overview Customizing with Cell Types Working with ASP.NET AJAX Extender Cell Types Setting an Automatic-Completion Cell Setting a Calendar Cell Setting a Combo Box Cell Setting a Filtered Text Cell Setting a Masked Edit Cell Setting a Mutually Exclusive Check Box Cell Setting a Numeric Spin Cell Setting a Rating Cell Setting a Slider Cell Setting a Slide Show Cell Setting a Text Box with Watermark Cell Understanding How Cell Types Work Determining the Cell Type of a Cell Understanding How Cell Type Affects Model Data Understanding Cell Type Basics Understanding How Cell Types Display Data Using Validation Controls Working with Editable Cell Types Displaying a Calendar in a Date-Time Cell Displaying a Number Pad in Number Cells Setting a Currency Cell Setting a Date-Time Cell Setting a Double Cell Setting a General Cell Setting an Integer Cell Limiting Values for a Currency Cell Setting a Percent Cell Setting a Regular Expression Cell Setting a Text Cell Working with Graphical Cell Types Setting a Button Cell Setting a Check Box Cell Setting a Combo Box Cell Setting a Hyperlink Cell Setting an Image Cell Setting a Label Cell Setting a List Box Cell Setting a Multiple-Column Combo Box Cell Setting a Radio Button List Cell Setting a Tag Cloud Cell Working with the Spread Designer Understanding the Spread Designer Interface Spread Designer Editors Cells, Columns, and Rows Editor DataKey Names (String Collection) Editor Row Template Editor GroupInfo Collection Editor Header Editor NamedStyle Collection Editor SheetSkin Editor SheetView Collection Editor Alternating Rows Editor Formula Editor ContextMenu Collection Editor Spread Designer Context Menus Spread Designer Menus Chart Tools Menu Data Menu File Menu Home Menu Insert Menu Settings Menu Sparklines Menu View Menu Spread Designer Toolbars Starting the Spread Designer Using the Spread Designer Adding Formulas to Cells Applying Changes and Closing Spread Designer Saving and Opening Design Files Customizing Cells in Spread Designer Customizing Sheets, Rows, and Columns in Spread Designer Getting Started Understanding the Spread Wizard Starting the Spread Wizard Using the Spread Wizard Handling Installation Product Requirements Creating a Build License End-User License Agreement Licensing a Trial Project after Installation Installing the Product Handling Redistribution Handling Variations In Windows Settings Getting More Practice Getting Technical Support Understanding Procedures in the Documentation Working with the Component Adding a Component to a Web Site using Visual Studio 2019 Working with Windows Azure Understanding Browser Support Adding JavaScript IntelliSense for Visual Studio 2015 or 2017 Working with Microsoft ASP.NET MVC 3 Working with Microsoft ASP.NET MVC 5 Working with Collection Editors Copying Shared Assemblies to Local Folder Understanding Parts of the Component Interface Adding a Component to a Web Site using Visual Studio 2015 or 2017 Working with Strongly Typed Data Controls Working with Web Parts Tutorial: Creating a Checkbook Register Adding Formulas to Calculate Balances Setting the Cell Types of the Register Setting Up the Rows and Columns of the Register Adding Spread to the Checkbook Project Adding Spread to a Project Maintaining State Loading Data for Each Page Request State Overview Saving Data to the Session State Saving Data to an SQL Database Saving Data to the View State Using Touch Support with the Component Understanding Touch Support Understanding Touch Gestures Using Touch Support Using Touch Support with AutoFit Using Touch Support with Editable Cells Using Touch Support with Charts Using Touch Support with Filtering Using Touch Support with Grouping Using the Touch Menu Bar Using Touch Support when Moving Columns Using Touch Support when Resizing Columns or Rows Using Touch Support with Scrolling Using Touch Support with Selections Using Touch Support with Sorting Using Touch Support when Moving Rows Using Sheet Models Creating a Custom Sheet Model Understanding the Optional Interfaces Understanding the Models Understanding the Axis Model Customizing Models Understanding the Data Model Understanding the Selection Model Understanding the Span Model Understanding the Style Model Understanding How the Models Work Import and Export Reference Excel-Formatted File Export Cell Settings Exported Cell Type Settings Exported Chart Settings Exported Colors Exported Print Settings Exported Row and Column Settings Exported Sheet Settings Exported Excel-Formatted File Import Cell Settings Imported Border Styles Substituted Chart Settings Imported Other Excel Settings Imported Print Settings Imported Row and Column Settings Imported Sheet Settings Imported