The following tables list the members exposed by SheetView.
Public Constructors
| Name | Description | |
|---|---|---|
 | SheetView Constructor | Overloaded. |
Protected Fields
| Name | Description | |
|---|---|---|
 | childViews | Specifies a list of child views in a hierarchical display for this sheet. |
| parentView | Specifies the parent view for this sheet. |
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveChart | Gets or sets the active chart. |
| ActiveColumn | Gets or sets the active column. |
| ActiveRow | Gets or sets the active row. |
| ActiveSkin | Gets or sets the current active skin. |
| AllowColumnMove | Gets or sets whether to allow the user to move columns. |
| AllowDelete | Gets or sets whether a user can delete a row in the sheet. |
| AllowGroup | Gets or sets whether a user can group rows. |
| AllowInsert | Gets or sets whether a user can insert a row in the sheet. |
| AllowLoadOnDemand | Gets or sets whether to allow incremental loads to the client on demand when the user is scrolling. |
| AllowPage | Gets or sets whether the sheet displays the number of pages and the arrows for navigating to other pages in the sheet. |
| AllowSort | Gets or sets whether users can sort rows in the sheet. |
| AllowTableCorner | Gets or sets whether to allow the sheet corner to be a structure table. |
| AllowUserFormulas | Gets or sets whether to allow the user to enter formulas in a cell in the control. |
| AllowVirtualScrollPaging | Gets or sets whether to allow virtual paging to load data when the user is scrolling. |
| AlternatingRows | Gets the alternating rows in the specified portion of the sheet. |
| AutoCalculation | Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change. |
| AutoGenerateColumns | Gets or sets whether to generate the columns automatically based on the data source. |
| AutoPostBack | Gets or sets whether a postback to the server automatically occurs when the user interacts with the sheet. |
| BackColor | Gets or sets the background color of the sheet. |
| Cells | Gets the cells in the data area of the sheet. |
| CellSpacing | Gets or sets the cell spacing to use in the displayed HTML page. |
| Charts | Gets the charts. |
| ChildRelationCount | Gets the number of child views in a hierarchical display for this sheet. |
| ClickHeaderCellToExpand | When this property is true and client script is enabled, the spread will expand the row in a hierarchical view when the row header cell is clicked. Otherwise, the spread will expand the row only when the expand image is clicked. |
| ColumnAxisModel | Gets or sets the column information for the sheet. |
| ColumnCount | Gets or sets the number of columns in the sheet. |
| ColumnFooter | Gets the column footers for the sheet. |
| ColumnFooterDataModel | Gets or sets the data for the column footer. |
| ColumnFooterHeight | Gets or sets the column footer height. |
| ColumnFooterRowAxisModel | Gets or sets the row information for the column footer. |
| ColumnFooterSpanModel | Gets or sets the spanned cells for the column footer. |
| ColumnFooterStyleModel | Gets or sets the cell types and other style settings for cells in the column footer. |
| ColumnFooterVisible | Gets or sets whether the column footers are visible. |
| ColumnHeader | Gets the column headers for the sheet. |
| ColumnHeaderAutoFilterIndex | Gets or sets which column header row displays the filtering indicator when there are multiple column header rows. |
| ColumnHeaderAutoText | Gets or sets whether column headers display letters or numbers or is blank. |
| ColumnHeaderAutoTextIndex | Gets or sets which column header row displays the automatic text when there are multiple column header rows. |
| ColumnHeaderDataModel | Gets or sets the data for the column header. |
| ColumnHeaderHeight | Gets or sets the column header height. |
| ColumnHeaderRowAxisModel | Gets or sets the row information for the column header. |
| ColumnHeaderSpanModel | Gets or sets the spanned cells for the column header. |
| ColumnHeaderStyleModel | Gets or sets the cell types and other style settings for cells in the column header. |
| ColumnHeaderVisible | Gets or sets whether the column headers are visible. |
| Columns | Gets the columns in the data area of the sheet. |
| CurrentPageIndex | Gets or sets the current page. |
| DataAutoCellTypes | Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column. |
| DataKeyField | Gets or sets the data key for this sheet. |
| DataKeyNames | Gets or sets an array of strings that contains the names of the key fields for the data source for this sheet. |
| DataMember | Gets or sets the data member for this sheet. |
| DataModel | Gets or sets the data for the sheet. |
| DataSource | Gets or sets the data source for this sheet. |
| DataSourceID | Gets or sets the unique identifier of the data source for this sheet. |
| DefaultColumnWidth | Gets or sets the default column width in pixels for all columns in the sheet. |
| DefaultRowHeight | Gets or sets the default row height in pixels for all rows in the sheet. |
| DefaultStyle | Gets or sets the default style information for the cells in this sheet. |
| DefaultStyleName | Gets or sets the name of the default style for the cells in this sheet. |
| EditRow | Gets or sets the row with the cell that is being edited. |
| EditTemplateColumnCount | The number of columns in the editing form. |
| EnableRowEditTemplate | Gets or sets whether to enable the row edit template. |
| Expandable | Gets or sets whether the rows are expandable. |
| FpSpread | Gets Actived FpSpread from SheetView. |
| FrozenColumnCount | Gets or sets the number of frozen (non-scrollable) columns for this sheet. |
| FrozenRowCount | Gets or sets the number of frozen (non-scrollable) rows for this sheet. |
| GrayAreaCursorImageUrl | Gets or sets which ImageUrl of cursor is diplayed when the mouse is on the gray area of the sheet. |
| GrayAreaCursorType | Gets or sets which type of cursor is diplayed when the mouse is on the gray area of the sheet. |
| GridLineColor | Gets or sets the color of the grid lines in the sheet. |
| GridLines | Gets or sets whether to display grid lines in the sheet. |
| GroupBarBackColor | Gets or sets the grouping bar background color. |
| GroupBarHeight | Gets or sets the grouping bar height. |
| GroupBarText | Gets or sets the group bar text. |
| GroupBarVisible | Gets or sets whether the grouping bar is visible. |
| GroupFooterInfos | Gets or sets the collection of group footer information objects. |
| GroupFooterVisible | Gets or sets whether the footer of the grouping bar is visible. |
| GroupInfos | Gets or sets the collection of group information objects. |
| GroupingPolicy | Gets or sets grouping policy to collapse or expand rows when grouping occurs. |
| GroupMaximumLevel | Gets or sets the maximum grouping level. |
| HeaderGrayAreaBackgroundImageUrl | Gets or sets the background image of the header area that does not contain column header or row header cells. |
| HeaderGrayAreaColor | Gets or sets the color of the header area that does not contain column header or row header cells. |
| IgnoreHiddenRowsWhenPaging | Gets/Sets if the hidden rows will be ignored when paging. |
| IsTrackingViewState | Gets or sets whether the control tracks the current sheet view state. |
| Iteration | Gets or sets whether circular references in the sheet are evaluated. |
| LayoutMode | Gets or sets the type of layout mode. |
| LoadInitRowCount | Gets or sets the number of rows to load initially to the client. |
| LoadRowIncrement | Gets or sets the number of rows to include in incremental loads on demand. |
| LockBackColor | Gets or sets the background color of locked cells 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 for the sheet. |
| MaximumIterations | Gets or sets the formula recalculation iteration count for the sheet. |
| MessageRowStyle | Gets or sets the style for the message row. |
| NamedStyles | Gets or sets a collection of styles. |
| 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. |
| OperationMode | Gets or sets the operation mode of the sheet. |
| PageMaxAlign | Gets or sets whether to show the maximum number of rows on the last page. |
| PageSize | Gets or sets the number of rows to display at a time. |
| Parent | Gets the reference to the parent sheet (SheetView object). |
| ParentRowIndex | Gets the index of the parent row in a hierarchical display. |
| PreviewRowColumnIndex | Gets or sets the index of the preview row column. |
| PreviewRowStyle | Gets or sets the style information for the preview row. |
| PreviewRowTemplate | Gets or sets the preview row template. |
| PreviewRowVisible | Gets or sets whether to display the preview row. |
| PrintInfo | Gets or sets a PrintInfo object that determines printing behavior for the sheet. |
| Protect | Gets or sets whether users can edit cells marked as locked. |
| ReferenceStyle | Gets or sets the cell reference style. |
| RelationName | Gets the name of the data relation in a hierarchical display. |
| RenderEditors | Gets or sets whether the FarPoint Spread always displays the editor if the editor is defined for a cell. |
| RowAxisModel | Gets or sets the row information for the sheet. |
| RowCount | Gets or sets the number of rows in the sheet. |
| RowEditTemplate | Gets or sets the row edit template. |
| RowFilter | Gets or sets the row filter for the sheet. |
| RowHeader | Gets the row headers for the sheet. |
| RowHeaderAutoText | Gets or sets whether row headers display letters or numbers or is blank. |
| RowHeaderAutoTextIndex | Gets or sets which row header column displays the automatic text when there are multiple row header columns. |
| RowHeaderColumnAxisModel | Gets or sets the column information for the row header. |
| RowHeaderDataModel | Gets or sets the data for the row header. |
| RowHeaderSpanModel | Gets or sets the spanned cells for the row header. |
| RowHeaderStyleModel | Gets or sets the cell types and other style settings for cells in the row header. |
| RowHeaderVisible | Gets or sets whether the row headers are visible. |
| RowHeaderWidth | Gets or sets the row header column width. |
| Rows | Gets the rows in the data area of the sheet. |
| RowTemplate | Gets the row template of the sheet. |
| ScrollingContentColumns | Gets or sets the scrolling content tip columns. |
| ScrollingContentHiddenDelay | Gets or sets the hidden delay of the scrolling content tip in milliseconds. |
| ScrollingContentMaxHeight | Gets or sets the maximum height in pixels for the scrolling content tip. |
| ScrollingContentVisible | Gets or sets a value indicating whether to display the scrolling content tip. |
| SelectionBackColor | Gets or sets the background color for selected cells. |
| SelectionBackColorStyle | Gets or sets back color style for the display of selected cells. |
| SelectionBorder | Gets or sets the settings for the selection border. |
| SelectionForeColor | Gets or sets the text color for selected cells. |
| SelectionModel | Gets or sets the selections for the sheet. |
| SelectionPolicy | Gets or sets the selection policy. |
| SheetCorner | Gets the sheet corner for the sheet. |
| SheetCornerColumnAxisModel | Gets or sets the column information for the sheet corner. |
| SheetCornerDataModel | Gets or sets the data for the sheet corner. |
| SheetCornerRowAxisModel | Gets or sets the row information for the sheet corner. |
| SheetCornerSpanModel | Gets or sets the spanned cells for the sheet corner. |
| SheetCornerStyle | Gets or sets the style information for the sheet corner. |
| SheetCornerStyleModel | Gets or sets the cell types and other style settings for cells in the sheet corner. |
| SheetCornerStyleName | Gets or sets the name of the style for the sheet corner. |
| SheetName | Gets or sets the name of the sheet. |
| ShowFrozenIndicator | Gets or sets whether the frozen indicator should be displayed. |
| SortedColumn | Gets the index of the column last sorted. |
| SpanModel | Gets or sets the spanned cells for the sheet. |
| SparklineContainer | Gets or sets the sparkline container. |
| StartingColumnNumber | Gets or sets the number displayed in the first column header. |
| StartingRowNumber | Gets or sets the number displayed in the first row header. |
| StartPage | Gets or sets the number of the first page to display in the page navigation aids. |
| StyleModel | Gets or sets the cell types and other style settings for the sheet. |
| TitleInfo | Gets the title information of the sheet. |
| TopRow | Gets or sets the row to display as the top row in the sheet. |
| Visible | Gets or sets whether to display the sheet. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddChart | Overloaded. Adds the chart control. |
| AddColumns | Adds columns to the data model at the specified index. |
| AddRows | Adds rows to the data model. |
| AddRowToDataSource | Adds the unbound row to the data source. |
| AddSpanCell | Adds a span of cells to a sheet. |
| AddSparkline | Overloaded. Adds the sparkline. |
| AddSquareSparkline | Adds the sparkline. |
| AddUnboundRows | Adds unbound rows to the data model. |
| 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. |
| ClearConditionalFormats | Removes all of the conditional formats from the cell at the specified row and column. |
| ClearRange | Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet. |
| ClearRowFilter | Clears the row filter for this sheet. |
| ClearSparklineGroupsInRange | Clear all sparkline groups |
| ClearSparklines | Clears all sparklines |
| ExpandRow | Expands or collapses the specified row in the hierarchical display. |
| FindChildView | Gets the child view in a hierarchical display with the specified row and data relation index. |
| GetCellFromTag | Gets a cell with a specific tag on the sheet. |
| GetCellRangeSpanCombined | Gets the cell range span combined. |
| GetCellType | Gets the cell type for a cell at the specified row and column. |
| GetChildRelation | Gets the name of the child data relation in a hierarchical display at the specified index. |
| GetChildView | Gets a child sheet in a hierarchical display for the specified row and the specified relation index. |
| GetChildVisible | Gets whether the child view is displayed in a hierarchical display. |
| GetClip | Overloaded. Gets a tab-delimited string containing the formatted text in a specified range. |
| GetClipValue | Gets a tab-delimited string containing the unformatted text in a specified range. |
| GetColumnAllowFilter | Gets whether this column contains a column filter definition. |
| GetColumnAutoText | Gets the automatic text displayed in the specified column header. |
| GetColumnFromTag | Gets a column on this sheet with a specific tag. |
| GetColumnLabel | Gets the text in the column header cell at the specified row and column. |
| GetColumnMerge | Gets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows. |
| GetColumnSizeable | Gets whether the user can resize a specified column. |
| GetColumnSortIndicator | Gets the sort indicator to display at the specified column. |
| GetColumnVisible | Gets whether a column is displayed. |
| GetColumnWidth | Gets the width of the specified column in pixels. |
| GetConditionalFormats | Overloaded. Gets the conditional formats for the cell at the specified row and column. |
| GetCustomName | Overloaded. Gets the string value for a custom name on this sheet from the model. |
| GetDataKey | Gets the identifier for the specified row if it is visible. |
| GetDefaultEditor | Gets the default editor used to edit the cell. |
| GetDefaultRenderer | Gets the default renderer used to render the cell. |
| GetDropDownFilterItems | Gets the filter items to be displayed in the drop-down list for the specified column. |
| GetEditor | Gets the editor used to edit a cell at the specified row and column. |
| GetExpression | Gets the formula of the specified cell on this sheet. |
| GetFormatter | Gets the formatter used to format a cell at the specified row and column. |
| GetFormula | Gets the formula in the cell at the specified row and column. |
| GetGroupFooterInfo | Gets the group Footer information for the sheet. |
| GetGroupInfo | Gets the group information for the sheet. |
| GetModelColumnFromViewColumn | Gets the index in the model for the specified column. |
| GetModelRowFromViewRow | Gets a row index in a model for a specified row in a sheet. |
| GetNote | Gets the cell note for a cell at the specified row and column. |
| GetRenderer | Gets the renderer used to render a cell at the specified row and column. |
| GetRowAutoText | Gets the automatic text displayed in the specified row header. |
| GetRowExpandable | Gets whether the row on this sheet is expandable in the hierarchical display. |
| GetRowFromTag | Gets a row on this sheet with a specific tag. |
| GetRowHeight | Gets the height of the specified row. |
| GetRowLabel | Gets the text in the specified row header cell. |
| 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. |
| GetRowSizeable | Gets whether the user can resize the specified row. |
| GetRowVisible | Gets whether a row is displayed. |
| GetSelections | Gets an ordered array of FarPoint.Web.Spread.Model.CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges. |
| GetSpanCell | Gets the span of cells at a specified cell. |
| GetSparkline | Gets the sparkline info. |
| GetStyleInfo | Gets the composite cell style information for a cell at the specified row and column. |
| GetTag | Gets the application-defined tag value for the specified cell, column, row, or entire sheet. |
| GetText | Gets the formatted text in the cell using the IFormatter object for the cell. |
| GetUnboundValue | Gets the unbound value for a cell at the specified row and column. |
| GetValue | Gets unformatted data from a cell at the specified row and column. |
| GetViewColumnFromModelColumn | Gets the sheet column index for a specified model column. |
| GetViewRowFromModelRow | Gets a sheet row index for the specified model row. |
| GroupSparkline | Overloaded. Groups the sparkline and sets the type of new group. |
| IsColumnBound | Gets whether the column is bound to a data source column. |
| IsRowBound | Gets whether the specified row is bound to a data source. |
| IsRowExpanded | Gets whether the row is expanded in the hierarchical display. |
| LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. |
| LoadTextFile | Overloaded. Loads a text file with the specified name into the sheet. |
| LoadViewState | Loads a saved view state for a sheet. |
| MoveColumn | Moves the column or columns to a specified location. |
| Open | Overloaded. Opens a sheet saved as XML from the specified file and loads it into the sheet. |
| OpenExcel | Overloaded. Opens an Excel file and loads the specified Excel sheet into this sheet. |
| Recalculate | Evaluates all the formulas in the sheet that have changed since the last calculation cycle. |
| RecalculateAll | Evaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle). |
| RemoveColumns | Removes the columns at the specified index. |
| RemoveRows | Removes the rows at the specified index. |
| RemoveSpanCell | Removes the span from a range of cells that contain a specified anchor cell. |
| Reset | Sets the sheet to its default values. |
| ResetViewColumnIndexes | Resets all column indexes in the sheet to be the same as the column indexes in the corresponding data model. |
| ResetViewRowIndexes | Resets all row indexes in the sheet to be the same as the row indexes in the corresponding data model. |
| Save | Overloaded. Saves the contents of the sheet to XML in the specified file. |
| SaveTextFile | Overloaded. Saves the sheet to a text file with the specified name. |
| SaveTextFileRange | Overloaded. Saves the range of cells (and may include headers) to a text file as specified. |
| SaveViewState | Saves the current view state of the sheet. |
| SetChildVisible | Sets whether to display the child view in a hierarchical display. |
| SetClip | Sets a tab-delimited string containing the formatted text in a specified range. |
| SetClipValue | Sets a tab-delimited string containing the unformatted text in a specified range. |
| SetColumnLabel | Sets the value for a specified cell in a column header. |
| SetColumnMerge | Sets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows. |
| SetColumnSizeable | Sets whether users can resize individual columns. |
| SetColumnSortIndicator | Sets the sort indicator to display at the specified column. |
| SetColumnVisible | Sets whether a column is displayed. |
| SetColumnWidth | Sets the width of the specified column in pixels. |
| SetConditionalFormat | Overloaded. Sets conditional formatting based on a specified comparison for a specified cell. |
| SetExpression | Sets a formula in a specified cell on this sheet. |
| SetFormula | Sets the formula for a specified cell. |
| SetFormulaConditionalFormat | Overloaded. Sets conditional formatting based on a specified formula for a specified cell. |
| SetModelDataColumn | Binds the model column to the data source column. |
| SetNote | Sets the cell note for a specified cell. |
| SetRowExpandable | Sets whether the row on this sheet can be expanded to show the child view in the hierarchical display. |
| SetRowHeight | Sets the height of the specified row in pixels. |
| SetRowLabel | Sets the value for a specified cell in the row header. |
| 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. |
| SetRowSizeable | Sets whether users can resize individual rows. |
| SetRowVisible | Sets whether a row is displayed. |
| 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 using the IFormatter object for the cell. |
| SetValue | Sets the value for a cell at the specified row and column. |
| Sort | Sorts a range of cells in the data model. |
| SortColumns | Overloaded. Sorts all the columns in the sheet according to the specified parameters. |
| SortRows | Overloaded. Sorts all the rows in the sheet according to the specified parameters. |
| ToString | Returns the name of the sheet. |
| UngroupSparkline | Overloaded. Ungroups the sparkline. |
Protected Methods
| Name | Description | |
|---|---|---|
 | CreateColumnAxisModel | Creates the column axis model. |
