Released: Apr 25, 2018

Updates in 11 Service Pack 1

Features

• Undo/Redo enhancement - In previous versions, undo and redo for custom commands had to be handled with multiple functions. Now the user only needs to define the "execute" function, making it much simpler.
• FilterDialog UI enhancement - SpreadJS now supports tree hierarchies in the filter dialog, useful for dates and outlines. The hierarchies support conditional filters like text, number, and date, as well as color.
• Protection Options enhancement - More protection options have been added to the sheet, including allowDragInsertRows/Columns, allowInsertRows/Columns, and allowDeleteRows/Columns. These options can also be set in the designer.
• Custom IconSet - You can now add custom icons for individual IconCriterion in a custom icon set.
• Diagonal lines - Diagonal line borders are now supported in cells and ranges. Several line styles are included, and they are supported in JSON serialize/deserialize, ExcelIO, and printing.
• Vertical text - SpreadJS now supports vertical text in cells, just like Excel. Properties include alignment, indent, word-wrap, etc.
• Double underline - This feature is similar to the single underline support currently in SJS, but now provides a double underline option - ideal for any financial or accounting application. This also works well with the Cell Alignment, ForeColor, WordWrap, Indent, ShrinkToFit, and CellOverflow options.