| Name | Description |
![Public Method](dotnetimages/publicMethod.png) | AddCustomFunction |
Adds the custom function on this sheet.
|
![Public Method](dotnetimages/publicMethod.png) | ClearCustomFunctions |
Removes all user-defined custom functions (FunctionInfo object) on this sheet.
|
![Public Method](dotnetimages/publicMethod.png) | ClearCustomName |
Clears the specified name on this sheet.
|
![Public Method](dotnetimages/publicMethod.png) | ClearCustomNames |
Removes all custom names on this sheet.
|
![Public Method](dotnetimages/publicMethod.png) | Clone |
Creates a new object that is a copy of the current instance.
|
![Public Method](dotnetimages/publicMethod.png) ![static (Shared in Visual Basic)](dotnetimages/static.png) | CopyTo |
Copies data from one range to another.
|
![Public Method](dotnetimages/publicMethod.png) | FindTable |
Gets the table with a specified name.
|
![Public Method](dotnetimages/publicMethod.png) | GetCustomFunction |
Gets the custom function based on the function name.
|
![Public Method](dotnetimages/publicMethod.png) | GetCustomName |
Gets the custom name based on the name.
|
![Public Method](dotnetimages/publicMethod.png) | GetThemeColor |
Gets the color with a specified theme name.
|
![Public Method](dotnetimages/publicMethod.png) | GetThemeFont |
Gets the font family with a specified theme name.
|
![Public Method](dotnetimages/publicMethod.png) ![static (Shared in Visual Basic)](dotnetimages/static.png) | MoveTo |
Moves data from one range to another.
|
![Public Method](dotnetimages/publicMethod.png) | OpenExcelAsync | Overloaded.
Opens an Excel Compound Document File and loads it into GcSpreadSheet.
|
![Public Method](dotnetimages/publicMethod.png) | OpenXml | Overloaded.
Loads the data on the sheet from the specified XML stream.
|
![Public Method](dotnetimages/publicMethod.png) | OpenXmlAsync | Overloaded.
Loads the data on the sheet from the specified XML stream asynchronously.
|
![Public Method](dotnetimages/publicMethod.png) | Recalculate | Overloaded.
Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.
|
![Public Method](dotnetimages/publicMethod.png) | RemoveCustomFunctions |
Removes the specified custom function on this sheet.
|
![Public Method](dotnetimages/publicMethod.png) | Reset |
Resets the workbook to its default settings.
|
![Public Method](dotnetimages/publicMethod.png) | ResetThemes |
Reset the changed theme color and font name.
|
![Public Method](dotnetimages/publicMethod.png) | ResumeCalcService |
Resumes the calculation service.
|
![Public Method](dotnetimages/publicMethod.png) | ResumeEvent |
Resumes the event.
|
![Public Method](dotnetimages/publicMethod.png) | SaveExcelAsync |
Saves the control to an Excel Compound Document File stream.
|
![Public Method](dotnetimages/publicMethod.png) | SavePdfAsync | Overloaded.
Saves the content of the GcSpreadSheet component to the specified stream asynchronously.
|
![Public Method](dotnetimages/publicMethod.png) | SaveXml | Overloaded.
Saves the data on the sheet to the specified XML stream.
|
![Public Method](dotnetimages/publicMethod.png) | SaveXmlAsync | Overloaded.
Saves the data on the sheet to the specified XML stream asynchronously.
|
![Public Method](dotnetimages/publicMethod.png) | Search | Overloaded.
Searches the text in the cells in the specified sheet.
|
![Public Method](dotnetimages/publicMethod.png) | SetCustomName | Overloaded.
Adds a custom name to the name collection.
|
![Public Method](dotnetimages/publicMethod.png) | SuspendCalcService |
Suspends the calculation service.
|
![Public Method](dotnetimages/publicMethod.png) | SuspendEvent |
Suspends the event.
|