Spread WPF Documentation
Worksheet Class Properties


GrapeCity.Windows.SpreadSheet.Data Namespace : Worksheet Class

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

Public Properties
 NameDescription
Public PropertyGets the active cell in the sheet.  
Public PropertyGets the active column in the sheet.  
Public PropertyGets or sets the column index of the active cell in the sheet.  
Public PropertyGets the active row in the sheet.  
Public PropertyGets or sets the row index of the active cell in the sheet.  
Public PropertyGets or sets whether to automatically generate the columns for a sheet based on the data source.  
Public Property  
Public PropertyGets the two-dimensional collection of Cell objects.  
Public PropertyGets the charts.  
Public PropertyGets or sets the number of columns in the sheet.  
Public PropertyGets the column header area of the sheet.  
Public PropertyGets the column header span model.  
Public PropertyGets the column range group.  
Public PropertyGets the one-dimensional collection of Column objects.  
Public PropertyGets the conditional format for the sheet.  
Public PropertyGets the name of all custom functions.  
Public PropertyGets all custom names.  
Public PropertyGets or sets whether to automatically generate column names for a sheet based on the data source.  
Public PropertyGets or sets the data source that populates the sheet.  
Public PropertyGets or sets the default column width.  
Public PropertyGets or sets the default row height.  
Public PropertyGets or sets default style information for the workbook.  
Public PropertyGets the floating objects.  
Public PropertyGets or sets the number of nonscrolling columns on the leading edge of this sheet.  
Public PropertyGets or sets the number of nonscrolling rows on the leading edge of this sheet.  
Public PropertyGets or sets the number of nonscrolling columns on the trailing edge of this sheet.  
Public PropertyGets or sets the number of nonscrolling rows on the trailing edge of this sheet.  
Public PropertyGets or sets the gridline color.  
Public PropertyOverloaded. Gets a new cell with a specified tag, or returns null if there is no cell with the specified tag.  
Public PropertyGets the last nonempty bound row index on the sheet.  
Public PropertyGets or sets the name of the sheet.  
Public PropertyGets or sets a collection of StyleInfo objects for this sheet.  
Public PropertyGets the number of rows in cell blocks that contain data, styles, tags, or sparklines.  
Public PropertyGets the pictures.  
Public PropertyGets or sets the print information for printing to PDF.  
Public PropertyGets or sets whether cells on this sheet that are marked as protected are uneditable.  
Public PropertyGets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertyGets or sets the number of rows in the sheet.  
Public PropertyGets or sets the row filter for the sheet.  
Public PropertyGets the row header area of the sheet.  
Public PropertyGets the row header span model.  
Public PropertyGets the row range group.  
Public PropertyGets the one-dimensional collection of Row objects.  
Public PropertyGets or sets a Brush object for the selection style.  
Public PropertyGets or sets a Color object for the selection style.  
Public PropertyGets or sets a string object for the selection style.  
Public PropertyGets or sets whether users can select ranges of items.  
Public PropertyReturns a collection of selected cell ranges.  
Public PropertyGets or sets whether users can select cells, rows, or columns.  
Public PropertyA color object used to represent the sheet tab color.  
Public PropertyA theme color used to represent the sheet tab color.  
Public PropertyDetermines whether to show gridlines.  
Public PropertyGets the sheet span model.  
Public PropertyGets or sets the number or letter displayed in the first column header in this sheet.  
Public PropertyGets or sets the number or letter displayed in the first row header in this sheet.  
Public PropertyGets the surface charts.  
Public PropertyGets or sets the tag.  
Public PropertyGets or sets a Color object for the selection style.  
Public PropertyGets or sets a string object for the selection style.  
Public PropertyGets or sets a value that indicates whether to display the sheet.  
Public PropertyGets the parent workbook for this sheet.  
Public PropertyGets or sets the scaling factor for displaying this sheet.  
Top
See Also

Reference

Worksheet Class
GrapeCity.Windows.SpreadSheet.Data Namespace