Formula uses functions from FormulaJS through RevoGrid’s own expression parser. This is a documented FormulaJS-backed subset, not full Excel compatibility and not every call accepted by the standalone FormulaJS JavaScript API.
- Stored grid formulas begin with
=.
- Function arguments use commas.
- Values can come from A1 cells, rectangular A1 ranges, names, numbers, quoted strings, and
TRUE / FALSE.
- Sheet ids containing spaces use quotes:
'Product List'!A1:B3.
- Arithmetic supports
+, -, *, /, parentheses, and unary signs.
- Comparisons support
>, >=, <, <=, =, and <>.
- Nested supported function calls are evaluated from the inside out.
JavaScript array literals such as [1,2,3] are not grid formula syntax. Put values in cells and pass an A1 range such as A1:A3, or use a named range. Low-level evaluate() examples in the FormulaJS project are JavaScript API calls and may not be copyable grid formulas.
The following catalog uses one deterministic fixture and is exercised by the Formula documentation test.
Fixture used below
| Row | A (sku) | B (amount) | C (units) |
|---|
| 1 | B-200 | 10 | 2 |
| 2 | A-100 | 20 | 4 |
| 3 | B-200 | 30 | 6 |
Math and aggregation
| Function | Grid formula example | Result |
|---|
SUM | =SUM(B1:B3) | 60 |
AVERAGE | =AVERAGE(C1:C3) | 4 |
ROUND | =ROUND(B1/3,2) | 3.33 |
Logical and text
| Function | Grid formula example | Result |
|---|
IF | =IF(B1>5,"high","low") | high |
LEN | =LEN(A1) | 5 |
Lookup and reference
| Function | Grid formula example | Result |
|---|
VLOOKUP | =VLOOKUP("A-100",A1:B3,2,FALSE) | 20 |
INDEX, MATCH | =INDEX(B1:B3,MATCH("A-100",A1:A3,0)) | 20 |
Date and financial
| Function | Grid formula example | Result |
|---|
YEAR | =YEAR("7/5/2008") | 2008 |
PV | =PV(0.1,2,100) | Approximately -173.553719 |
Date parsing follows FormulaJS and can depend on the supplied string and runtime. Prefer unambiguous application data for production date calculations. Floating-point financial results should be compared with an appropriate tolerance.
The tested lookup set is LOOKUP, VLOOKUP, HLOOKUP, and INDEX with MATCH. XLOOKUP is not currently supported. For a complete external-sheet fixture, see Cross-sheet Formulas.
| Situation | Result |
|---|
| Unknown syntax/function or circular formula/name | #ERROR |
| Autofill translates a relative reference before A1 | #REF! |
| A mounted formula explicitly references an external sheet that is not registered | #LOADING |
An async formula rejects without a custom errorValue or mapError | #ERROR |
FormulaJS exposes more functions than are shown here, but parser compatibility and argument shapes still matter. Verify an unlisted function with your actual data before treating it as part of an application contract.
Previous: Backend Calculation and Persistence · Next: Formula API · Deeper reference: Quick Start
