The list below describes recent 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.