Interface FormulaRefNode

A cell reference of a cell formula: row and column 0-based (B3 = row 2, column 1), $ = absolute. In a range a whole column (A:A) has row: -1, a whole row (3:3) has col: -1.

Example

const ref: FormulaRefNode = { kind: "ref", row: 2, col: 1, absRow: true, absCol: false };   // B$3

Since

1.1.99

Hierarchy

  • FormulaRefNode

Properties

Properties

absCol: boolean
absRow: boolean
col: number
kind: "ref"
row: number