| Name | Description | |
|---|---|---|
 | Activate | Makes the current sheet the active sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Aggregate | Overloaded. Get the aggregate value of the specified cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ApplyStyleExtend | Allow other products use modifier to modify the extended data of style in worksheet's range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ApplyStyleFormatter | Allow other products use modifier to modify the extended data of style in worksheet's range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Calculate | Overloaded. Calculates this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Clear | Removes all the data and formulas from the specified range of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ClearShapes | Removes all shapes from the specified range of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ContainsArrayFormula | Gets a bool indicate if the reference contains ArrayFormulaExpression. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ContainsLockedCell | Overloaded. Determines whether the specified range contains at least one locked cell. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Copy | Overloaded. Copies the data from a range of cells to a specified range of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| CreateAutoFilter | Creates the automatic filter. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| CreateExpressionView | Creates the expression view which binds the specified formula to a cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Delete | Deletes this Worksheet from its owner Worksheet.Workbook. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| DuplicateName | Genereates a new worksheet name from the naem of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| EnsureCaculated | Ensure that all data in specify range is calculated (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| Evaluate | Evaluates the specified expression again a context cell. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| FindBackupRange | Finds the suitable range to backup that the original worksheet can be restored correctly later (used by Clipboard Cut for example) (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetDynamicArrayRange | Gets the dynamic array cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetExpression | Gets the formula, as an expression value, for the cell of the specified row and column of this sheet. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| GetExpression2 | Gets the formula, as an expression value, for the cell of the specified row and column of this sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetFormattedValue | Gets the formatted value from the specified cell on this sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetFormula | Gets the formula for the cell of the specified row and column of this sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetHashCode | Returns a hash code for this instance. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| GetHyperlink | Overloaded. Gets the hyperlink of the specified cell. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetNonEmptyArea | Gets the minimum cell range which contains all non-empty data of the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetNumberFormat | Overloaded. Gets the number format from the specified cell on this sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetPreferredPrintArea | Gets the preferred print area. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetRichValue | Overloaded. Gets the richvalue in the table data range (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetStyleFormat | Gets the style format of the specified cell on this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetValue | Overloaded. Gets the value at the specified location of the 2-dimensions matrix. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| InsertColumns | Inserts column(s) to the Worksheet at the specified position. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| InsertRows | Inserts row(s) to the Worksheet at the specified position. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsBindingData | Gets a boolean value indicating whether the worksheet is bind to a data source. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| IsCommentStorageAvailable | Gets a boolean value indicating whether there is a cell comment in this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsContain | Check if the worksheet contains a specify worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsDrawingObjectAvailable | Indicates whether there is drawing object in this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsEmpty | Overloaded. Gets a boolean value indicating whether the cell contains empty data. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsValid | Determines whether the specified range is valid. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Move | Overloaded. Moves the data from a range of cells to the specified location. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| NextNonEmptyCell | Gets the nearest next column which contains data in the specified row. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| NextNonEmptyColumnInRow | Find the next non-empty data column in a row. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| NextNonEmptyRowInColumn | Find the next non- empty row data in a column (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| NotifyDataChanged | Notifies the data change. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ParseFormula | Parses the specified formula to expression. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| PreviousNonEmptyCell | Gets the nearest previous column which contains data in the specified row. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| PreviousNonEmptyColumnInRow | Find the previous non-empty data column in a row (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| PreviousNonEmptyRowInColumn | Find the previous non-empty data row in a column (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| ProcessAutoMergedCells | Finds the auto-merged cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Protect | Protects a worksheet so that it cannot be modified. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Range | Overloaded. Get an IRange object that represents a cell or a range of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| RefineAccessibleRangeReference | Refines the range references to remove whole row / column. All references are assumed as absolute. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| RemoveColumns | Removes one or more columns starting with the column at the specified position. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| RemoveRows | Removes one or more rows starting with the row at the specified position. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| RetargetStructuredReferenceExpressionInRange | Retarget all StructuredReferenceExpression in range (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SelectNeighborNonEmptyCells | Get the cell range around the specified cell which contains data. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetAutoRowHeight | Sets the automatic size to a specific row. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetBackgroundPicture | Overloaded. Sets the background graphic for a worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetColumnCount | Sets the number of columns in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetExpression | Sets the GrapeCity.CalcEngine.Expression value for the cell of the specified cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetFormula | Sets the formula text for the cell of the specified cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetFormulaArray | Sets the formula text for the cell of the specified cell range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetRowCount | Sets the number of rows in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetStyleFormat | Overloaded. Sets the style format for a specific cell on this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SetValue | Overloaded. Sets an object array into a specified range of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Swap | Swaps the specified ranges of cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ToString | Returns a string that represents the current object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| UnparseFormula | Parses the specified formula to expression. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Unprotect | Unprotects the worksheet which is protected by password. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| VisitHyperlink | Marks that the hyperlink is visited. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
SubWorksheet Class Methods
In This Topic
For a list of all members of this type, see SubWorksheet members.
| Name | Description | |
|---|---|---|
 | ExportExtensionData | Enables an object to extend another object through aggregation. |
| Get3DReferenceIndex | Get the 3D-Reference index of this GrapeCity.CalcEngine.IReferenceSource object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ImportExtensionData | Overloaded. Imports the extension data. |
| PasteCore | Pastes the contents of the Clipboard onto the sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |