Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IWorksheet Interface

IWorksheet Interface Properties

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

Public Properties
 NameDescription
 PropertyGets an IRange object that represents the active cell.  
 PropertyGets an IAutoFilter object if filtering is on.  
 PropertyGets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
 PropertyGets or sets the behaviors of operations.  
 PropertyGets an IRange object which represents the entire worksheet cells (not just the cells that are currently in use).  
 PropertyGets an IRange object that represents the range containing the first circular reference on the worksheet, or returns null if there's no circular reference on the worksheet.  
 PropertyGets or sets the number of columns in this IWorksheet.  
 PropertyGets the column footer of a worksheet.  
 PropertyGets the column header of a worksheet.  
 PropertyGet an IRange object that represents all the columns on the worksheet.  
 PropertyGets an IComments collection that represents all the comments for the specified worksheet.  
 PropertyGets an ICommentsThreaded collection that represents all the top-level/root comments (no replies) for the specified worksheet. Includes legacy and modern comments.  
 PropertyGets the data manager of this worksheet.  
 PropertyGets an IHyperlinks collection that represents the hyperlinks for the worksheet.  
 PropertyGets the index number of the worksheet within the collection of worksheets.  
 PropertyGets or sets the name of worksheet.  
 PropertyGets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
 PropertyGets an IWorksheet object that represents the next sheet.  
 PropertyGets the WorksheetOptions object that represents all options of the IWorksheet.  
 PropertyGets an IOutline object that represents the outline for the specified worksheet.  
 PropertyGets the owner worksheet.  
 PropertyGets a collection of all the GrapeCity.Spreadsheet.Drawing.IPicture objects on this IWorksheet.  
 PropertyGets an IWorksheet object that represents the previous sheet.  
 PropertyGets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the Protect method.  
 PropertyGets or sets the number of rows in this IWorksheet.  
 PropertyGets the row header of a worksheet.  
 PropertyGet an IRange object that represents all the rows on the worksheet.  
 PropertyGets the current selected cell(s).  
 PropertyGets a collection of all the GrapeCity.Spreadsheet.Drawing.IShape objects on this IWorksheet.  
 PropertyGets the GrapeCity.Spreadsheet.Slicers.ISlicers collection that contains the collection of GrapeCity.Spreadsheet.Slicers.ISlicer objects in the specified IWorksheet.  
 PropertyGets the sort object.  
 PropertyGets or sets the standard (default) height of all the rows on the worksheet.  
 PropertyGets or sets the standard (default) width of all the columns on the worksheet.  
 PropertyGets a IWorksheetStyles collection that represents all the styles in the worksheet.  
 PropertyGets the worksheet sub-type.  
 PropertyGets or sets the color of the tab.  
 PropertyGets the ITables object which manages all tables in this IWorksheet.  
 PropertyGets the worksheet type.  
 PropertyGets an IRange object that represents the used range on the specified worksheet.  
 PropertyGets the worksheet view of this Worksheet object.  
 PropertyGets or sets a SheetVisibility value that determines whether the worksheet is visible.  
 PropertyGets the Workbook object contains current Worksheet object.  
Top
See Also