We have released version 1.2.3 of MindFusion Spreadsheet for Java Swing. 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

• Improved text rendering quality inside charts.
• 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.
• SourceProvider property added to Picture lets you implement on-demand image loading via a Supplier callback, to reduce initial load times and memory footprint in image-heavy workbooks.
• Fixed memory leak when removing Picture objects.
• Dropdown member of ValidationType lets you create custom UI for cell validation.
• Call openValidationDropdown to open validation lists from code.

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

Updated JAR is also available at the Maven Central Repository:
https://search.maven.org/artifact/eu.mindfusion/spreadsheet

Enjoy!