We have released version 1.2 of MindFusion Spreadsheet for Java Swing. It contains the following new features and improvements:

Spilled arrays
Formulas can now run arithmetic operations on whole ranges and return two-dimensional arrays as results. Elements from such arrays are assigned to adjacent cells to the one that calculates the formula. For example, you could show element-wise sum of ranges by setting a single formula in =A1:C3+E1:F3 format. If a cell from the spill range already contains a value, the formula returns a #SPILL error. Apart from arithmetic calculations, spilled arrays can also be returned by following new functions.



Spilled array functions

• FILTER returns an array of filtered rows from specified source range.
• SORT returns an array of sorted rows or columns from specified source range.
• UNIQUE returns an array of unique values from the specified range.
• XLOOKUP searches for a value in a range and returns the matching row or column from specified results range.

Miscellaneous

• Improved alignment of spanned cells by bringIntoView.
• Improved compatibility with Excel of VLOOKUP function in undefined cases (when lookup value is missing and source range is not sorted).
• YEARFRAC function calculates the ratio between days in specified interval to the number of days in a year.

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

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

Enjoy!