| CreateDataModel | Creates the data model. |
| CreateRowAxisModel | Creates the row axis model. |
| CreateSelectionModel | Creates the selection model. |
| CreateSpanModel | Creates the span model. |
| CreateStyleModel | Creates the style model. |
| FlushData | Call GetPagingSupport of DataModel, select data to data source view. |
| GetChildViewName | Gets a name for the child view in a hierarchical display based on the row index and the relation index. |
| OnAddColumnFooterRows | Processes the addition of the specified rows to the column footer in the data model. |
| OnAddColumnHeaderRows | Processes the addition of the specified rows to the column header in the data model. |
| OnAddColumns | Processes the addition of columns to the data model and updates the other models and internal variables of the fpSpread component. |
| OnAddRowHeaderColumns | Processes the addition of columns to the row header of the sheet. |
| OnAddRows | Processes the addition of rows to the data model. |
| OnDataModelChanged | Processes the change to the sheet data model and syncs the models. |
| OnRemoveColumnFooterRows | Processes the removal of rows from the column header. |
| OnRemoveColumnHeaderRows | Processes the removal of rows from the column header. |
| OnRemoveColumns | Processes the removal of the specified columns from the data model. |
| OnRemoveRowHeaderColumns | Processes the removal of columns from the row header. |
| OnRemoveRows | Processes the removal of the specified rows from the data model. |
| ShouldSerializePrintInfo | Determines whether the print information should be serialized. |
See Also
Reference
SheetView ClassFarPoint.Web.Spread Namespace
FpSheetViewCollection class
Sheets Property
SheetViewCollection Class