New Features of ZK Spreadsheet 3.0.1"
From Documentation
| Line 12: | Line 12: | ||
== Retry Incorrect Formula == | == 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. | ||
| + | [[File:zss-301-retry-formula.png | center]] | ||
| + | <!-- | ||
ZSS-527 Enter formula with bad syntax, would like "bad" formula to remain in cell | ZSS-527 Enter formula with bad syntax, would like "bad" formula to remain in cell | ||
| + | --> | ||
== Support IE 11 == | == Support IE 11 == | ||
Revision as of 08:37, 10 February 2014
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.
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.