New Features of ZK Spreadsheet 3.0.1"
From Documentation
| Line 4: | Line 4: | ||
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>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. | The <tt>REPLACEB()</tt> replaces part of a text with another text depending on the number of bytes you specify. | ||
| + | |||
| + | The result of <tt>=LEFTB("台灣台北",4)</tt> is <tt>台灣</tt>. | ||
<!-- | <!-- | ||
Revision as of 08:13, 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
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.