Spread 8.0 Documentation
Using Circular References in Formulas
Support Options
User's Guide > Working with the Control > Working with Data > Entering Formulas > Using Circular References in Formulas

Glossary Item Box

Using Circular References in Formulas


Overview

You can specify how the control calculates circular references used in formulas. A circular reference occurs when a formula uses the value in a cell to compute another value, which in turn is used by the first cell to recalculate its value. A simple example is if cell A1's value is equal to the formula B1+C1, and the value of cell C1 is equal to A1*3.

You can control the number of times the control calculates a circular reference.

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