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

Released: May 16, 2020

Updates in V1.0.5

Features

• Added dynamic layouts to standard dialogs.
• Pressing ESC in formula bar cancels editing.
• You can now override cell navigation by handling the cellActivating event.
• resizeRowsToFit now supports merged cells.

Fixes

• Fixed click-select of merged cell address when editing formulas.
• Fixed rendering of wrapped cell text.

Released: Feb 24, 2020

Updates in V1.0.3

Features

• Localization - Standard forms can now be localized using XML. Translations for German, Spanish, French, Korean, Portuguese, Russian, and Chinese are included.
• Miscellaneous
  • Drag-select cells to enter a range while editing in formula bar.
  • New worksheetCellParsing event lets you replace values entered by users or change their data type.
  • Microsoft Excel importer fixes and optimization.
  • Auto-fill no longer changes values of non-editable cells (due to property or validation events).

Released: Apr 23, 2019

Updates in V1.0.2

Features

• Added Editable property to Cells.
• Added the ability to rotate cell text.
• Double underlining of cell text.
• AllowResizeHeaders property.
• inplaceEditStarting event with formula bar.
• CSV importer fixes.
• JavaFX dependencies removed.