HyperFormula

https://handsontable.com/docs/hyperformula

Admin

HyperFormula is a TypeScript library that provides a deterministic spreadsheet engine, enabling...

Tokens:814

Snippets:14

Trust Score:10

Update:3 months ago

Show doc for...

Tokens:

Raw

### Initialize HyperFormula and Set Cell Formula

Source: https://handsontable.com/docs/hyperformula

This snippet shows how to initialize a new HyperFormula instance and set a cell's content to a formula. It demonstrates a basic calculation involving cell references.

```typescript
const hf = HyperFormula.buildEmpty();
hf.setCellContents({
  sheet: 0, row: 2, col: 1
}, '=B1*B2');
// Deterministic, exact result
const result = hf.getCellValue(...);
```

Tokens:

Raw