Spread Windows Forms 11.0 Product Documentation
SheetView Class Properties


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

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

Public Properties
 NameDescription
Public PropertyGets a Cell object for the active cell on the sheet.  
Public PropertyGets a Column object for the active column on the sheet.  
Public PropertyGets or sets the column index of the active cell on the sheet.  
Public PropertyGets a Row object for the active row on the sheet.  
Public PropertyGets or sets the row index of the active cell on the sheet.  
Public PropertyGets or sets the skin for the sheet.  
Public PropertyGets or sets whether to allow the user to group rows on the sheet.  
Public PropertyGets or sets whether notes on this sheet are editable.  
Public PropertyGets or sets whether the sheet corner can have a grid structure (table).  
Public PropertyGets an AlternatingRows object for the alternating rows in the data area of the sheet.  
Public PropertyGets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet.  
Public PropertyGets or sets whether the filter will automatically update for any changes.  
Public PropertyGets or sets the AutoFilterMode.  
Public PropertyGets or sets whether to automatically generate the columns for a sheet based on the data source.  
Public PropertyGets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator.  
Public PropertyGets or sets whether to use the Spread's enhanced filter menu.  
Public PropertyGets or sets whether to use the Spread's sorting behavior in enhanced filter context menu.  
Public PropertyGets or sets a value that indicates whether frozen rows are sorted.  
Public PropertyGets or sets a value that indicates whether trailing frozen rows are sorted.  
Public PropertyGets 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.  
Public PropertyGets or sets sheetview background image.  
Public PropertyGets or sets sheetview background image layout.  
Public PropertyGets a Cells object for the cells in the data area of the sheet.  
Public PropertyGets the charts.  
Public PropertyGets the number of child relations (data relation count) for a sheet.  
Public PropertyGets the index of the last column that was automatically sorted for the sheet.  
Public PropertyGets or sets the number of columns in the sheet.  
Public PropertyGets the ColumnFooter object for the column footer area of the sheet.  
Public PropertyGets or sets the horizontal grid line in the column footer for the sheet.  
Public PropertyGets or sets the number of rows in the column footers for the sheet.  
Public PropertyGets or sets the horizontal grid line for the column footer sheet corner.  
Public PropertyGets or sets the style information for the sheet corner for the column footer.  
Public PropertyGets or sets the name of the style for the sheet corner of the column footer.  
Public PropertyGets or sets the vertical grid line for the column footer sheet corner.  
Public PropertyGets or sets the vertical grid line in the column footer for the sheet.  
Public PropertyGets or sets whether the column footers for this sheet are visible.  
Public PropertyGets the ColumnHeader object for the column header area of the sheet.  
Public PropertyGets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows.  
Public PropertyGets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.  
Public PropertyGets or sets whether column headers for the sheet display letters or numbers or are blank.  
Public PropertyGets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows.  
Public PropertyGets or sets the horizontal grid line for the sheet.  
Public PropertyGets or sets the number of rows in the column headers for the sheet.  
Public PropertyGets or sets the vertical grid line in the column header for the sheet.  
Public PropertyGets or sets whether the column headers for this sheet are visible.  
Public PropertyGets a Columns object for the columns in the data area of the sheet.  
Public PropertyGets the containing views.  
Public PropertyGets or sets whether to allow the user to add a new row when the sheet is bound.  
Public PropertyGets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
Public PropertyGets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers.  
Public PropertyGets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.  
Public PropertyGets or sets the name of the data member that populates the sheet.  
Public PropertyGets or sets the name of the data source that populates the sheet.  
Public PropertyDefault setting for group footers.  
Public PropertyGets or sets a StyleInfo object for the default style of the sheet.  
Public PropertyGets or sets the name of the default style for the sheet.  
Public PropertyGets or sets whether zero values are displayed in cells.  
Public PropertySets or gets whether cell diagonal line is enable.  
Public PropertyGets or sets whether the enhanced filter shows items in the tree by default or alphabetic order.  
Public PropertyGets or sets whether the rows are expandable.  
Public PropertyGets the FilterBar object of the sheet.  
Public PropertyGets or sets the horizontal grid line for the filter bar header.  
Public PropertyGets or sets the style information for the filter bar header.  
Public PropertyGets or sets the name of the style for the filter bar header.  
Public PropertyGets or sets the vertical grid line for the filter bar.  
Public PropertyGets or sets the horizontal grid line for the filter bar.  
Public PropertyGets or sets the vertical grid line for the filter bar.  
Public PropertyGets Fpspread from sheet view.  
Public PropertyGets or sets the number of non-scrolling columns on the leading edge of this sheet.  
Public PropertyGets or sets the number of non-scrolling rows on the leading edge of this sheet.  
Public PropertyGets or sets the number of non-scrolling columns on the trailing edge of this sheet.  
Public PropertyGets or sets the number of non-scrolling rows on the trailing edge of this sheet.  
Public PropertyGets or sets the color in the area between the sheet and the edge of the control.  
Public PropertyGets or sets the information of the grouping bar for the sheet.  
Public PropertyGets or sets whether the group footer is displayed.  
Public PropertyGets or sets the collection of grouping information objects for the sheet.  
Public PropertyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
Public PropertyGets or sets the maximum number of levels of grouping for the sheet.  
Public PropertyGets or sets the horizontal grid line for this sheet.  
Public PropertyGets whether a block of cells on this sheet is currently selected.  
Public PropertyGets or sets whether circular references are evaluated on this sheet.  
Public PropertyGets or sets the background color of locked cells on this sheet.  
Public PropertyGets or sets the default font for locked items 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 on this sheet.  
Public PropertyGets or sets the maximum number of iterations for calculating circular references on this sheet.  
Public PropertyGets or sets a value that indicates the minimum zoom factor for this sheet.  
Public PropertyGets or sets a SheetView.DocumentModels object that contains all the models for the sheet.  
Public PropertyGets or sets a NamedStyleCollection of NamedStyle objects for this sheet.  
Public PropertyGets a value that is one more than the index of the last column on this sheet containing data.  
Public PropertyGets a value that is one more than the index of the last row on this sheet containing data.  
Public PropertyGets or sets the background color of null items on this sheet.  
Public PropertyGets or sets the default font for null items on this sheet.  
Public PropertyGets or sets the foreground color of null items on this sheet.  
Public PropertyGets or sets the mode that determines mouse, keyboard, and selection behavior for this sheet.  
Public PropertyGets or sets the name of the parent sheet (SheetView object) of this sheet.  
Public PropertyGets the data relation name for this sheet.  
Public PropertyGets the index of the parent row on this sheet.  
Public PropertyGets or sets preview row information for the sheet.  
Public PropertyGets or sets a PrintInfo object that determines printing behavior for the sheet.  
Public PropertyGets or sets whether cells on this sheet that are marked as locked are not editable.  
Public PropertyGets or sets the background color of the outline (range group) region.  
Public PropertyGets or sets the style of the outline (range group) button.  
Public PropertyGets or sets whether the direction of the summary column is to the right of the detail.  
Public PropertyGets or sets whether the direction of the summary row is below the detail.  
Public PropertyGets or sets the style for cell and range references in formulas in cells on this sheet.  
Public PropertyGets 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.  
Public PropertyGets 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.  
Public PropertyGets or sets the number of rows on this sheet.  
Public PropertyGets or sets the row filter for the sheet.  
Public PropertyGets the RowHeader object for the row header area of the sheet.  
Public PropertyGets or sets whether row headers on this sheet display letters or numbers or are blank.  
Public PropertyGets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns.  
Public PropertyGets or sets the number of columns in the row header on this sheet.  
Public PropertyGets or sets the horizontal grid line in the row header on this sheet.  
Public PropertyGets or sets which row header column in the sheet displays the row selector when there are multiple row header columns.  
Public PropertyGets or sets the vertical grid line in the row header on this sheet.  
Public PropertyGets or sets whether the row headers for this sheet are visible.  
Public PropertyGets a Rows object for the rows in the data area of the sheet.  
Public PropertyGets or sets the information of the vertical scrolling tip for the sheet.  
Public PropertyGets or sets the background color of selections on this sheet.  
Public PropertyGets the number of selections on this sheet.  
Public PropertyGets or sets the default font for selected items on this sheet.  
Public PropertyGets or sets the foreground color of selections on this sheet.  
Public PropertyGets the selection policy for the sheet for normal operation mode.  
Public PropertyGets or sets how selections on this sheet are drawn.  
Public PropertyGets or sets the smallest unit users or the application can select on this sheet.  
Public PropertyGets 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.  
Public PropertyGets the sheet corner of the sheet.  
Public PropertyGets or sets the horizontal grid line for the sheet corner.  
Public PropertyGets or sets the style information for the sheet corner.  
Public PropertyGets or sets the name of the style for the sheet corner.  
Public PropertyGets or sets the vertical grid line for the sheet corner.  
Public PropertyGets or sets the name of the sheet.  
Public PropertyGets or sets a value that indicates whether to display a row selector in the editing row header of the selected row for the sheet.  
Public PropertyGets or sets a value that indicates whether to display a row selector in the row header of the selected row for the sheet.  
Public PropertyGets or sets a sparkline container for the sheet for maintaining sparklines.  
Public PropertyGets or sets the number or letter displayed in the first column header on this sheet.  
Public PropertyGets or sets the number or letter displayed in the first row header on this sheet.  
Public PropertyGets or sets an application-defined tag value associated with the cells in this sheet.  
Public PropertySheet title  
Public PropertyGets the object which manages all DataValidtions.  
Public PropertyGets or sets the vertical grid line on this sheet.  
Public PropertyGet or set the view type of a SheetView.  
Public PropertyGets or sets whether to display the sheet.  
Public PropertyGets or sets whether to use visual styles when rendering objects in the sheet.  
Public PropertyGets or sets the scaling factor for displaying this sheet.  
Top
Protected Properties
 NameDescription
Protected Property (Inherited from System.ComponentModel.Component)
Protected PropertyGets or sets a value that indicates whether to ignore applying Spread skin.  
Protected PropertyGets a value that indicates whether SheetView is initialized.  
Top
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