SpreadJS 11 Service Pack 1

Adds more spreadsheet protection options and diagonal line borders.
April 26, 2018
New Version

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.
Diagonal line borders

SpreadJS

Complete spreadsheet solution for JavaScript applications.

Got a Question?

Live Chat with our MESCIUS (formerly GrapeCity) licensing specialists now.