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

Glossary Item Box

Entering Formulas


Overview

You can define formulas (mathematical expressions) for currency, number, and percent cells. The fpSpread control has over 100 built-in mathematical, logical, and statistical functions, as described in the Built-In Functions as well as the ability to handle custom functions and custom names.

The following sections describe adding formulas to the sheet, and ways you can customize how you and users create and use formulas, including setting the style for cell references and creating custom functions.

If a mistake is made in a formula, or something changes within the sheet that causes an error in the formula, the formula will be changed and the incorrect value or reference will be replaced by an error code. For a list of error codes, see Built-In Functions.

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