Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class
Properties Methods


In This Topic
    Worksheet Class Members
    In This Topic

    The following tables list the members exposed by Worksheet.

    Public Properties
     NameDescription
    Public PropertyGets an IRange object that represents the active cell.  
    Public PropertyGets the filter of this Worksheet.  
    Public PropertyGets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.  
    Public PropertyGets the background image of this worksheet.  
    Public PropertyGets or sets the behaviors of operations.  
    Public PropertyGets an IRange instance which represents the entire worksheet cells.  
    Public PropertyGets an IRange object that that represents the range containing the first circular reference on the sheet.  
    Public PropertyOverridden. Gets or sets the number of columns in this Worksheet.  
    Public PropertyGets the column footer of a worksheet.  
    Public PropertyGets the column header of a worksheet.  
    Public PropertyGet an IRange object that represents all the columns on the worksheet.  
    Public Property  
    Public PropertyGets an ICommentsThreaded collection that represents all the top-level/root comments (no replies) for the specified worksheet. Includes legacy and modern comments.  
    Public PropertyGets or sets the data source of this worksheet.  
    Public PropertyGets the GrapeCity.SpreadsheetValidations object which manages all data validations in this Worksheet.  
    Public PropertyGets the GrapeCity.Spreadsheet.Drawing.WorksheetDrawing object contains all drawing objects within the worksheet.  
    Public PropertyGets or sets a value indicating whether calculation engine automatically recalculates the worksheet when necessary. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public PropertyGets or sets what can be selected on the sheet.  
    Public PropertyGets the conditional formatting manager.  
    Public PropertyGets the number of non-scrolling rows on the trailing edge of this sheet.  
    Public PropertyGets the index number of the worksheet within the collection of worksheets.  
    Public PropertyGets the layout manager of this worksheet.  
    Public PropertyGets the protected data of this worksheet.  
    Public PropertyOverridden. Gets or sets the name of worksheet.  
    Public PropertyGets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).  
    Public PropertyGets a Worksheet that represents the next sheet.  
    Public PropertyGets the WorksheetOptions object that represents all options of the IWorksheet.  
    Public PropertyGets the owner worksheet.  
    Public PropertyGets the page setup of the worksheet.  
    Public PropertyGets a Worksheet that represents the previous sheet.  
    Public PropertyGets an IProtection object that represents the protection options of the worksheet.  
    Public PropertyGets a ProtectionMode value indicating whether this worksheet is protected.  
    Public PropertyOverridden. Gets or sets the number of rows in this Worksheet.  
    Public PropertyGets the row header of a worksheet.  
    Public PropertyGet an IRange object that represents all the rows on the worksheet.  
    Public PropertyGets the current selected cell(s).  
    Public PropertyGets the sort object.  
    Public PropertyGets the sparkline storage of this worksheet.  
    Public PropertyGets the worksheet sub-type.  
    Public PropertyGets or sets the color of the tab.  
    Public PropertyGets the Tables object which manages all tables in this Worksheet.  
    Public PropertyGets or sets the object that contains data about the worksheet.  
    Public PropertyGets the worksheet view of this Worksheet object.  
    Public PropertyGets or sets a SheetVisibility value that determines whether the worksheet is visible.  
    Public PropertyGets the Workbook object contains current Worksheet object.  
    Public PropertyGets the WorkbookSet object contains current Worksheet object.  
    Top
    Public Methods
     NameDescription
    Public MethodMakes the current sheet the active sheet.  
    Public MethodOverloaded. Get the aggregate value of the specified cell range.  
    Public MethodAllow other products use modifier to modify the extended data of style in worksheet's range.  
    Public MethodAllow other products use modifier to modify the extended data of style in worksheet's range.  
    Public MethodOverloaded. Calculates this worksheet.  
    Public MethodRemoves all the data and formulas from the specified range of cells.  
    Public MethodRemoves all shapes from the specified range of cells.  
    Public MethodGets a bool indicate if the reference contains ArrayFormulaExpression.  
    Public MethodGet a value indicate current worksheet contain at least one note is being hidden.  
    Public MethodOverloaded. Determines whether the specified range contains at least one locked cell.  
    Public MethodCopies the data from a range of cells to a specified range of cells.  
    Public MethodCreates the automatic filter.  
    Public MethodCreates the expression view which binds the specified formula to a cell range.  
    Public MethodDeletes this Worksheet from its owner Workbook.  
    Public MethodGenereates a new worksheet name from the naem of this worksheet.  
    Public MethodEnsure that all data in specify range is calculated (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodEvaluates the specified expression again a context cell.  
    Public MethodFinds the suitable range to backup that the original worksheet can be restored correctly later (used by Clipboard Cut for example)  
    Public MethodRefines the selection which is used to execute an UI command.  
    Public MethodGet Comment Storage  
    Public MethodGets the dynamic array cell range.  
    Public MethodGets the formula, as an expression value, for the cell of the specified row and column of this sheet. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodGets the formula, as an expression value, for the cell of the specified row and column of this sheet.  
    Public MethodGets the formatted value from the specified cell on this sheet.  
    Public MethodGets the formula for the cell of the specified row and column of this sheet.  
    Public MethodReturns a hash code for this instance. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodOverloaded. Gets the hyperlink of the specified cell.  
    Public MethodGets the minimum cell range which contains all non-empty data of the worksheet.  
    Public MethodOverloaded. Gets the number format from the specified cell on this sheet.  
    Public MethodGets the preferred print area.  
    Public MethodOverloaded. Gets the richvalue in the table data range  
    Public MethodGets the style format of the specified cell on this worksheet.  
    Public MethodOverloaded. Gets the displayed text of the specified value base on the target cell in this sheet.  
    Public MethodDetermines the how many columns can be extracted from source range data.  
    Public MethodGets raw data from the specified cell on this sheet. The spilled value will be skipped. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodOverloaded. Overridden. Gets the value at the specified location of the 2-dimensions matrix.  
    Public MethodDetermines whether the specified row has headers.  
    Public MethodInserts column(s) to the Worksheet at the specified position.  
    Public MethodInserts row(s) to the Worksheet at the specified position.  
    Public MethodGets a boolean value indicating whether the worksheet is bind to a data source. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodGets a boolean value indicating whether there is a cell comment in this worksheet.  
    Public MethodIndicates whether there is drawing object in this worksheet.  
    Public MethodOverloaded. Gets a boolean value indicating whether the cell contains empty data.  
    Public MethodCheck if there is a hyperlink from the specified range.  
    Public MethodGets a boolean value indicating whether worksheet has sort object.  
    Public MethodGets a value indicating whether there is sparkline in the worksheet.  
    Public MethodGets a value indicating whether the cell is spilled.  
    Public MethodDetermines whether the specified range is valid.  
    Public MethodOverloaded. Moves the data from a range of cells to the specified location.  
    Public MethodGets the nearest next column which contains data in the specified row.  
    Public MethodFind the next non-empty data column in a row.  
    Public MethodFind the next non- empty row data in a column (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodNotifies the data change.  
    Public MethodParses the specified formula to expression.  
    Public MethodGets the nearest previous column which contains data in the specified row.  
    Public MethodFind the previous non-empty data column in a row  
    Public MethodFind the previous non-empty data row in a column (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodProtects a worksheet so that it cannot be modified.  
    Public MethodOverloaded. Get an IRange object that represents a cell or a range of cells.  
    Public MethodRefines the range references to remove whole row / column. All references are assumed as absolute. (Inherited from GrapeCity.Spreadsheet.WorksheetBase)
    Public MethodRemoves one or more columns starting with the column at the specified position.  
    Public MethodRemoves one or more rows starting with the row at the specified position.  
    Public MethodRetarget all StructuredReferenceExpression in range  
    Public MethodOverloaded. Saves this IWorksheet to the specified System.IO.Stream.  
    Public MethodSelects the sheet.  
    Public MethodGet the cell range around the specified cell which contains data.  
    Public MethodSets the automatic size to a specific row.  
    Public MethodOverloaded. Sets the background graphic for a worksheet.  
    Public MethodSets the number of columns in this Worksheet.  
    Public MethodSets the GrapeCity.CalcEngine.Expression value for the cell of the specified cell range.  
    Public MethodSets the formula text for the cell of the specified cell range.  
    Public MethodSets the formula text for the cell of the specified cell range.  
    Public MethodSets the number of rows in this Worksheet.  
    Public MethodOverloaded. Sets the style format for a specific cell on this worksheet.  
    Public MethodOverloaded. Sets an object array into a specified range of cells.  
    Public MethodSwaps the specified ranges of cells.  
    Public MethodReturns a string that represents the current object.  
    Public MethodParses the specified formula to expression.  
    Public MethodUnprotects the worksheet which is protected by password.  
    Public MethodMarks that the hyperlink is visited.  
    Top
    Protected Methods
     NameDescription
    Protected MethodAdd empty chart object to current worksheet.  
    Protected MethodAfter worksheet visible changed.  
    Protected MethodChange Visibility of worksheet.  
    Protected Method  
    Protected MethodOverridden. Get the 3D-Reference index of this GrapeCity.CalcEngine.IReferenceSource object.  
    Protected Method  
    Protected Method  
    Protected MethodPastes the contents of the Clipboard onto the sheet.  
    Protected MethodSupport some extra logic for process auto row height.  
    Top
    See Also