| Name | Description | |
|---|---|---|
 | SubWorksheet Constructor | Initializes a new instance of the SubWorksheet class. |
SubWorksheet Class Members
In This Topic
The following tables list the members exposed by SubWorksheet.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveCell | Gets an IRange object that represents the active cell. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| AutoFilter | Gets the filter of this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| AutoFilterMode | Gets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| BackgroundImage | Gets the backgroudn image of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Behaviors | Gets or sets the behaviors of operations. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Cells | Gets an IRange instance which represents the entire worksheet cells. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| CircularReference | Gets an IRange object that that represents the range containing the first circular reference on the sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ColumnCount | Gets or sets the number of columns in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ColumnFooter | Gets the column footer of a worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ColumnHeader | Gets the column header of a worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Columns | Get an IRange object that represents all the columns on the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Comments | (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| CommentsThreaded | Gets an ICommentsThreaded collection that represents all the top-level/root comments (no replies) for the specified worksheet. Includes legacy and modern comments. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| DataManager | Gets or sets the data source of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| DataValidations | Gets the GrapeCity.SpreadsheetValidations object which manages all data validations in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Drawing | Gets the GrapeCity.Spreadsheet.Drawing.WorksheetDrawing object contains all drawing objects within the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| EnableCalculation | Gets or sets a value indicating whether calculation engine automatically recalculates the worksheet when necessary. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| FormatConditions | Gets the conditional formatting manager. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Index | Gets the index number of the worksheet within the collection of worksheets. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| LayoutManager | Gets the layout manager of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Locks | Gets the protected data of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Name | Gets or sets the name of worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Names | Gets a Worksheet.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Next | Gets a Worksheet that represents the next sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Options | Gets the WorksheetOptions object that represents all options of the IWorksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Owner | Overridden. Gets the owner worksheet. |
| PageSetup | Gets the page setup of the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Previous | Gets a Worksheet that represents the previous sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ProtectionMode | Gets a Worksheet.ProtectionMode value indicating whether this worksheet is protected. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| RowCount | Gets or sets the number of rows in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| RowHeader | Gets the row header of a worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Rows | Get an IRange object that represents all the rows on the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Selection | Gets the current selected cell(s). (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Sort | Gets the sort object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Sparklines | Gets the sparkline storage of this worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| SubType | Overridden. Gets the worksheet sub-type. |
| TabColor | Gets or sets the color of the tab. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Tables | Gets the Worksheet.Tables object which manages all tables in this Worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Tag | Gets or sets the object that contains data about the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Type | Gets the worksheet type. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| View | Gets the worksheet view of this Worksheet object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Visible | Gets or sets whether the worksheet is visible. |
| Workbook | Gets the Worksheet.Workbook object contains current Worksheet object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| WorkbookSet | Gets the Worksheet.WorkbookSet object contains current Worksheet object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
Public Methods
| 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) |
Protected Methods
| 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) |
See Also