MindFusion.Spreadsheet for WinForms Versionen

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

• 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.