The list below describes past changes and additions to JSpreadsheet:

New in version 1.1.3

• New DataBar element of ConditionalFormatType draws data-bars showing magnitude of cell values relative to other cells in the formatted range. Bars are drawn using the BarBrush property of IStyle.
• DATEDIF function fix for calculating month difference.

New in version 1.1.2

• New bringIntoView overloads let you specify alignment of the cell in current viewport.
• Formula bar focus change fixes.
• Fix for formula bar showing grouping separator in formulas.
• Excelimporter cell border style fixes.
• Excelimporter named style import fix.
• Improved thread safety for server-side scenarios.

New in version 1.1.1

• The PasteToMerged property lets you specify how the control handles pasting data into merged cells.
• Formula bar preserves original text when evaluation is disabled.
• Set the ShowLeadingApostrophes property to stop hiding escaping leading apostrophe (used to treat remaining cell content as text).
• Fixed ExcelExporter export of quoted texts.
• The CellIndex class can be used to convert between integer column / row and string representation of a cell address.
• A new get overload of CellCollection accepts CellIndex as parameter.
• OldValue, CurrentColumn and CurrentRow properties of IExpressionEvaluatorContext provide more contextual information for custom function evaluation.
• The cancelDrag method lets you stop current user interaction.
• Fixed incorrect cached state of modifier keys when the control loses keyboard focus.

New in version 1.1

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 shows a hint box with function information when user enters a function name in formula.

Formula bar improvements

• Users can enter a new line in formula bar by pressing Ctrl + Enter.
• The Tab key now tabs out of formula bar instead of tabulating the text.
• Changes entered through formula bar are now undoable.
• Formula bar no longer displays trailing zeros when selecting numeric cells.
• Formula bar is cleared when changing the active sheet.

Miscellaneous

• Date format strings can now contain apostrophes to escape literal values.
• The cell editor grows when user types longer expressions.
• valueAs shortcut method for getting cell values of specific types.
• The sum method of CellRange now includes formula results.

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.