New Features of ZK Spreadsheet 3.0.1"

From Documentation
Line 2: Line 2:
  
 
== Support Functions: LEFTB and REPLACEB ==
 
== Support Functions: LEFTB and REPLACEB ==
  ZSS-511 LEFTB and REPLACEB return #NAME
+
The <tt>LEFTB()</tt> is a function that returns the first character(s) in a text string, based on the number of bytes you specify.
 +
The <tt>REPLACEB()</tt> replaces part of a text with another text depending on the number of bytes you specify.
  
 
== Retry Incorrect Formula ==
 
== Retry Incorrect Formula ==

Revision as of 07:33, 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.

Retry Incorrect Formula

 ZSS-527 Enter formula with bad syntax, would like "bad" formula to remain in cell

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.