Formulas can now reference entire columns, such as =SUM(A:B), or entire rows, such as =SUM(1:5).
Relative, absolute, and mixed references are supported (A:C, $A:$C, 1:5, $1:$5).
Cross-sheet whole-range references are supported, e.g. =SUM(Sheet2!A:B).
The calculation engine and lookup functions (VLOOKUP, HLOOKUP, LOOKUP, XLOOKUP) have been optimized to leverage sparse cell storage, efficiently evaluating whole-range references without iterating over empty cells.
Relative whole-range references are automatically refactored during cell copy, paste, and insert / delete operations.
Formula Syntax Coloring and Range Highlighting
The in-place cell editor in WorkbookView now supports dynamic syntax colorization and interactive range highlighting. When entering or modifying formulas, tokens such as string literals, numeric values, and cell references are automatically color-coded. All referenced cell ranges, including rectangular blocks, whole-column, whole-row, and cross-sheet references, are simultaneously highlighted on the worksheet grid with matching outlines and translucent fills, making complex formulas easier to read and verify.