MindFusion.Spreadsheet for WinForms Versioni

MindFusion GroupControlli del foglio di calcolo.NET
Versione 1.8.1 (16 nov 2025)

Scopri le novità in ogni release, con dettagli su funzionalità, miglioramenti e problemi risolti.

gen
feb
mar
apr
mag
giu
lug
ago
set
ott
nov
dic
MindFusion.Spreadsheet for WinForms V1.8.116 nov 2025
Funzionalità
  • 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.
MindFusion.Spreadsheet for WinForms V1.8Versione principale11 giu 2025
Funzionalità
  • 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.
  • Set the ShowLeadingApostrophes property to stop hiding escaping leading apostrophe (used to treat remaining cell content as text).
  • 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.
  • SUMIF/COUNTIF criteria are now case-insensitive for compatibility with Excel.
  • [h], [m] and [s] format specifiers allow displaying time totals with more than 24 hours or 60 minutes / seconds respectively.
Correzioni
  • DATEDIF function fix for calculating month difference.
  • Formula bar preserves original text when evaluation is disabled.