New Features of ZK Spreadsheet 3.0.1

From Documentation

New Features

Support Functions: LEFTB and REPLACEB

The LEFTB() is a function that returns the first character(s) in a text string, based on the number of bytes you specify. The REPLACEB() replaces part of a text with another text depending on the number of bytes you specify.

The result of =LEFTB("台灣台北",4) is 台灣.


Retry Incorrect Formula

Since this version, if users enter an incorrect formula, Spreadsheet will popup a warning message. After you close it, Spreadsheet will allow you to retry entering formula again.

Zss-301-retry-formula.png

Support IE 11

 ZSS-537 Spreadsheet supports Internet Explorer 11

Ignore Row Break and Column Break Support When Exporting PDF

 ZSS-544 Support ignore row break and column break when export PDF

Scroll the Screen Automatically When Selecting in Keyboard

 ZSS-475 Select shift and down arrow, scroll the screen automatically

Upgrade Notes

Members of BookType of Book are changed from EXCEL_2003,EXCEL_2007 to XLS,XLSX because of Spreadsheet depends on file format not Excel version.
Retrieved from "https://www.zkoss.org/_w/index.php?title=Small_Talks/2014/February/New_Features_of_ZK_Spreadsheet_3.0.1&oldid=41001"