Document Editor · Advanced Features

Excel Formulas

Use Excel-compatible formulas in table cells and observe automatic calculations.

Live document calculations

Explore Excel-compatible formulas

Edit an input value in the cash-flow table, inspect how formula cells reference it, and watch calculated results update inside the document.

Calculation model

Inputs, expressions, and results travel together in the document.

AUTOMATIC

Input cellsUser edits a value

Formula engineReferences are evaluated

Result cellsText updates instantly

Formula cells0

Functions used0

References0

Change any white numeric cell in the table. Green result cells recalculate automatically.

Cell reference style

Choose familiar spreadsheet coordinates or row-and-column notation.

Relative referenceR[-1]C[-2]One row above, two columns left

Select a formula cellChoose a calculation below to inspect and edit its expression.

Formula cells in the cash-flow table

Select an entry to move to that cell and inspect its live calculation.

0 FORMULAS

Reading formulas from the document...

What this demonstrates

Tables can carry their own calculation logic

TX Text Control combines word-processing layout with spreadsheet-style calculations. A table cell can store an Excel-compatible formula, reference other cells in the same table, and automatically update its displayed text whenever an input changes.

Formula expression

TableCell.getFormula / setFormula

Calculated result

TableCell.getText

Cell location

TableCell.getRow / getColumn / getName

Cell at the caret

TableCellCollection.getItemAtInputPosition

Reference notation

TXTextControl.setFormulaReferenceStyle

How it works

The template contains a cash-flow table with ordinary input cells and green calculation cells. Each result cell stores its expression independently through TableCell.setFormula; the calculated value is returned as the cell's text through TableCell.getText.

Formula references are scoped to the same table. With FormulaReferenceStyle.A1, B3 identifies column B and row 3. FormulaReferenceStyle.R1C1 expresses the same cell as R3C2 and additionally supports relative coordinates such as R[-1]C[-2].

The panel enumerates TXTextControl.tables and each table's cell collection. Cells with a non-empty getFormula result become entries in the formula map; their expression is parsed only for visualization while TX Text Control remains the calculation engine.

Calling TableCell.select moves the editor to a chosen calculation. Applying an edited expression with setFormula immediately recalculates that cell and any formulas that depend on it.

The synchronization also works in the opposite direction. On inputPositionChanged, TXTextControl.tables.getItem finds the table at the caret and TableCellCollection.getItemAtInputPosition returns its current cell. Its document start position, row, and column identify the corresponding entry in the formula map.

The Formula ribbon tab exposes the same capabilities interactively and includes more than one hundred mathematical, statistical, logical, and trigonometric functions compatible with common spreadsheet workflows.

Read a formula and its calculated value

const formula = await request(cell, "getFormula");
const result = await request(cell, "getText");

console.log({ formula, result });

Update a document formula

await request(cell, "setFormula", "=SUM(B2:B6)");
const recalculated = await request(cell, "getText");

Switch the reference notation

await request(
    TXTextControl,
    "setFormulaReferenceStyle",
    TXTextControl.FormulaReferenceStyle.R1C1);

Follow the cell at the input position

TXTextControl.tables.getItem(table => {
    table?.cells.getItemAtInputPosition(cell => {
        if (cell) synchronizeFormulaInspector(table, cell);
    });
});