The following tables list the members exposed by SheetView.
Public Constructors
| Name | Description | |
|---|---|---|
 | SheetView Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveCell | Gets a Cell object for the active cell on the sheet. |
| ActiveColumn | Gets a Column object for the active column on the sheet. |
| ActiveColumnIndex | Gets or sets the column index of the active cell on the sheet. |
| ActiveRow | Gets a Row object for the active row on the sheet. |
| ActiveRowIndex | Gets or sets the row index of the active cell on the sheet. |
| ActiveSkin | Gets or sets the skin for the sheet. |
| AllowGroup | Gets or sets whether to allow the user to group rows on the sheet. |
| AllowNoteEdit | Gets or sets whether notes on this sheet are editable. |
| AllowTableCorner | Gets or sets whether the sheet corner can have a grid structure (table). |
| AlternatingRows | Gets a AlternatingRows object for the alternating rows in the data area of the sheet. |
| AutoCalculation | Gets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet. |
| AutoFilterMode | Gets or sets the AutoFilterMode. |
| AutoGenerateColumns | Gets or sets whether to automatically generate the columns for a sheet based on the data source. |
| AutoSortColumns | Gets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator. |
| AutoSortFrozenRows | Gets or sets a value that indicates whether frozen rows are sorted. |
| AutoSortTrailingFrozenRows | Gets or sets a value that indicates whether trailing frozen rows are sorted. |
| AutoUpdateNotes | Gets or sets whether cell notes are automatically updated when changes are made to the note style or to the text, or notes are added, removed, or moved. |
| BackgroundImage | Gets or sets sheetview background image. |
| BackgroundImageLayout | Gets or sets sheetview background image layout. |
| Cells | Gets a Cells object for the cells in the data area of the sheet. |
| Charts | Gets the charts. |
| ChildRelationCount | Gets the number of child relations (data relation count) for a sheet. |
| ColumnAutoSorted | Gets the index of the last column that was automatically sorted for the sheet. |
| ColumnCount | Gets or sets the number of columns in the sheet. |
| ColumnFooter | Gets the ColumnFooter object for the column footer area of the sheet. |
| ColumnFooterHorizontalGridLine | Gets or sets the horizontal grid line in the column footer for the sheet. |
| ColumnFooterRowCount | Gets or sets the number of rows in the column footers for the sheet. |
| ColumnFooterSheetCornerHorizontalGridLine | Gets or sets the horizontal grid line for the column footer sheet corner. |
| ColumnFooterSheetCornerStyle | Gets or sets the style information for the sheet corner for the column footer. |
| ColumnFooterSheetCornerStyleName | Gets or sets the name of the style for the sheet corner of the column footer. |
| ColumnFooterSheetCornerVerticalGridLine | Gets or sets the vertical grid line for the column footer sheet corner. |
| ColumnFooterVerticalGridLine | Gets or sets the vertical grid line in the column footer for the sheet. |
| ColumnFooterVisible | Gets or sets whether the column footers for this sheet are visible. |
| ColumnHeader | Gets the ColumnHeader object for the column header area of the sheet. |
| ColumnHeaderAutoFilterIndex | Gets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows. |
| ColumnHeaderAutoSortIndex | Gets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows. |
| ColumnHeaderAutoText | Gets or sets whether column headers for the sheet display letters or numbers or are blank. |
| ColumnHeaderAutoTextIndex | Gets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows. |
| ColumnHeaderHorizontalGridLine | Gets or sets the horizontal grid line for the sheet. |
| ColumnHeaderRowCount | Gets or sets the number of rows in the column headers for the sheet. |
| ColumnHeaderVerticalGridLine | Gets or sets the vertical grid line in the column header for the sheet. |
| ColumnHeaderVisible | Gets or sets whether the column headers for this sheet are visible. |
| Columns | Gets a Columns object for the columns in the data area of the sheet. |
| ContainingViews | Gets the containing views. |
| DataAllowAddNew | Gets or sets whether to allow the user to add a new row when the sheet is bound. |
| DataAutoCellTypes | Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column. |
| DataAutoHeadings | Gets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers. |
| DataAutoSizeColumns | Gets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields. |
| DataMember | Gets or sets the name of the data member that populates the sheet. |
| DataSource | Gets or sets the name of the data source that populates the sheet. |
| DefaultGroupFooter | Default setting for group footers. |
| DefaultStyle | Gets or sets a StyleInfo object for the default style of the sheet. |
| DefaultStyleName | Gets or sets the name of the default style for the sheet. |
| DisplayZero | Gets or sets whether zero values are displayed in cells. |
| EnhancedFilterSortingMode | Gets or sets whether the enhanced filter shows items in the tree by default or alphabetic order. |
| Expandable | Gets or sets whether the rows are expandable. |
| FilterBar | Gets the FilterBar object of the sheet. |
| FilterBarHeaderHorizontalGridLine | Gets or sets the horizontal grid line for the filter bar header. |
| FilterBarHeaderStyle | Gets or sets the style information for the filter bar header. |
| FilterBarHeaderStyleName | Gets or sets the name of the style for the filter bar header. |
| FilterBarHeaderVerticalGridLine | Gets or sets the vertical grid line for the filter bar. |
| FilterBarHorizontalGridLine | Gets or sets the horizontal grid line for the filter bar. |
| FilterBarVerticalGridLine | Gets or sets the vertical grid line for the filter bar. |
| FpSpread | Gets Fpspread from sheet view. |
| FrozenColumnCount | Gets or sets the number of non-scrolling columns on the leading edge of this sheet. |
| FrozenRowCount | Gets or sets the number of non-scrolling rows on the leading edge of this sheet. |
| FrozenTrailingColumnCount | Gets or sets the number of non-scrolling columns on the trailing edge of this sheet. |
| FrozenTrailingRowCount | Gets or sets the number of non-scrolling rows on the trailing edge of this sheet. |
| GrayAreaBackColor | Gets or sets the color in the area between the sheet and the edge of the control. |
| GroupBarInfo | Gets or sets the information of the grouping bar for the sheet. |
| GroupFooterVisible | Gets or sets whether the group footer is displayed. |
| GroupInfos | Gets or sets the collection of grouping information objects for the sheet. |
| GroupingPolicy | Gets or sets grouping policy to collapse or expand rows when grouping occurs. |
| GroupMaximumLevel | Gets or sets the maximum number of levels of grouping for the sheet. |
| HorizontalGridLine | Gets or sets the horizontal grid line for this sheet. |
| IsBlockSelected | Gets whether a block of cells on this sheet is currently selected. |
| Iteration | Gets or sets whether circular references are evaluated on this sheet. |
| LockBackColor | Gets or sets the background color of locked cells on this sheet. |
| LockFont | Gets or sets the default font for locked items on this sheet. |
| LockForeColor | Gets or sets the foreground color of locked cells on this sheet. |
| MaximumChange | Gets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet. |
| MaximumIterations | Gets or sets the maximum number of iterations for calculating circular references on this sheet. |
| MinZoomFactor | Gets or sets a value that indicates the minimum zoom factor for this sheet. |
| Models | Gets or sets a SheetView.DocumentModels object that contains all the models for the sheet. |
| NamedStyles | Gets or sets a NamedStyleCollection of NamedStyle objects for this sheet. |
| NonEmptyColumnCount | Gets a value that is one more than the index of the last column on this sheet containing data. |
| NonEmptyRowCount | Gets a value that is one more than the index of the last row on this sheet containing data. |
| NullBackColor | Gets or sets the background color of null items on this sheet. |
| NullFont | Gets or sets the default font for null items on this sheet. |
| NullForeColor | Gets or sets the foreground color of null items on this sheet. |
| OperationMode | Gets or sets the mode that determines mouse, keyboard, and selection behavior for this sheet. |
| Parent | Gets or sets the name of the parent sheet (SheetView object) of this sheet. |
| ParentRelationName | Gets the data relation name for this sheet. |
| ParentRowIndex | Gets the index of the parent row on this sheet. |
| PreviewRowInfo | Gets or sets preview row information for the sheet. |
| PrintInfo | Gets or sets a PrintInfo object that determines printing behavior for the sheet. |
| Protect | Gets or sets whether cells on this sheet that are marked as locked are not editable. |
| RangeGroupBackgroundColor | Gets or sets the background color of the outline (range group) region. |
| RangeGroupButtonStyle | Gets or sets the style of the outline (range group) button. |
| RangeGroupSummaryColumnRight | Gets or sets whether the direction of the summary column is to the right of the detail. |
| RangeGroupSummaryRowBelow | Gets or sets whether the direction of the summary row is below the detail. |
| ReferenceStyle | Gets or sets the style for cell and range references in formulas in cells on this sheet. |
| RestrictColumns | Gets or sets whether users are restricted from typing data in a column on this sheet that is more than one column beyond the last column that contains data. |
| RestrictRows | Gets or sets whether users are restricted from typing data in a row on this sheet that is more than one row beyond the last row that contains data. |
| RowCount | Gets or sets the number of rows on this sheet. |
| RowFilter | Gets or sets the row filter for the sheet. |
| RowHeader | Gets the RowHeader object for the row header area of the sheet. |
| RowHeaderAutoText | Gets or sets whether row headers on this sheet display letters or numbers or are blank. |
| RowHeaderAutoTextIndex | Gets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns. |
| RowHeaderColumnCount | Gets or sets the number of columns in the row header on this sheet. |
| RowHeaderHorizontalGridLine | Gets or sets the horizontal grid line in the row header on this sheet. |
| RowHeaderSelectorIndex | Gets or sets which row header column in the sheet displays the row selector when there are multiple row header columns. |
| RowHeaderVerticalGridLine | Gets or sets the vertical grid line in the row header on this sheet. |
| RowHeaderVisible | Gets or sets whether the row headers for this sheet are visible. |
| Rows | Gets a Rows object for the rows in the data area of the sheet. |
| ScrollingContentInfo | Gets or sets the information of the vertical scrolling tip for the sheet. |
| SelectionBackColor | Gets or sets the background color of selections on this sheet. |
| SelectionCount | Gets the number of selections on this sheet. |
| SelectionFont | Gets or sets the default font for selected items on this sheet. |
| SelectionForeColor | Gets or sets the foreground color of selections on this sheet. |
| SelectionPolicy | Gets the selection policy for the sheet for normal operation mode. |
| SelectionStyle | Gets or sets how selections on this sheet are drawn. |
| SelectionUnit | Gets or sets the smallest unit users or the application can select on this sheet. |
| SerializeModels | Gets or sets whether the DocumentModels for this sheet should be serialized to the form resources, rather than generating code that initializes the Cells, Columns, Rows, and AlternatingRows. |
| SheetCorner | Gets the sheet corner of the sheet. |
| SheetCornerHorizontalGridLine | Gets or sets the horizontal grid line for the sheet corner. |
| SheetCornerStyle | Gets or sets the style information for the sheet corner. |
| SheetCornerStyleName | Gets or sets the name of the style for the sheet corner. |
| SheetCornerVerticalGridLine | Gets or sets the vertical grid line for the sheet corner. |
| SheetName | Gets or sets the name of the sheet. |
| ShowRowSelector | Gets or sets a value that indicates whether to display a row selector in the row header of the selected row for the sheet. |
| SparklineContainer | |
| StartingColumnNumber | Gets or sets the number or letter displayed in the first column header on this sheet. |
| StartingRowNumber | Gets or sets the number or letter displayed in the first row header on this sheet. |
| Tag | Gets or sets an application-defined tag value associated with the cells in this sheet. |
| TitleInfo | Sheet title |
| VerticalGridLine | Gets or sets the vertical grid line on this sheet. |
| Visible | Gets or sets whether to display the sheet. |
| VisualStyles | Gets or sets whether to use visual styles when rendering objects in the sheet. |
| ZoomFactor | Gets or sets the scaling factor for displaying this sheet. |
Protected Properties
| Name | Description | |
|---|---|---|
 | CanRaiseEvents | (Inherited from System.ComponentModel.Component) |
