Manage Formulas

Spread.Services Documentation
Manage Formulas
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Manage Formulas

You can add formulas in a worksheets to carry out complex calculations on numerical data residing in cells or a range of cells. Formulas are written as algebraic expressions, statements, or equations that start with an "=" (equal to) sign. The computation of a formula always begins from left and extends towards the right as per the operator precedence. In case you want to modify the order of computation, you can enclose some specific portions within the formula in parentheses.

Shared below is the descending order of operations for Spread.Services formulas with the first one holding the maximum precedence and last one holding the minimum precedence.

1. Parentheses evaluation of expressions
2. Range evaluation
3. Evaluation of spaces within the expression.
4. Evaluation of commas within the expression
5. Evaluation of variables with negation sign (-)
6. Conversion of percentages(%)
7. Evaluation of exponents (with ^ sign)
8. Multiplication and Division operators (hold equal precedence).
9. Addition and Subtraction operators (hold equal precedence).
10. Evaluation of text operators
11. Evaluation of comparison operators (=,<>,<=,>=)

In Spread.Services, managing formulas involves the following tasks.

- Set Formula to Range
- Set Table Formula
- Set Array Formula

Copyright © GrapeCity, inc. All rights reserved.