The list below describes past changes and additions to JSpreadsheet:

New in version 1.0.11

• cellChangedPreCalc and cellChangedPostCalc events
• 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).

New in version 1.0.10

• Fixed missing parentheses when ExcelImporter imports shared formulas.
• Frozen rows and columns properties moved from Worksheet to view classes, and now allow freezing from a non-zero scroll position. The freezePanes method freezes columns to the left of and rows above the active cell.
• Fix for charts displaying zero coordinates along the axes.
• Format numbers in thousands or millions by adding a comma for each 1000 scale to the end of format strings.
• Fix for pasteStyles not clearing all attributes of old styles.
• Custom format strings can now contain color names in square brackets, compatible with Excel color specifiers.
• Fix for horizontal barcharts showing overlapped labels.
• Fix for displaying (handled) exceptions in console when blank cell contains annotation.
• Fixed null-reference exceptions in CalcImporter.
• Extends the set of expression types in which blank cells are promoted to zeros or empty strings when referenced from formulas.
• Fixed ROUND and DB functions when rounding off after the decimal point.

New in version 1.0.9

• ValidateOnPaste property specifies if Validation rules should be applied to pasted values.
• FindReplaceForm can search for formatted text value.
• Skip individual cell changes from validation events by setting SkipCell.
• Fixed am/pm formatting for date values.
• Context property of validation event specifies the cause of the change.
• SUMIF and AVERAGEIF function fixes.
• Fixed resizeRowsToFit results when the spreadsheet view is zoomed.
• excelStyleMergedBorders fixes.
• Fixed merged range selection border when ActiveCell is set from code.

New in version 1.0.8

• Limit spreadsheet's scroll range by setting MaxRows and MaxColumns properties.
• The drawCell event now specifies the origin of merged range as argument, instead of first visible cell from merged range (when different due to scrolling).
• Fixed formatting for Percent data type.
• When a cell's format is set to percentage, the cell's entry box automatically appends % suffix (as in Excel) to treat the entered value as percents without multiplying by 100.
• Fixed glitches from optimized-scrolling buffer when Windows 10 display scaling is enabled.

New in version 1.0.7

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

New in version 1.0.6

• The drawCell event lets you render custom graphics inside cells.
• ActiveBorderPen property lets you customize borders of the ActiveCell.
• Improved scrolling speed.
• TabBackground property specifies worksheeet's tab background.
• ArrowActions property lets you specify action of arrow buttons in the tab strip.
• New resizeRowsToFit overloads lets you set default size of empty rows.
• VLOOKUP function fixes.
• queryDropDownList event lets you provide custom values for validation drop-down.
• Validation dropdown can now display values from named range.
• Improved render quality of embedded pictures.
• Setting a shared DocumentBuilder object lets you improve Excel import performance.
• Some fixed default values in Excel import/export.

New in version 1.0.5

• Dynamic layout and sizing in standard forms.
• resizeRowsToFit now works for rows containing merged cells.
• Pressing ESC in formula bar cancels editing.
• Click-selecting merged cells while editing formulas now selects first cell's address.
• Fixed rendering of wrapped cell text.
• Canceling edit operation from inplaceEditEnding event handler keeps the active cell.
• The activatingCell event allows overriding cell navigation.

New in version 1.0.4

• Support for mnemonics in translation files.
• ConditionalFormatForm fixes.
  

New in version 1.0.3

Localization

The standard forms from com.mindfusion.spreadsheet.standardforms package can now be localized via XML translation files containing UI labels for respective language. To enable localization, call the new setLocalizationInfo method of the Workbook class and provide path to the XML file. Translations for German, Spanish, French, Korean, Portuguese, Russian, and Chinese can be found inside the localization folder of the library's distribution.

Miscellaneous

• Drag-select cells to enter a range while editing in formula bar.
• worksheetCellParsing event lets you replace values entered by users or change their data type.
• ExcelImporter fixes and optimizations.
• Auto-fill no longer changes values of non-editable cells (due to property or validation events).

New in version 1.0.2

• The Editable property added to Cell class lets you prevent users from changing cell's content.
• Show rotated cell text by setting the Rotation style property.
• Show double underlined cell text by setting the FontDoubleUnderline style property.
• Prevent users from resizing rows and columns by setting the AllowResizeHeaders property.
• The inplaceEditStarting event is now raised by the formula bar too.
• CSV importer fixes.
• JavaFX dependencies removed.

New in version 1.0.1

Java 10 compatibility.