Whole-column and whole-row references
- 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.
- In-place formula editing and the formula bar now highlight whole-column and whole-row ranges in matching colors on both the text editor and grid view.
- Relative whole-range references are automatically refactored during cell copy, paste, and insert / delete operations.
New chart types
- The ChartType enumeration and spreadsheet drawing layer have been expanded with several new chart types:
- Heatmap: Displays 2D data intensity maps using a grid layout, supporting 3 or 4 values per data element (X, Y, intensity, and optional radius) as well as data labels.
- Funnel: Visualizes progressive process stages, showing proportional segment sizes and inner stage labels.
- Tower: Displays event sequences and comparisons side by side using stacked rectangular segments with inner data label support.
Miscellaneous
- The built-in ChartForm dialog now uses a selection list for chart categories, providing support for all newly introduced chart types and subtypes.