Adding Formulas
Overview
You can add a formula to any cell in a sheet. You can also use formulas across sheets if the control has multiple sheets. You can also let users enter formulas directly into the sheet. For more information on letting users add formulas, see Allowing Users to Enter Formulas.
You can control the way in which formulas are updated and calculated. For more information, see Automatically Recalculating and Updating Formulas and Using Circular References in Formulas. The way in which the control refers to the data in the cells is determined by the cell reference style you choose for the control. For instructions and information about cell reference styles, see Specifying Cell References.
For a list of the operators and functions you can use in formulas, see Built-In Functions. If the control does not provide the logical or mathematical function you need, you can define your own. For instructions, see Creating and Using Custom Functions.
Now, with Spread 7, comes the ability to reference any cell in any sheet in the control. This 3-D referencing (any cell in any column or row on any sheet) is available for any formula. You reference the sheet by the sheet name.