| Name | Description | |
|---|---|---|
 | AddChart | Overloaded. Adds the chart control. |
| AddColumnFooterSpanCell | Adds a span of cells to a column footer for a sheet. |
| AddColumnHeaderSpanCell | Adds a span of cells to a column header for a sheet. |
| AddColumns | Adds the column or columns to the data model at the specified index. |
| AddControl | Overloaded. Adds a child control to the control container for the sheet. |
| AddCustomName | Overloaded. Adds a custom name to the model using the specified string value. |
| AddRangeGroup | Groups all the rows or columns from the specified start index by the specified amount to an outline (range group). |
| AddRowHeaderSpanCell | Adds a span of cells to a row header for a sheet. |
| AddRows | Adds a row or rows to the data model for a sheet. |
| AddRowToDataSource | Adds the unbound row to the data source for a sheet. |
| AddSelection | Adds a selection on this sheet. |
| AddShape | Overloaded. Adds a shape to the drawing container for the sheet. |
| AddSpanCell | Adds a span of cells on this sheet. |
| AddSparkline | Overloaded. Adds the sparkline. |
| AddSquareSparkline | Adds the sparkline. |
| AddTable | Overloaded. Adds a table with the specified name to the specified cell range of the sheet view with the specified style. |
| AddUnboundRows | Adds unbound rows to the data model for a sheet. |
| AddValidators | Overloaded. Adds validators to a cell range. |
| AutoFilterColumn | Automatically filters the rows in the specified column according to the specified filter. |
| AutoFilterReset | Resets the filters on the rows in the specified column. |
| AutoSortColumn | Overloaded. Automatically sorts the rows of a sheet according to the specified column. |
| BindDataColumn | Binds the column to the data source column for a sheet. |
| ClearColumnFooterSpanCells | Removes all spans from the column footers. |
| ClearColumnHeaderSpanCells | Removes all spans from the column headers. |
| ClearConditionalFormating | Overloaded. Removes all the conditional formatting from the specified cell. |
| ClearConditionalFormatings | Removes all the conditional formatting from the sheet. |
| ClearControls | Removes all child controls from the control container for the sheet. |
| ClearCustomFunctions | Removes all user-defined custom functions (FunctionInfo object) on this sheet from the model. |
| ClearCustomNames | Overloaded. Removes all custom names on this sheet from the model. |
| ClearRange | Overloaded. Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet. |
| ClearRangeGroup | Removes all the outlines (range grouping) from all rows or columns. |
| ClearRowFilter | Overloaded. Removes all of the row filters from this sheet. |
| ClearRowHeaderSpanCells | Removes all spans from the row headers. |
| ClearSelection | Removes all selections from this sheet. |
| ClearShapes | Removes all shapes from the drawing container for the sheet. |
| ClearSpanCells | Removes all spans from this sheet. |
| ClearSparklineGroupsInRange | Clears all sparkline groups. |
| ClearSparklines | Clears all sparklines. |
| ClearValidators | Clears validators. |
| ClipboardCopy | Overloaded. Copies the contents from the sheet to the Clipboard. |
| ClipboardCopyShape | Copies the active shape to the Clipboard. |
| ClipboardCut | Overloaded. Cuts the contents from the sheet to the Clipboard. |
| ClipboardCutShape | Cuts the active shape to the Clipboard. |
| ClipboardPaste | Overloaded. Pastes the contents from the Clipboard to the active sheet. |
| ClipboardPasteShape | Overloaded. Pastes the shape from the Clipboard. |
| ConvertTableToRange | Converts the specified table to a range. |
| CopyRange | Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location. |
| EvaluateExpression | Overloaded. Evaluates the expression and returns the resulting object for the cell at the specified row and column. |
| ExpandRangeGroup | Overloaded. Expands or collapses a specified outline (range group) of rows or columns. |
| ExpandRow | Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display. |
| FillRange | Overloaded. Fills a range of cells on this sheet by copying a specified range in the specified direction. |
| FindChildView | Gets the child view for this sheet with the specified name. |
| GetArray | Gets a two-dimensional array of objects that contain the data for the specified range of cells on the sheet. |
| GetCellErrorText | Gets the error text of a specified cell. |
| GetCellFromTag | Gets a cell with a specific tag on the sheet. |
| GetCellType | Gets the CellType. |
| GetChildRelation | Gets the name of the child data relation at the specified index on the sheet. |
| GetChildSheets | Gets a list of child sheet views that have been created. |
| GetChildView | Creates the sheet (SheetView object) for the specified row and the specified relation index. |
| GetChildVisible | Gets whether to show the child view on this sheet when the parent row is expanded. |
| GetClip | Gets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet. |
| GetClipDataObject | Gets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange, and RowInfoRange. |
| GetClipValue | Gets a tab-delimited string that contains the unformatted data in a range of cells on this sheet. |
| GetColumnAllowAutoSort | Gets whether the specified column on this sheet allows automatic sorting. |
| GetColumnAllowFilter | Gets whether this column contains a column filter definition. |
| GetColumnAutoFilterIndex | Gets the automatic filter index for the specified column. |
| GetColumnAutoSortIndex | Gets the automatic sort index for the specified column. |
| GetColumnAutoText | Gets the automatic text displayed in the column header for the specified column on this sheet. |
| GetColumnFooterText | Gets the text in the specified column footer cell on this sheet. |
| GetColumnFromTag | Gets a column on this sheet with a specific tag. |
| GetColumnHeaderSpanCell | Gets the range of cells that are spanned at a specified cell on the column header of this sheet. |
| GetColumnLabel | Gets the text in the specified column header cell on this sheet. |
| 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. |
| GetColumnPageBreak | Gets whether a forced page break is inserted before the specified column on this sheet when printing. |
| GetColumnShowSortIndicator | Gets whether the specified column on this sheet should display a sort indicator when automatically sorted. |
| GetColumnSizeable | Gets whether the user can resize a specified column on this sheet. |
| GetColumnSortIndicator | Gets the sort indicator for the specified column on this sheet. |
| GetColumnVisible | Gets whether a column on this sheet is displayed. |
| GetColumnWidth | Gets the width in pixels for the specified column on this sheet. |
| GetConditionalFormatting | Overloaded. Gets all conditional formatting in the specified cell range. |
| GetControl | Gets a child control. |
| GetControlContainer | Gets the control container for a sheet. |
| GetCustomFunctionEnumerator | Gets an IEnumerator for this sheet that enumerates through the names of the user-defined custom functions (FunctionInfo objects) in the model. |
| GetCustomName | Overloaded. Gets the string value for a custom name on this sheet from the model. |
| GetCustomNameComment | Gets the comment of the custom name. |
| GetCustomNameEnumerator | Overloaded. Gets an IEnumerator on this sheet that enumerates through the custom names defined in the model. |
| GetDataView | Gets the DataView object on this sheet. |
| GetEditor | Gets the editor used to edit a specified cell on this sheet. |
| GetFilterBarCellType | Gets the composited (inherited) cell type for a specified cell on the filter bar. |
| GetFormula | Gets the formula of the specified cell on this sheet. |
| GetLastNonEmptyColumn | Gets the index of the last column that contains data or formatting on this sheet. |
| GetLastNonEmptyRow | Gets the row index of the last row that contains data or formatting on this sheet. |
| GetModelColumnFromViewColumn | Gets the column index in the data model that corresponds to the specified column index in the sheet. |
| GetModelRowFromViewRow | Gets the row index in the data model that corresponds to the specified row index in the sheet. |
| GetNote | Gets the note (comments) from a specified cell. |
| GetNoteBounds | Gets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote. |
| GetPreferredCellSize | Gets the desired size of the given cell on this sheet. |
| GetPreferredColumnWidth | Overloaded. Gets the width of the widest cell (based on text content) in the specified column on this sheet. |
| 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. |
| GetPreferredPrintRowHeight | Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet. |
| GetPreferredRowHeight | Overloaded. Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet. |
| GetRangeGroupInfo | Gets range groups of rows or columns by level. |
| GetRangeGroupLevels | Gets the number of levels of rows or columns in the outline (range group). |
| GetRenderer | Gets the renderer used to render a specified cell on this sheet. |
| GetRootSheet | Gets the top SheetView object. |
| GetRowAutoText | Gets the automatic text displayed in the row header for the specified row on this sheet. |
| GetRowErrorText | Gets the row error text. |
| GetRowExpandable | Gets whether the row on this sheet can be expanded to show a child view in a hierarchical display. |
| GetRowFromTag | Gets a row on this sheet with a specific tag. |
| GetRowHeaderSpanCell | Gets the range of cells that are spanned at a specified cell on the row header of this sheet. |
| GetRowHeight | Gets the height in pixels for the specified row on this sheet. |
| GetRowLabel | Gets the text in the specified row header cell on this sheet. |
| 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. |
| GetRowPageBreak | Gets whether a forced page break is inserted before the specified row on this sheet when printing. |
| GetRowSizeable | Gets whether users can resize the specified row on this sheet. |
| GetRowVisible | Gets whether a row on this sheet is displayed. |
| GetSelection | Gets the selection on this sheet with the specified index. |
| 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. |
| GetShape | Gets a shape. |
| GetSpanCell | Gets the range of cells that are spanned at a specified cell on this sheet. |
| GetSparkline | Gets the sparkline information. |
| GetStickyNoteStyleInfo | Gets the style information for the cell notes on this sheet that stay visible. |
| GetStyleInfo | Overloaded. Gets the style information for a specified cell on this sheet. |
| GetTable | Overloaded. Gets a TableView by name. |
| GetTableEnumerator | Gets the FarPoint.Win.Spread.Model.ITableRange enumerator. |
| GetTag | Gets the application-defined tag value for the specified cell, column, row, or entire sheet. |
| GetText | Gets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell. |
| GetUnboundValue | Gets the unbound value for the cell on this sheet. |
| GetValidConditionalFormat | Gets the valid conditional format. |
| GetValue | Gets unformatted data from the specified cell on this sheet. |
| GetViewColumnFromModelColumn | Gets the column on the sheet that corresponds to the specified column index in the model. |
| GetViewRowFromModelRow | Gets the row on the sheet that corresponds to the specified row index in the model. |
| GroupSparkline | Overloaded. Groups the sparkline and sets the type of new group. |
| IsAnyCellInColumnSelected | Gets whether any cells in the specified column on this sheet are selected. |
| IsAnyCellInRowSelected | Gets whether any cells in the specified row on this sheet are selected. |
| IsColumnBound | Gets whether the specified column on this sheet is bound to a data source. |
| IsRowBound | Gets whether the specified row on this sheet is bound to a data source. |
| IsRowExpanded | Gets whether the row on this sheet displays a child view in a hierarchical display. |
| IsSelected | Gets whether the specified cell on this sheet is selected. |
| JoinShapes | Joins two shapes in the drawing container for the sheet. |
| LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. |
| LoadTextFile | Overloaded. Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding. |
| LoadTextFileRange | Overloaded. Loads delimited text from a specified file into the sheet. |
| ModifyCustomName | Modifies the name of a custom name. |
| 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. |
| MoveRange | Moves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location. |
| 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. |
| OnSheetRangeGroupModelChanged | Changes the sheet row axis model in synchronization with the data source. |
| Open | Overloaded. Opens a saved XML file into a sheet view. |
| OpenExcel | Overloaded. Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet. |
| OpenSpreadFile | Opens a saved Spread file into this sheet. |
| RaiseCellChanged | Overloaded. Raises the CellChanged event (that a change has been made to a cell on this sheet). |
| RaisePropertyChanged | Raises the PropertyChanged event for this sheet. |
| Recalculate | Evaluates all the formulas in cells on the sheet that have changed since the last calculation cycle. |
| RecalculateAll | Evaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle). |
| RemoveColumnFooterSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the column footers. |
| RemoveColumnHeaderSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the column headers. |
| RemoveColumns | Removes the column or columns on this sheet at the specified index. |
| RemoveControl | Overloaded. Removes the child control from the control container for the sheet. |
| RemoveCustomFunction | Removes a user-defined custom function (FunctionInfo object) on this sheet from the model. |
| RemoveCustomName | Overloaded. Removes a custom name on this sheet from the model. |
| 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. |
| RemoveRowHeaderSpanCell | Removes the span that contains a specified anchor cell from a range of cells in the row headers. |
| RemoveRows | Removes the row or rows on this sheet at the specified index. |
| RemoveSelection | Removes the specified selection from this sheet. |
| RemoveShape | Removes the shape from the drawing container for the sheet. |
| RemoveSpanCell | Removes the span that contains a specified anchor cell from a range of cells on this sheet. |
| RemoveTable | Removes a TableView. |
| Reset | Resets the view on this sheet to its original state. |
| ResumeAutoUpdateChartData | Resumes updates of values to the chart immediately. |
| Save | Overloaded. Saves the contents of the sheet view to the specified file. |
| SaveHtml | Overloaded. Saves the sheet to the specified file in HTML. |
| SaveHtmlRange | Overloaded. Saves the specified range in the sheet to the specified file in HTML. |
| SaveTextFile | Overloaded. Saves the sheet as delimited text to a file with specific delimiters. |
| SaveTextFileRange | Overloaded. Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters. |
| SaveXml | Overloaded. Saves the data on the sheet to the specified XML stream and the schema to the specified schema stream. |
| SetActiveCell | Overloaded. Sets the active cell on this sheet. |
| SetArray | Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet. |
| SetCellErrorText | Sets the error text for a specified cell. |
| SetChildVisible | Sets whether to make the child view on this sheet visible when the parent row is expanded. |
| SetClip | Sets a tab-delimited string of formatted text in a specified range of cells on this sheet. |
| SetClipSpecial | Overloaded. Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option. |
| SetClipValue | Sets a tab-delimited string of unformatted data in a specified range of cells on this sheet. |
| SetColumnAllowAutoSort | Overloaded. Sets whether the specified column on this sheet allows automatic sorting. |
| SetColumnAllowFilter | Overloaded. Sets whether the specified column on this sheet allows filtering. |
| SetColumnAutoFilterIndex | Sets the automatic filter index for the specified column. |
| SetColumnAutoSortIndex | Sets the automatic sort index for the specified column. |
| SetColumnLabel | Sets the value for a specified cell in a column header on this sheet. |
| 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. |
| SetColumnPageBreak | Sets whether a forced page break is inserted before the specified column on this sheet when printing. |
| SetColumnShowSortIndicator | Overloaded. Sets whether the specified column or columns should show a sort indicator when automatically sorted. |
| SetColumnSizeable | Sets whether the user can resize a specified column on this sheet. |
| SetColumnSortIndicator | Sets the sort indicator for the specified column on this sheet. |
| SetColumnVisible | Sets whether a column on this sheet is displayed. |
| SetColumnWidth | Sets the width in pixels for the specified column on this sheet. |
| SetConditionalFormatting | Overloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules. |
| SetCustomNameComment | Adds a comment to the specified custom name. |
| SetErrorValue | Sets the value for the specified cell on this sheet. |
| SetFormula | Sets a formula in a specified cell on this sheet. |
| SetInsideBorder | Sets borders on the inside of a range of cells. |
| SetModelColumnForViewColumn | Sets the column index in the data model that corresponds to the specified column index in the sheet. |
| SetModelRowForViewRow | Sets the row index in the data model that corresponds to the specified row index in the sheet. |
| SetMultipleColumnWidths | Sets the width in pixels for the specified columns on this sheet. |
| SetMultipleRowHeights | Sets the height in pixels for the specified rows on this sheet. |
| SetNote | Sets a note in a specified cell on this sheet. |
| SetNoteBounds | Sets the location and dimensions for a cell note when the style sets the note to always be shown. |
| SetOutlineBorder | Sets border outlines for a range of cells. |
| SetRowErrorText | Sets error text for row. |
| SetRowExpandable | Sets whether the row on this sheet can be expanded to show a child view in a hierarchical display. |
| SetRowHeight | Sets the height in pixels for the specified row on this sheet. |
| SetRowLabel | Sets the value for a specified cell in the row header on this sheet. |
| 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. |
| SetRowPageBreak | Sets whether a forced page break is inserted before the specified row on this sheet when printing. |
| SetRowSizeable | Sets whether users can resize the specified row on this sheet. |
| SetRowVisible | Sets whether a row on this sheet is displayed. |
| SetStickyNoteStyleInfo | Sets the style information for the cell notes on this sheet that stay visible. |
| SetStyleInfo | Sets the style for a cell, a column, a row, or an entire sheet. |
| SetTag | Sets the application-defined tag value for the specified cell, column, row, or entire sheet. |
| SetText | Sets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell. |
| SetValue | Overloaded. Sets the value for the specified cell on this sheet. |
| ShouldSerializeBackgroundImage | Gets whether the background image should be serialized. |
| ShouldSerializeColumnFooterSheetCornerHorizontalGridLine | Gets whether the horizontal grid line for the footer corner should be serialized. |
| ShouldSerializeColumnFooterSheetCornerVerticalGridLine | Gets whether the vertical grid line for the footer corner should be serialized. |
| ShouldSerializeIsBackgroundImageTiled | Gets whether the tiled background image should be serialized. |
| ShowNotes | Shows or hides all cell notes on the sheet. |
| SortColumns | Overloaded. Sorts a range of columns in the sheet. |
| SortRange | Sorts a range of cells on this sheet in the data model. |
| SortRows | Overloaded. Sorts a range of rows in the sheet. |
| SuspendAutoUpdateChartData | Suspends updates of values to the chart immediately. |
| SwapRange | Swaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet. |
| UngroupSparkline | Overloaded. Ungroups the sparkline. |
| UpdateNotes | Overloaded. Updates cell note appearances based on style being set or on changes to note text. |
| Validate | Validates a cell. |
For a list of all members of this type, see SheetView members.
Public Methods
Protected Methods
| Name | Description | |
|---|---|---|
 | GetColumnVisibleCount | Gets the number of the visible columns. |
