Spread 8.0 Documentation
GetIteration, ScriptGetIteration Methods
Support Options
ActiveX Reference > ActiveX Methods > GetIteration, ScriptGetIteration Methods

Glossary Item Box

GetIteration, ScriptGetIteration Methods


See Also    DLL    Example

Applies To

fpSpread control

Description

Returns the number of iterations for circular references.

Syntax

C++

BOOL CSpreadSheet::GetIteration (short* MaxIterations, double* MaxChange);

Visual Basic

fpSpread.GetIteration(MaxIterations As Integer, MaxChange As Double) As Boolean

Note: The ScriptGetIteration method uses the same syntax except method parameters that are not passed "ByVal" are declared as variants. For more information on Script methods, see Scripting Environment Usage.

Parameters

The following parameters are available:

Parameter Description
MaxIterations Maximum number of iterations
MaxChange (Future use)

Remarks

The GetIteration method returns iteration options for circular references in formulas. A circular reference occurs when a formula in a cell refers to its own cell. For example, the formula (A1*B1) is circular if it is in cell A1.

This method is applied to the entire workbook, including all sheets in the control.

The iteration process stops after the number of iterations returned by the MaxIterations parameter.

Note: Call this method if you use the Spread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the Spread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and call the ScriptGetIteration method. ScriptGetIteration method parameters that are not passed "ByVal" are declared as variants.

Return Type

True if recursive formulas are being evaluated; otherwise, False.

See Also

Using Circular References in Formulas

ScriptEnhanced property

SetIteration method

DLL Correspondence

SSGetIteration function

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