SpreadJS 12 SP2

Printing Enhancements

• Printing in SpreadJS has been enhanced with a new event, print preview lines, printing info for the page, and background watermark images. With the new BeforePrint event, printing can be cancelled after it is initiated. With print preview lines, dotted lines are drawn in the workbook to show where pages end when printed out.
• The print info now includes API to show the printing range of cells for each page, and the background watermark image can now be added when printing a page.

Drag-Fill Enhancements

• Drag-filling in SpreadJS has been enhanced with support for days of a month, strings with numbers, and custom lists. Drag-filling dates will fill in the rest of the month where appropriate. Strings that have numbers at the beginning or end can be filled correctly in sequence. With custom lists, a developer can create a specific set of data to drag fill a range of cells with.

Wrap-Text Hyphenation

• When text in a cell is hyphenated and it is set to wrap, changing the column width will ensure that the text is wrapped with the hyphens.

Language Packages

• 18 new language packages have been added to the calculation engine in SpreadJS. This includes localized function names and syntax for structured references for spreadsheets for specific languages. These languages include Chinese, Portuguese, and German.

Custom Localization

• With custom localization, displayed properties and words in the SpreadJS instance can be customized with specific languages. By default, the only languages in SpreadJS were English, Japanese, Chinese, and Korean, but this features gives developers control over what languages are shown.

Chart Symbol Enhancements

• Support for chart symbols has been added. This allows developers to choose the types of symbols that are displayed in place of the markers for charts like Line, Scatter, and Radar. The markers can be changed to things like Circles, Diamonds, Squares and Triangles:

3rd Party Library Support Enhancements

• Spread can be used with Angular, Vue, and React. Service Pack 2 adds more options when using Spread in these frameworks, allowing control over more features than was possible before.