| Name | Description |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddChart | Overloaded. Adds the chart control. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddColumnFooterSpanCell | Adds a span of cells to a column footer for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddColumnHeaderSpanCell | Adds a span of cells to a column header for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddColumns | Adds the column or columns to the data model at the specified index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddControl | Overloaded. Adds a child control to the control container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddCustomName | Overloaded. Adds a custom name to the model using the specified string value. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddRangeGroup | Groups all the rows or columns from the specified start index by the specified amount to an outline (range group). |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddRowHeaderSpanCell | Adds a span of cells to a row header for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddRows | Adds a row or rows to the data model for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddRowToDataSource | Adds the unbound row to the data source for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddSelection | Adds a selection on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddShape | Overloaded. Adds a shape to the drawing container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddSpanCell | Adds a span of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddSparkline | Overloaded. Adds the sparkline. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddSquareSparkline | Adds the sparkline. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddTable | Overloaded. Adds a table with the specified name to the specified cell range of the sheet view with the specified style. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddUnboundRows | Adds unbound rows to the data model for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddValidation | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AddValidators | Overloaded. Adds validators to a cell range. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AsWorksheet | Gets the coressponding GrapeCity.Spreadsheet.IWorksheet object that allows accessing to new object model and API set. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AutoFilterColumn | Automatically filters the rows in the specified column according to the specified filter. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AutoFilterReset | Resets the filters on the rows in the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | AutoSortColumn | Overloaded. Automatically sorts the rows of a sheet according to the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | BindDataColumn | Binds the column to the data source column for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearColumnFooterSpanCells | Removes all spans from the column footers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearColumnHeaderSpanCells | Removes all spans from the column headers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearConditionalFormating | Overloaded. Removes all the conditional formatting from the specified cell. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearConditionalFormatings | Removes all the conditional formatting from the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearControls | Removes all child controls from the control container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearCustomFunctions | Removes all user-defined custom functions (FunctionInfo object) on this sheet from the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearCustomNames | Overloaded. Removes all custom names on this sheet from the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearRange | Overloaded. Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearRangeGroup | Removes all the outlines (range grouping) from all rows or columns. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearRowFilter | Overloaded. Removes all of the row filters from this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearRowHeaderSpanCells | Removes all spans from the row headers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearSelection | Removes all selections from this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearShapes | Removes all shapes from the drawing container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearSpanCells | Removes all spans from this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearSparklineGroupsInRange | Clears all sparkline groups. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearSparklines | Clears all sparklines. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClearValidators | Clears validators. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardCopy | Overloaded. Copies the contents from the sheet to the Clipboard. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardCopyShape | Copies the active shape to the Clipboard. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardCut | Overloaded. Cuts the contents from the sheet to the Clipboard. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardCutShape | Cuts the active shape to the Clipboard. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardPaste | Overloaded. Pastes the contents from the Clipboard to the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ClipboardPasteShape | Overloaded. Pastes the shape from the Clipboard. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Clone | Creates a copy of the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ContainMultiCellsArrayFormula | Checks whether a specified range contains multi-cells array formula |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ConvertTableToRange | Converts the specified table to a range. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | CopyRange | Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | CopyScTableStyleTo | Copy SC's tablestyle of this SheetView to target SheetView. Intended to be use when creata a new SheetView from another SheetView in designer only Internal use only. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | CreateObjRef | (Inherited from System.MarshalByRefObject) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Dispose | Overloaded. Overridden. Cleans up any resources being used. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | EvaluateExpression | Overloaded. Evaluates the expression and returns the resulting object for the cell at the specified row and column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ExpandRangeGroup | Overloaded. Expands or collapses a specified outline (range group) of rows or columns. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ExpandRow | Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | FillRange | Overloaded. Fills a range of cells on this sheet by copying a specified range in the specified direction. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | FindChildView | Gets the child view for this sheet with the specified name. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | FireRemovedFromSpread | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetAllFormulaArray | Gets all formula array. Internal use only. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetArray | Gets a two-dimensional array of objects that contain the data for the specified range of cells on the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCellErrorText | Gets the error text of a specified cell. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCellFromTag | Gets a cell with a specific tag on the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCellNoteInternal | Internal use only. Gets the cell note object of a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCellType | Gets the CellType. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetChart | Get chart at index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetChildRelation | Gets the name of the child data relation at the specified index on the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetChildSheets | Gets a list of child sheet views that have been created. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetChildView | Creates the sheet (SheetView object) for the specified row and the specified relation index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetChildVisible | Gets whether to show the child view on this sheet when the parent row is expanded. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetClip | Gets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetClipDataObject | Gets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange, and RowInfoRange. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetClipValue | Gets a tab-delimited string that contains the unformatted data in a range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnAllowAutoSort | Gets whether the specified column on this sheet allows automatic sorting. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnAllowFilter | Gets whether this column contains a column filter definition. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnAutoFilterIndex | Gets the automatic filter index for the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnAutoSortIndex | Gets the automatic sort index for the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnAutoText | Gets the automatic text displayed in the column header for the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnFooterText | Gets the text in the specified column footer cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnFromTag | Gets a column on this sheet with a specific tag. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnHeaderSpanCell | Gets the range of cells that are spanned at a specified cell on the column header of this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnLabel | Gets the text in the specified column header cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnMerge | Gets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnPageBreak | Gets whether a forced page break is inserted before the specified column on this sheet when printing. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnShowSortIndicator | Gets whether the specified column on this sheet should display a sort indicator when automatically sorted. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnSizeable | Gets whether the user can resize a specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnSortIndicator | Gets the sort indicator for the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnVisible | Gets whether a column on this sheet is displayed. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetColumnWidth | Gets the width in pixels for the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCompositedStyleProperties | Gets composited style and return its properties. Support feature exporting to html |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetConditionalFormatting | Overloaded. Gets all conditional formatting in the specified cell range. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetControl | Gets a child control. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetControlContainer | Gets the control container for a sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCustomFunctionEnumerator | Gets an IEnumerator for this sheet that enumerates through the names of the user-defined custom functions (FunctionInfo objects) in the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCustomName | Overloaded. Gets the string value for a custom name on this sheet from the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCustomNameComment | Gets the comment of the custom name. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetCustomNameEnumerator | Overloaded. Gets an IEnumerator on this sheet that enumerates through the custom names defined in the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetDataView | Gets the DataView object on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetDropDownFilterItems | Gets the filter items to be displayed in the drop-down list for the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetEditor | Gets the editor used to edit a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetExcelSheetNames | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetFilterBarCellType | Gets the composited (inherited) cell type for a specified cell on the filter bar. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetFormula | Gets the formula of the specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetFormulaArray | Gets the formula array at the specified row and column index. Internal use only. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetLastNonEmptyColumn | Gets the index of the last column that contains data or formatting on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetLastNonEmptyRow | Gets the row index of the last row that contains data or formatting on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetLifetimeService | (Inherited from System.MarshalByRefObject) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetModelColumnFromViewColumn | Gets the column index in the data model that corresponds to the specified column index in the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetModelRowFromViewRow | Gets the row index in the data model that corresponds to the specified row index in the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNote | Gets the note of a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNoteBounds | Gets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNoteColumnIndex | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNoteRowIndex | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNoteStyle | Gets the composited style of notes of a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetNoteZoomFactor | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetObjectData | Serializes the object to the SerializationInfo object. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetPreferredCellSize | Gets the desired size of the given cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetPreferredColumnWidth | Overloaded. Gets the width of the widest cell (based on text content) in the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetPreferredPrintColumnWidth | Gets the width of the widest cell (based on text content) in the specified column on this sheet for printing to the specified graphics device. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetPreferredPrintRowHeight | Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetPreferredRowHeight | Overloaded. Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRangeGroupInfo | Gets range groups of rows or columns by level. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRangeGroupLevels | Gets the number of levels of rows or columns in the outline (range group). |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRenderer | Gets the renderer used to render a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRootSheet | Gets the top SheetView object. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowAutoText | Gets the automatic text displayed in the row header for the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowErrorText | Gets the row error text. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowExpandable | Gets whether the row on this sheet can be expanded to show a child view in a hierarchical display. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowFromTag | Gets a row on this sheet with a specific tag. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowHeaderSpanCell | Gets the range of cells that are spanned at a specified cell on the row header of this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowHeight | Gets the height in pixels for the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowLabel | Gets the text in the specified row header cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowMerge | Gets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowPageBreak | Gets whether a forced page break is inserted before the specified row on this sheet when printing. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowSizeable | Gets whether users can resize the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetRowVisible | Gets whether a row on this sheet is displayed. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetSelection | Gets the selection on this sheet with the specified index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetSelections | Gets an ordered array of FarPoint.Win.Spread.Model.CellRange objects, from largest to smallest, that contain the selected cells on the sheet with minimal overlap between the ranges. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetShape | Gets a shape. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetSpanCell | Gets the range of cells that are spanned at a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetSparkline | Gets the sparkline information. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetStickyNoteStyleInfo | Gets the style information for the cell notes on this sheet that stay visible. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetStyleInfo | Overloaded. Gets the style information for a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetTable | Overloaded. Gets a TableView by name. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetTableEnumerator | Gets the FarPoint.Win.Spread.Model.ITableRange enumerator. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetTag | Gets the application-defined tag value for the specified cell, column, row, or entire sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetText | Gets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetUnboundValue | Gets the unbound value for the cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetValidators | Gets validators which associates to the specified cell range. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetValidConditionalFormat | Gets the valid conditional format. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetValue | Gets unformatted data from the specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetViewColumnFromModelColumn | Gets the column on the sheet that corresponds to the specified column index in the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GetViewRowFromModelRow | Gets the row on the sheet that corresponds to the specified row index in the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | GroupSparkline | Overloaded. Groups the sparkline and sets the type of new group. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | InitializeLifetimeService | (Inherited from System.MarshalByRefObject) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | InternalShouldSerializeAutoSortColumns | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | InvalidateRowFilter | Resets all the temporary filter settings and filters the rows again based on the filter settings of each column. (Internal use only.) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsAnyCellInColumnSelected | Gets whether any cells in the specified column on this sheet are selected. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsAnyCellInRowSelected | Gets whether any cells in the specified row on this sheet are selected. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsColumnBound | Gets whether the specified column on this sheet is bound to a data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsRowBound | Gets whether the specified row on this sheet is bound to a data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsRowExpanded | Gets whether the row on this sheet displays a child view in a hierarchical display. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | IsSelected | Gets whether the specified cell on this sheet is selected. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | JoinShapes | Joins two shapes in the drawing container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | LoadExpressionECF | Reload the expressions of all Conditional Formatting in current sheet, when we have fully data. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | LoadTextFile | Overloaded. Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | LoadTextFileRange | Overloaded. Loads delimited text from a specified file into the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ModifyCustomName | Modifies the name of a custom name. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | MoveColumn | Overloaded. Moves the specified column from its current index to the specified index, and shifts each column in between and the destination column one column in the direction of the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | MoveRange | Moves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | MoveRow | Overloaded. Moves the specified row from its current index to the specified index, and shifts each row in between and the destination row one row in the direction of the specified row. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OnDataModelChanged | Changes the data model for this sheet in synchronization with the data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OnSheetColumnAxisModelChanged | Changes the sheet column axis model in synchronization with the data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OnSheetRangeGroupModelChanged | Changes the sheet row axis model in synchronization with the data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OnSheetRowAxisModelChanged | Changes the sheet row axis model in synchronization with the data source. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OnSpanModelChanged | Changes the span model in sync with the data source for this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Open | Overloaded. Opens a saved XML file into a sheet view. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OpenExcel | Overloaded. Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | OpenSpreadFile | Opens a saved Spread file into this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RaiseCellChanged | Overloaded. Raises the CellChanged event (that a change has been made to a cell on this sheet). |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RaisePropertyChanged | Raises the PropertyChanged event for this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Recalculate | Evaluates all the formulas in cells on the sheet that have changed since the last calculation cycle. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RecalculateAll | Evaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle). |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveColumnFooterSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the column footers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveColumnHeaderSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the column headers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveColumns | Removes the column or columns on this sheet at the specified index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveControl | Overloaded. Removes the child control from the control container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveCustomFunction | Removes a user-defined custom function (FunctionInfo object) on this sheet from the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveCustomName | Overloaded. Removes a custom name on this sheet from the model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveRangeGroup | Removes rows or columns from an outline (range group) from a specified start index by a specified amount, and returns them to individual rows or columns. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveRowHeaderSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the row headers. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveRows | Removes the row or rows on this sheet at the specified index. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveSelection | Removes the specified selection from this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveShape | Removes the shape from the drawing container for the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveSpanCell | Removes the span that contains a specified anchor cell from a range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | RemoveTable | Removes a TableView. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Reset | Resets the view on this sheet to its original state. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ResetFilteredColumn | Internal Use: Resets the display of rows based on the "(All)" filter item in the drop-down list. (Internal use only.) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ResumeAutoUpdateChartData | Resumes updates of values to the chart immediately. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ResumeFormulaParsing | Resumes parsing of formulas and parses all formulas set while parsing was suspended. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Save | Overloaded. Saves the contents of the sheet view to the specified file. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SaveHtml | Overloaded. Saves the sheet to the specified file in HTML. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SaveHtmlRange | Overloaded. Saves the specified range in the sheet to the specified file in HTML. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SaveTextFile | Overloaded. Saves the sheet as delimited text to a file with specific delimiters. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SaveTextFileRange | Overloaded. Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SaveXml | Overloaded. Saves the data on the sheet to the specified XML stream and the schema to the specified schema stream. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetActiveCell | Overloaded. Sets the active cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetArray | Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetCellErrorText | Sets the error text for a specified cell. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetChildVisible | Sets whether to make the child view on this sheet visible when the parent row is expanded. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetClip | Sets a tab-delimited string of formatted text in a specified range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetClipSpecial | Overloaded. Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetClipValue | Sets a tab-delimited string of unformatted data in a specified range of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnAllowAutoSort | Overloaded. Sets whether the specified column on this sheet allows automatic sorting. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnAllowFilter | Overloaded. Sets whether the specified column on this sheet allows filtering. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnAutoFilterIndex | Sets the automatic filter index for the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnAutoSortIndex | Sets the automatic sort index for the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnLabel | Sets the value for a specified cell in a column header on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnMerge | Sets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnPageBreak | Sets whether a forced page break is inserted before the specified column on this sheet when printing. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnShowSortIndicator | Overloaded. Sets whether the specified column on this sheet should display a sort indicator when automatically sorted. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnSizeable | Sets whether the user can resize a specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnSortIndicator | Sets the sort indicator for the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnVisible | Sets whether a column on this sheet is displayed. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetColumnWidth | Sets the width in pixels for the specified column on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetConditionalFormatting | Overloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetCustomNameComment | Adds a comment to the specified custom name. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetErrorValue | Sets the value for the specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetFilteredColumn | Overloaded. Internal Use: Applies the row filtering to the specified column when the specified filter item is selected from the drop-down list. (Internal use only.) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetFormula | Sets a formula in a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetInsideBorder | Sets borders on the inside of a range of cells. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetModelColumnForViewColumn | Sets the column index in the data model that corresponds to the specified column index in the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetModelRowForViewRow | Sets the row index in the data model that corresponds to the specified row index in the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetMultipleColumnWidths | Sets the width in pixels for the specified columns on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetMultipleRowHeights | Sets the height in pixels for the specified rows on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetNote | Sets a note in a specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetNoteBounds | Sets the location and dimensions for a cell note when the style sets the note to always be shown. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetOutlineBorder | Sets border outlines for a range of cells. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowErrorText | Sets error text for row. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowExpandable | Sets whether the row on this sheet can be expanded to show a child view in a hierarchical display. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowHeight | Sets the height in pixels for the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowLabel | Sets the value for a specified cell in the row header on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowMerge | Sets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowPageBreak | Sets whether a forced page break is inserted before the specified row on this sheet when printing. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowSizeable | Sets whether users can resize the specified row on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetRowVisible | Sets whether a row on this sheet is displayed. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetStickyNoteStyleInfo | Sets the style information for the cell notes on this sheet that stay visible. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetStyleInfo | Sets the style for a cell, a column, a row, or an entire sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetTag | Sets the application-defined tag value for the specified cell, column, row, or entire sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetText | Sets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SetValue | Overloaded. Sets the value for the specified cell on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeBackgroundImage | Gets whether the background image should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeColumnFooterSheetCornerHorizontalGridLine | Gets whether the horizontal grid line for the footer corner should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeColumnFooterSheetCornerVerticalGridLine | Gets whether the vertical grid line for the footer corner should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeHorizontalGridLine | Gets whether the horizontal grid line for the data area should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeIsBackgroundImageTiled | Gets whether the tiled background image should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeModels | Gets whether the document models for the sheet should be persisted. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeNamedStyles | Internal use only. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeSheetCornerHorizontalGridLine | Gets whether the horizontal grid line for the corner should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeSheetCornerVerticalGridLine | Gets whether the vertical grid line for the corner should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeVerticalGridLine | Gets whether the vertical grid line for the data area should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShouldSerializeZoomFactor | Gets whether the zoom factor should be serialized. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ShowNotes | Shows or hides all cell notes on the sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SortColumns | Overloaded. Sorts all the columns on the sheet by the specified row. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SortRange | Sorts a range of cells on this sheet in the data model. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SortRows | Overloaded. Sorts all the rows on this sheet by the specified column. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SuspendAutoUpdateChartData | Suspends updates of values to the chart immediately. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SuspendFormulaParsing | Suspends parsing of formulas. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | SwapRange | Swaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | ToString | (Inherited from System.ComponentModel.Component) |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | UngroupSparkline | Overloaded. Ungroups the sparkline. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | UpdateChartOnLayoutChanged | |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | UpdateNotes | Overloaded. Updates cell note appearances based on style being set or on changes to note text. |
![Public Method](template/packages/core-dotnet/images/publicMethod.png) | Validate | Validates a cell. |