Formula Class
Stateless one-shot formula evaluation. Internally creates a fresh FormulaEngine per call, so each call is independent.
Inheritance
Object
Documents.Spreadsheet.Formula
Namespace: Radzen.Documents.Spreadsheet
Assembly: Radzen.Blazor.dll
Syntax
public static class FormulaMethods
Evaluatelink
Evaluates a literal expression with no cell references.
Declaration
public static object Evaluate(string expression)Parameters
| Type | Name | Description |
|---|---|---|
| string | expression |
Returns
| Type | Description |
|---|---|
| object |
Examples
Formula.Evaluate("=SUM(1, 2, 3) + IF(2>1, 10, 20)"); // → 16Evaluatelink
Evaluates a literal expression with no cell references.
Declaration
public static object Evaluate(string expression, IReadOnlyDictionary<string, object> cells)Parameters
| Type | Name | Description |
|---|---|---|
| string | expression | |
| IReadOnlyDictionary<string, object> | cells |
Returns
| Type | Description |
|---|---|
| object |
Examples
Formula.Evaluate("=SUM(1, 2, 3) + IF(2>1, 10, 20)"); // → 16