Released: Mar 6, 2026

Updates in V1.2.2

Features

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

Released: Feb 6, 2026

Updates in V1.2.1

Features

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

Released: May 26, 2025

Updates in V1.2

Features

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

Released: Apr 4, 2023

Updates in V1.1

Features

• Formula hints:
  • Target cells or cell ranges in a formula expression are now color-coded to show the matching area in grid view.
  • The control now shows a hint box when user enters a function name in a formula.
• Formula bar improvements:
  • Users now can enter a new line in formula bar by pressing Ctrl + Enter.
  • The Tab key now tabs out of the formula bar instead of tabulating the text.
  • Changes entered through formula bar are now undoable.
  • Formula bar no longer displays trailing zeros when...

Released: Jul 23, 2022

Updates in V1.0.11

Features

• Added cellChangedPreCalc and cellChangedPostCalc events.

Fixes

• Fix for diagonal borders showing in exported Excel files when border width is set to 0.
• MROUND and ROUND function fixes.
• Fix for skipping manual page breaks (set via PageBreak property).

Released: Oct 7, 2021

Updates in V1.0.10

Features

• Frozen row and column properties have been moved from Worksheet class to the view class and now allow freezing from a non-zero scroll position.
• You can now format numbers in thousands or millions by adding a comma for each 1000 scale.
• Custom format strings can now contain color names in square brackets, compatible with Microsoft Excel color specifiers.
• Extended the set of expression types in which blank cells are promoted to zeros or empty strings when referenced from formulas.

Fixes...

Released: May 5, 2021

Updates in V1.0.9

Features

• Added ValidateOnPaste property which specifies if Validation rules should be applied to pasted values.
• FindReplaceForm can now search for formatted text values.
• You can now skip individual cell changes from validation events by setting SkipCell.
• Context property of validation event now specifies the cause of the change.

Fixes

• Fixed resizeRowsToFit results when the spreadsheet view is zoomed.
• Fixed issue with excelStyleMergedBorders.
• Fixed issue with SUMIF and AVERAGEIF function.
• Fixed...

Released: Nov 21, 2020

Updates in V1.0.8

Features

• Added the ability to limit a spreadsheet's scroll range by setting MaxRows and MaxColumns properties.
• The drawCell event now specifies the origin of the merged range as an argument, instead of the first visible cell from a merged range.
• When a cell's format is set to percentage, the cell's entry box automatically appends % suffix (as in Microsoft Excel).

Fixes

• Fixed formatting for Percent data type.
• Fixed glitches from optimized-scrolling buffer when Windows 10 display scaling is...

Released: Oct 27, 2020

Updates in V1.0.7

Fixes

• Fixed drawing glitches when Microsoft Windows 10 display scaling is enabled.
• Fixes and improvements of clipboard operations.

Released: Sep 8, 2020

Updates in V1.0.6

Features

• Added drawCell event which lets you render custom graphics inside cells.
• Added ActiveBorderPen property which lets you customize the borders of the ActiveCell.
• Improved scrolling speed.
• Added TabBackground property which specifies a worksheet's tab background.
• Added ArrowActions property which lets you specify the action of arrow buttons in the tab strip.
• Added new resizeRowsToFit overloads which lets you set the default size of empty rows.
• Added queryDropDownList event which lets you...