Skip to content

v2.23.0

Choose a tag to compare

@github-actions github-actions released this 24 Sep 12:15
· 7 commits to main since this release

INDIRECT finishes R1C1: whole rows and whole columns work too.

New

  • Whole-row and whole-column R1C1 references in INDIRECT. A part naming
    only rows (R2, R1:R3) or only columns (C3, C1:C2) now resolves to the
    whole row or column, and the relative forms (R[-1], a bare R or C) are
    measured from the formula's own cell as usual. That was the last gap the
    README listed.

Notes

Both halves of a range have to be the same kind, so a mix such as R2:C3 is
#REF! rather than a guess. Whole-row and whole-column references already
worked in A1, so these resolve onto the same path the engine already had.

Formulas themselves are still always A1, which is how the file format stores
them; INDIRECT and ADDRESS are where R1C1 text is read and written.