SSResetSheet Function

---

See Also    ActiveX    Example

Applies To

fpSpread DLL control

Description

Clears and resets the specified sheet to the default settings.

Syntax

void SSResetSheet(HWND hWnd, short nSheetIndex);

void TSpread::ResetSheet(short nSheetIndex);

Parameters

This function has the following parameters:

Parameter	Description
hWnd	Window handle of the fpSpread control
nSheetIndex	Sheet index of sheet to be reset

Remarks

Call the SSResetSheet function 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 SSReset function. If you want to clear data from a range of cells, call the SSClearRange function.

See Also

Resetting a Sheet to its Default Settings

SSClearRange, SSReset functions

ActiveX Correspondence

ResetSheet method