For a list of all members of this type, see SheetView members.
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveChart | Gets or sets the active chart. |
| ActiveColumn | Gets or sets the active column. |
| ActiveImage | Gets or sets the active image. |
| 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. |
| AutoFilterMode | Gets or sets the AutoFilterMode which indicates which filtering UI is used. |
| 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 are 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. |
| ConditionalFormatting | Gets or sets the conditional formatting model. |
| ContextMenuStyle | Gets or sets the context menu style. |
| 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. |
| DeleteMethod | Gets or sets the name of the method to call in order to delete data. |
| 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. |
| FilterBar | Gets or sets FilterBarInfo for filterBar |
| FpSpread | Gets the active FpSpread from the 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 the cursor is displayed when the mouse is on the gray area of the sheet. |
| GrayAreaCursorType | Gets or sets which type of cursor is displayed 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 or sets if the hidden rows are ignored when paging. |
| Images | Get the image collection |
| InsertMethod | Gets or sets the name of the method to call in order to insert data. |
| IsTrackingViewState | Gets or sets whether the control tracks the current sheet view state. |
| ItemType | Gets or sets the name of the data item type in model binding. |
| 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. |
| LoadOffsetFromBottom | Gets or sets the row index (from bottom to top) in the view from where spread loads the next set of rows after scrolling to this position. |
| LoadOnDemandInterval | Gets or sets a period of time (in milliseconds) when spread loads the next set of rows. |
| LoadOnDemandMode | Gets or sets the LoadOnDemandMode property. In Standard mode, spread loads the next set of rows, if after scrolling, there are no bottom rows (in the view) that are hidden. In Background mode, spread loads the next set of rows after a period of time or after the user scrolls to the row at the LoadOffsetFromBottom position. |
| LoadOnDemandTriggerMode | Gets or sets the LoadOnDemandTriggerMode property. If trigger mode is Timed, spread loads the next set of rows after a period of time until there are no rows to load. If trigger mode is OffsetBased, spread only loads the next set of rows if the user scrolls to the row at the LoadOffsetFromBottom position. |
| 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 that contains data. |
| NonEmptyRowCount | Gets a value that is one more than the index of the last row on this sheet that contains 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 are 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. |
| 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 that indicates whether to display the scrolling content tip. |
| SelectionBackColor | Gets or sets the background color for selected cells. |
| SelectionBackColorStyle | Gets or sets the backcolor 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. |
| SelectMethod | Gets or sets the name of the method to call in order to read data. |
| 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 model 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. |
| UpdateMethod | Gets or sets the name of the method to call in order to update data. |
| VirtualScrollPagingFormatString | Gets or sets the custom format string to show in the text tip during virtual scroll paging. Default pattern is "Page {page} of {count}", where {page} will be replaced for page index and {count} will be replaced for page count. |
| VirtualScrollPagingPrevRowCount | Indicates the number of additional rows that are displayed from previous pages before the top of the current page. The default value is zero. This setting only has an effect when AllowVirtualScrollPaging is true. |
| Visible | Gets or sets whether to display the sheet. |
| WorksheetTemplate | Gets the worksheet template. |
See Also
Reference
SheetView Class
FarPoint.Web.Spread Namespace
FpSheetViewCollection class
Sheets Property
SheetViewCollection Class