| Name | Description | |
|---|---|---|
 | SubWorksheet Constructor | Initializes a new instance of the SubWorksheet class. |
The following tables list the members exposed by SubWorksheet.
| Name | Description | |
|---|---|---|
| SubWorksheet Constructor | Initializes a new instance of the SubWorksheet class. |
| 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 background 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) |
| EnableSelection | Gets or sets what can be selected on the sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| FormatConditions | Gets the conditional formatting manager. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| FrozenTrailingRowCount | Gets the number of non-scrolling rows on the trailing edge of this sheet. (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) |
| Protection | Gets an IProtection object that represents the protection options of the worksheet. (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) |
| 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) |
| 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) |
| ContainsHiddenNote | Get a value indicate current worksheet contain at least one note is being hidden. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ContainsLockedCell | Overloaded. Determines whether the specified range contains at least one locked cell. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Copy | 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) |
| EnsureCalculated | 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) |
| GetAppliedRange | Refines the selection which is used to execute an UI command. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetCommentStorage | Get Comment Storage (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) |
| GetText | Overloaded. Gets the displayed text of the specified value base on the target cell in this sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetTextToColumnsCount | Determines the how many columns can be extracted from source range data. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| GetUnspilledValue | Gets raw data from the specified cell on this sheet. The spilled value will be skipped. (Inherited from GrapeCity.Spreadsheet.WorksheetBase) |
| GetValue | Overloaded. Gets the value at the specified location of the 2-dimensions matrix. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| HasHeaders | Determines whether the specified row has headers. (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) |
| 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) |
| IsHyperlinkAvailable | Check if there is a hyperlink from the specified range. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsSortAvailable | Gets a boolean value indicating whether worksheet has sort object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsSparklineAvailable | Gets a value indicating whether there is sparkline in the worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| IsSpilledCell | Gets a value indicating whether the cell is spilled. (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) |
| 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) |
| SaveAs | Overloaded. Saves this IWorksheet to the specified System.IO.Stream. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Select | Selects the sheet. (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 without notifying. (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) |
| Name | Description | |
|---|---|---|
 | AddChartObject | Add empty chart object to current worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| AfterVisibleChanged | After worksheet visible changed. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ChangeVisible | Change Visibility of worksheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ExportExtensionData | Enables an object to extend another object through aggregation. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| Get3DReferenceIndex | Get the 3D-Reference index of this GrapeCity.CalcEngine.IReferenceSource object. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ImportExtensionData | Overloaded. Imports the extension data. |
| OnRowColumnChanged | (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| PasteCore | Pastes the contents of the Clipboard onto the sheet. (Inherited from GrapeCity.Spreadsheet.Worksheet) |
| ProcessAutoRowHeightExtra | Support some extra logic for process auto row height. (Inherited from GrapeCity.Spreadsheet.Worksheet) |