ResetSheet Method
Applies To
fpSpread control
Description
Clears and resets the specified sheet to the default settings.
Syntax
C++
BOOL CSpreadSheet::ResetSheet(short Sheet);
Visual Basic
fpSpread1.ResetSheet(ByVal Sheet as Integer) As Boolean
Parameters
The following parameter is available:
| Parameter | Description |
|---|---|
| Sheet | Sheet index of sheet to be reset |
Remarks
Call the ResetSheet method to clear the data and formatting from the specified sheet, including cell notes and formulas. It also clears the font settings.
If you want to reset the control to clear all its data and delete all sheets except Sheet 1, call the Reset method. If you want to clear data from a range of cells, call the ClearRange method.
Return Type
True if the sheet is reset; otherwise, False.
See Also
Resetting a Sheet to its Default Settings
ClearRange, Reset methods
DLL Correspondence
SSResetSheet function