Spread for ASP.NET 12 Product Documentation
SheetView Class Properties


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : SheetView Class

For a list of all members of this type, see SheetView members.

Public Properties
 NameDescription
Public PropertyGets or sets the active chart.  
Public PropertyGets or sets the active column.  
Public PropertyGets or sets the active image.  
Public PropertyGets or sets the active row.  
Public PropertyGets or sets the current active skin.  
Public PropertyGets or sets whether to allow the user to move columns.  
Public PropertyGets or sets whether a user can delete a row in the sheet.  
Public PropertyGets or sets whether a user can group rows.  
Public PropertyGets or sets whether a user can insert a row in the sheet.  
Public PropertyGets or sets whether to allow incremental loads to the client on demand when the user is scrolling.  
Public PropertyGets or sets whether the sheet displays the number of pages and the arrows for navigating to other pages in the sheet.  
Public PropertyGets or sets whether to allow the user to move rows.  
Public PropertyGets or sets whether users can sort rows in the sheet.  
Public PropertyGets or sets whether to allow the sheet corner to be a structure table.  
Public PropertyGets or sets whether to allow the user to enter formulas in a cell in the control.  
Public PropertyGets or sets whether to allow virtual paging to load data when the user is scrolling.  
Public PropertyGets the alternating rows in the specified portion of the sheet.  
Public PropertyGets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.  
Public PropertyGets or sets the AutoFilterMode which indicates which filtering UI is used.  
Public PropertyGets or sets whether to generate the columns automatically based on the data source.  
Public PropertyGets or sets whether a postback to the server automatically occurs when the user interacts with the sheet.  
Public PropertyGets or sets the background color of the sheet.  
Public PropertyGets the cells in the data area of the sheet.  
Public PropertyGets or sets the cell spacing to use in the displayed HTML page.  
Public PropertyGets the charts.  
Public PropertyGets the number of child views in a hierarchical display for this sheet.  
Public PropertyWhen 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.  
Public PropertyGets or sets the column information for the sheet.  
Public PropertyGets or sets the number of columns in the sheet.  
Public PropertyGets the column footers for the sheet.  
Public PropertyGets or sets the data for the column footer.  
Public PropertyGets or sets the column footer height.  
Public PropertyGets or sets the row information for the column footer.  
Public PropertyGets or sets the spanned cells for the column footer.  
Public PropertyGets or sets the cell types and other style settings for cells in the column footer.  
Public PropertyGets or sets whether the column footers are visible.  
Public PropertyGets the column headers for the sheet.  
Public PropertyGets or sets which column header row displays the filtering indicator when there are multiple column header rows.  
Public PropertyGets or sets whether column headers display letters or numbers or are blank.  
Public PropertyGets or sets which column header row displays the automatic text when there are multiple column header rows.  
Public PropertyGets or sets the data for the column header.  
Public PropertyGets or sets the column header height.  
Public PropertyGets or sets the row information for the column header.  
Public PropertyGets or sets the spanned cells for the column header.  
Public PropertyGets or sets the cell types and other style settings for cells in the column header.  
Public PropertyGets or sets whether the column headers are visible.  
Public PropertyGets the columns in the data area of the sheet.  
Public PropertyGets or sets the conditional formatting model.  
Public PropertyGets or sets the context menu style.  
Public PropertyGets or sets the current page.  
Public PropertyGets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
Public PropertyGets or sets the data key for this sheet.  
Public PropertyGets or sets an array of strings that contains the names of the key fields for the data source for this sheet.  
Public PropertyGets or sets the data member for this sheet.  
Public PropertyGets or sets the data for the sheet.  
Public PropertyGets or sets the data source for this sheet.  
Public PropertyGets or sets the unique identifier of the data source for this sheet.  
Public PropertyGets or sets the default column width in pixels for all columns in the sheet.  
Public PropertyGets or sets the default row height in pixels for all rows in the sheet.  
Public PropertyGets or sets the default style information for the cells in this sheet.  
Public PropertyGets or sets the name of the default style for the cells in this sheet.  
Public PropertyGets or sets the name of the method to call in order to delete data.  
Public PropertyGets or sets an XML string that contains the serialization of the data and presentation (column widths, row heights, spans, styles, etc.) for the sheet.  
Public PropertyGets or sets the row with the cell that is being edited.  
Public PropertyThe number of columns in the editing form.  
Public PropertyGets or sets whether to enable the row edit template.  
Public PropertyGets or sets whether the rows are expandable.  
Public PropertyGets or sets FilterBarInfo for filterBar  
Public PropertyGets the active FpSpread from the SheetView.  
Public PropertyGets or sets the number of frozen (non-scrollable) columns for this sheet.  
Public PropertyGets or sets the number of frozen (non-scrollable) rows for this sheet.  
Public PropertyGets or sets which ImageUrl of the cursor is displayed when the mouse is on the gray area of the sheet.  
Public PropertyGets or sets which type of cursor is displayed when the mouse is on the gray area of the sheet.  
Public PropertyGets or sets the color of the grid lines in the sheet.  
Public PropertyGets or sets whether to display grid lines in the sheet.  
Public PropertyGets or sets the grouping bar background color.  
Public PropertyGets or sets the grouping bar height.  
Public PropertyGets or sets the group bar text.  
Public PropertyGets or sets whether the grouping bar is visible.  
Public PropertyGets or sets the collection of group footer information objects.  
Public PropertyGets or sets whether the footer of the grouping bar is visible.  
Public PropertyGets or sets the collection of group information objects.  
Public PropertyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
Public PropertyGets or sets the maximum grouping level.  
Public PropertyGets or sets the background image of the header area that does not contain column header or row header cells.  
Public PropertyGets or sets the color of the header area that does not contain column header or row header cells.  
Public PropertyGets or sets if the hidden rows are ignored when paging.  
Public PropertyGet the image collection  
Public PropertyGets or sets the name of the method to call in order to insert data.  
Public PropertyGets or sets whether the control tracks the current sheet view state.  
Public PropertyGets or sets the name of the data item type in model binding.  
Public PropertyGets or sets whether circular references in the sheet are evaluated.  
Public PropertyGets or sets the type of layout mode.  
Public PropertyGets or sets the number of rows to load initially to the client.  
Public PropertyGets 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.  
Public PropertyGets or sets a period of time (in milliseconds) when spread loads the next set of rows.  
Public PropertyGets 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.  
Public PropertyGets 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.  
Public PropertyGets or sets the number of rows to include in incremental loads on demand.  
Public PropertyGets or sets the background color of locked cells on this sheet.  
Public PropertyGets or sets the foreground color of locked cells on this sheet.  
Public PropertyGets or sets the maximum amount of change below which iterations stop when circular references are evaluated for the sheet.  
Public PropertyGets or sets the formula recalculation iteration count for the sheet.  
Public PropertyGets or sets the style for the message row.  
Public PropertyGets or sets a collection of styles.  
Public PropertyGets a value that is one more than the index of the last column on this sheet that contains data.  
Public PropertyGets a value that is one more than the index of the last row on this sheet that contains data.  
Public PropertyGets or sets the operation mode of the sheet.  
Public PropertyGets or sets whether to show the maximum number of rows on the last page.  
Public PropertyGets or sets the number of rows to display at a time.  
Public PropertyGets the reference to the parent sheet (SheetView object).  
Public PropertyGets the index of the parent row in a hierarchical display.  
Public PropertyGets or sets the index of the preview row column.  
Public PropertyGets or sets the style information for the preview row.  
Public PropertyGets or sets the preview row template.  
Public PropertyGets or sets whether to display the preview row.  
Public PropertyGets or sets a PrintInfo object that determines printing behavior for the sheet.  
Public PropertyGets or sets whether users can edit cells marked as locked.  
Public PropertyGets or sets the cell reference style.  
Public PropertyGets the name of the data relation in a hierarchical display.  
Public PropertyGets or sets whether the FarPoint Spread always displays the editor if the editor is defined for a cell.  
Public PropertyGets or sets the row information for the sheet.  
Public PropertyGets or sets the number of rows in the sheet.  
Public PropertyGets or sets the row edit template.  
Public PropertyGets or sets the row filter for the sheet.  
Public PropertyGets the row headers for the sheet.  
Public PropertyGets or sets whether row headers display letters or numbers or are blank.  
Public PropertyGets or sets which row header column displays the automatic text when there are multiple row header columns.  
Public PropertyGets or sets the column information for the row header.  
Public PropertyGets or sets the data for the row header.  
Public PropertyGets or sets the spanned cells for the row header.  
Public PropertyGets or sets the cell types and other style settings for cells in the row header.  
Public PropertyGets or sets whether the row headers are visible.  
Public PropertyGets or sets the row header column width.  
Public PropertyGets the rows in the data area of the sheet.  
Public PropertyGets or sets the scrolling content tip columns.  
Public PropertyGets or sets the hidden delay of the scrolling content tip in milliseconds.  
Public PropertyGets or sets the maximum height in pixels for the scrolling content tip.  
Public PropertyGets or sets a value that indicates whether to display the scrolling content tip.  
Public PropertyGets or sets the background color for selected cells.  
Public PropertyGets or sets the backcolor style for the display of selected cells.  
Public PropertyGets or sets the settings for the selection border.  
Public PropertyGets or sets the text color for selected cells.  
Public PropertyGets or sets the selections for the sheet.  
Public PropertyGets or sets the selection policy.  
Public PropertyGets or sets the name of the method to call in order to read data.  
Public PropertyGets the sheet corner for the sheet.  
Public PropertyGets or sets the column information for the sheet corner.  
Public PropertyGets or sets the data for the sheet corner.  
Public PropertyGets or sets the row information for the sheet corner.  
Public PropertyGets or sets the spanned cells for the sheet corner.  
Public PropertyGets or sets the style information for the sheet corner.  
Public PropertyGets or sets the cell types and other style settings for cells in the sheet corner.  
Public PropertyGets or sets the name of the style for the sheet corner.  
Public PropertyGets or sets the name of the sheet.  
Public PropertyGets or sets whether the frozen indicator should be displayed.  
Public PropertyGets the model index of the column last sorted.  
Public PropertyGets or sets the spanned cells for the sheet.  
Public PropertyGets or sets the sparkline container.  
Public PropertyGets or sets the number displayed in the first column header.  
Public PropertyGets or sets the number displayed in the first row header.  
Public PropertyGets or sets the number of the first page to display in the page navigation aids.  
Public PropertyGets or sets the cell types and other style settings for the sheet.  
Public PropertyGets the title information of the sheet.  
Public PropertyGets or sets the row to display as the top row in the sheet.  
Public PropertyGets or sets the name of the method to call in order to update data.  
Public PropertyGets 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.  
Public PropertyIndicates 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.  
Public PropertyGets or sets whether to display the sheet.  
Public PropertyGets the worksheet template.  
Top
See Also

Reference

SheetView Class
FarPoint.Web.Spread Namespace