Spread 8.0 Documentation
ResetSheet Method
Support Options
ActiveX Reference > ActiveX Methods > ResetSheet Method

Glossary Item Box

ResetSheet Method


See Also    DLL    Example

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

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