MindFusion.Spreadsheet for WPF 版本发布

查看各个版本中的新增内容,包括功能、增强和已解决问题的详细信息。

1月
2月
3月
4月
5月
6月
7月
8月
9月
10月
11月
12月
MindFusion.Spreadsheet for WPF V1.4.22026年11月18日
功能
  • 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.
    • Relative whole-range references are automatically refactored during cell copy, paste, and insert / delete operations.
  • Formula Syntax Coloring and Range Highlighting
    • The in-place cell editor in WorkbookView now supports dynamic syntax colorization and interactive range highlighting. When entering or modifying formulas, tokens such as string literals, numeric values, and cell references are automatically color-coded. All referenced cell ranges, including rectangular blocks, whole-column, whole-row, and cross-sheet references, are simultaneously highlighted on the worksheet grid with matching outlines and translucent fills, making complex formulas easier to read and verify.

 

修复
  • MINA and PROPER function fixes.