Eaze Calculations
Worksheets support cell calculations written in Eaze — Profitbase InVision's formula language for data grids.
A calculation formula has this shape:
@<column>[<row-filter>] = <expression>;
@Amount[] = Price * Qty;
The left-hand side addresses the cell(s) to write to; the right-hand side is the expression that produces the value. Multiple statements run in order, top to bottom.
Eaze is also used in Worksheet rules — Cell Validation, Conditional Cell Read-Only, and Row/Cell Styling all use Eaze expressions for their Target and Statement fields.
Full Eaze reference
All language details, operators, functions, and Workbook context are documented in the shared Eaze reference:
- Eaze overview — where Eaze is used and how to navigate the docs
- Cell Addressing — column references, row predicates, cross-sheet
! - Operators
- Keywords and Context —
this,this.Rows,this.DataSets - Execution Model — statement order,
RecalcAction - Function Reference — all built-in functions
- App Variables —
AppVariables.Factor,getValue() - Patterns — idiomatic examples
Worksheet rules
- Cell Validation —
ValidationError/ValidationWarning - Conditional Cell Read-Only
- Row Styling
Extensibility
- JavaScript Code-Behind — inline JS in Worksheets (2025.5+)
- Calculation Instance Factory — custom JS calc services