| GetRowVisibleCount | Gets the number of the visible rows. |
| OnAddColumnFooterRows | Occurs when footer rows are added. |
| OnDisposing | Raises the Disposing event |
| OnNoteCreated | Occurs when a note for the viewport area is created in the sheet's notes container. |
| OnNoteMoved | Occurs when a note for the viewport area is moved in the sheet's notes container. |
| OnNoteSized | Occurs when a note for the viewport area is sized in the sheet's notes container. |
| OnRemoveColumnFooterRows | Occurs when column footer rows are removed. |
| ShouldSerializeColumnFooterSheetCornerStyle | Gets whether the style for the sheet corner should be serialized. |
| ShouldSerializeFilterBarHeaderStyle | Gets whether the style for the filter bar header should be serialized. |
| ShouldSerializeLockFont | Determines whether lock font should be serialized. |
| ShouldSerializeNullBackColor | Determines whether null background color should be serialized. |
| ShouldSerializeNullFont | Determines whether null font should be serialized. |
| ShouldSerializeNullForeColor | Determines whether null text color should be serialized. |
| ShouldSerializeSelectionFont | Determines whether selection font should be serialized. |
See Also
Reference
SheetView Class
FarPoint.Win.Spread Namespace
User-Task Documentation
Adding a Sheet
Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet