MindFusion.Spreadsheet for Java Swing V1.2.32026年11月3日
機能
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
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.
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.
Dropdown member of ValidationType lets you create custom UI for cell validation.
Call openValidationDropdown to open validation lists from code.
修正
Fixed memory leak when removing Picture objects.
MINA and PROPER function fixes.
MindFusion.Spreadsheet for Java Swing V1.2.22026年3月6日
機能
Dynamic formula bar and tab heights for non-default look and feel (e.g. FlatLaf).
applyRowVisibility and applyColumnVisibility methods let you specify visibility of row or column sets with a single call.
New merge overload lets you create merged cells faster by skipping validations.
Optimized style read / write operations.
Improved precision and performance of resizeRowsToFit and resizeColumnsToFit methods.
Reduced memory allocations during drawing and recalculation.
validationDropdownOpening and validationDropdownClosing events.
Disabled EnableReferenceRefactoring property to copy cells faster.
修正
setMaxTabSize invalidates layout.
SUMPRODUCT fixes.
MindFusion.Spreadsheet for Java Swing V1.2.12026年2月6日
機能
Optimized Calculation Engine:
Performance in large multi-sheet workbooks has been improved by introducing spatial indexing of cell data, leading to 2-3 times faster initial and incremental formula calculations.
Added New Functions:
SUMIFS adds the cells in a range that meet multiple criteria.
COUNTIFS counts the number of cells specified by a given set of conditions or criteria.
CONCAT merges text from several ranges and/or individual strings.
TEXTJOIN combines text from multiple ranges or strings, inserting a specified delimiter between each text value.
Miscellaneous:
Mouse wheel scroll amount according to system configuration.