Spread 8.0 Documentation
SSResetSheet Function
Support Options
DLL Reference > DLL Functions > SSResetSheet Function

Glossary Item Box

SSResetSheet Function


See Also    ActiveX    Example

Applies To

fpSpread DLL control

Description

Clears and resets the specified sheet to the default settings.

Syntax

C

void SSResetSheet(HWND hWnd, short nSheetIndex);

C++

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.