We have released version 1.8.2 of Spreadsheet for WinForms. It contains the following new features and improvements:

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 (demonstrated in SpecialtyCharts sample project):

• 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.
• MINA and PROPER function fixes.

Installer for the latest version can be downloaded here, or from the clients area on our site:
https://mindfusion.dev/SpreadsheetTrial.zip

Updated assemblies are also available as MindFusion.Spreadsheet NuGet package.

Enjoy!