| IgnoreApplySpreadSkin | Gets or sets a value that indicates whether to ignore applying Spread skin. |
| IsInitializing | Gets a value indicates whether SheetView is initialized. |
Public Methods
| 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. |
| AddCustomFunction | Adds a user-defined custom function (FunctionInfo object) to the model for use in formulas. |
| 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. |
| 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. |
| 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. |
| 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 composited (inherited) cell type for a specified cell on the sheet. |
| 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. |
| GetCustomFunction | Gets a user-defined custom function (FunctionInfo object) from the model for this 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 | |
| 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. |
| GetExpression | Gets the formula, as an expression value, for the cell of the specified row and column of 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 from a specific position. |
| 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 | Remove 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. |
| SetExpression | Sets the formula, as an expression, in the cell at the specified row and column of 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 background image tiled 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. |
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 of viewport area is created in the sheet's notes container. |
| OnNoteMoved | Occurs when a note of viewport area is moved in the sheet's notes container. |
| OnNoteSized | Occurs when a note of 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. |
Public Events
| Name | Description | |
|---|---|---|
 | CellChanged | Occurs when a change is made to a cell or range of cells on this sheet that may require the cell or range of cells be repainted. |
| Changed | Occurs when a change is made to the sheet that may require the entire sheet to be repainted (as with DefaultStyle or AlternatingRows). |
| ColumnChanged | Occurs when a change is made to a column or range of columns that may require the column or range of columns be repainted. |
| Disposing | Fires when the SheetView is being disposed. |
| NoteCreated | Occurs when a note of viewport area is created on the sheet. |
| NoteMoved | Occurs when a note of viewport area is moved on the sheet. |
| NoteSized | Occurs when a note of viewport area is sized on the sheet. |
| PropertyChanged | Occurs when the user changes a property of the sheet. |
| ReferenceStyleChanged | Occurs when the reference style changes. |
| RowChanged | Occurs when a change is made to a row or range of rows on this sheet that may require the row or range of rows be repainted. |
| StickyNoteCreated | Obsolete. Use NoteCreated instead. Occurs when a sticky note is created on the sheet. |
| StickyNoteMoved | Obsolete. Use NoteMoved instead. Occurs when a sticky note is moved on the sheet. |
| StickyNoteSized | Obsolete. Use NoteSized instead. Occurs when a sticky note is sized on the sheet. |
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