New Features of ZK Spreadsheet 3.0.1"
m (correct highlight (via JWB)) |
|||
(14 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{Template:Smalltalk_Author| | ||
+ | |author= Hawk Chen | ||
+ | |date=February 18, 2014 | ||
+ | |version=ZK Spreadsheet 3.0.1 | ||
+ | }} | ||
+ | |||
+ | |||
= New Features= | = New Features= | ||
== Support Functions: LEFTB and REPLACEB == | == Support Functions: LEFTB and REPLACEB == | ||
− | The < | + | The <code>LEFTB</code> is a function that returns the first character(s) in a text string, based on the number of bytes you specify. |
− | The < | + | The <code>REPLACEB</code> replaces part of a text with another text depending on the number of bytes you specify. |
− | + | <code>LEFT</code> is designed for use with languages that use the single-byte character set (SBCS), whereas <code>LEFTB</code> is designed for use with the double-byte character set (DBCS). | |
+ | |||
+ | Usage demonstration: | ||
+ | [[File:zss-301-leftb.png | center]] | ||
<!-- | <!-- | ||
Line 12: | Line 22: | ||
== 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 try entering the 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 == | ||
+ | Now Spreadsheet can also run on Internet Explorer 11. | ||
+ | |||
+ | [[File:zss-301-ie11-support.png | center | 600px]] | ||
+ | |||
+ | <!-- | ||
ZSS-537 Spreadsheet supports Internet Explorer 11 | ZSS-537 Spreadsheet supports Internet Explorer 11 | ||
+ | --> | ||
+ | |||
+ | == Scroll the Screen Automatically When Selecting in Keyboard == | ||
+ | Since this version, when you select cells with shift and arrow key and move the border of visible area, Spreadsheet will auto scroll the visible area according to the arrow key you pressed. | ||
+ | |||
+ | For example, we select F18:J18 first. | ||
+ | [[File:zss-301-select.png | center]] | ||
+ | |||
+ | Then, we press the shift with down arrow key to select more cells (F18:J23), Spreadsheet will auto scroll the visible area according to our selection. | ||
+ | [[File:zss-301-scroll-selection.png | center]] | ||
+ | |||
+ | <!-- | ||
+ | ZSS-475 Select shift and down arrow, scroll the screen automaticallys | ||
+ | --> | ||
+ | |||
+ | |||
+ | = Upgrade Notes = | ||
+ | |||
+ | The fields in enumeration <javadoc directory="zss">org.zkoss.zss.api.model.Book.BookType</javadoc> are changed from <code>EXCEL_2003</code> and <code>EXCEL_2007</code> to <code>XLS</code> and <code>XLSX</code> respectively. | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | {{Template:CommentedSmalltalk_Footer_new| | ||
+ | |name=Potix Corporation | ||
+ | }} | ||
+ | |||
+ | <!-- | ||
== Ignore Row Break and Column Break Support When Exporting PDF == | == Ignore Row Break and Column Break Support When Exporting PDF == | ||
− | |||
− | + | When we export to PDF files, Spreadsheet will split pages according to page break setup of the Excel file. For example, an Excel file below has a row break. | |
− | + | ||
+ | [[File:zss-301-pageBreak-Excel.png | center | 400px]] | ||
+ | |||
+ | The file will be exported to 2 pages for the row break. | ||
+ | |||
+ | [[File:zss-301-export-break.png | center]] | ||
+ | |||
+ | |||
+ | But sometimes we want to ignore the page break. Now Spreadsheet has 2 more properties to ignore the page break. | ||
+ | |||
+ | <source lang='xml'> | ||
+ | <library-property> | ||
+ | <name>org.zkoss.zss.pdf.ignoreColumnBreak</name> | ||
+ | <value>true</value> | ||
+ | </library-property> | ||
+ | <library-property> | ||
+ | <name>org.zkoss.zss.pdf.ignoreRowBreak</name> | ||
+ | <value>true</value> | ||
+ | </library-property> | ||
+ | </source> | ||
+ | |||
+ | For the file above, if we set <code>org.zkoss.zss.pdf.ignoreRowBreak</code> to <code>true</code>, the exporting pages will not be separated by row break: | ||
+ | |||
+ | [[File:zss-301-ignore-rowbreak.png | center | 400px]] | ||
− | |||
− | + | ZSS-544 Support ignore row break and column break when export PDF | |
+ | --> |
Latest revision as of 04:21, 20 January 2022
Hawk Chen
February 18, 2014
ZK Spreadsheet 3.0.1
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.
LEFT
is designed for use with languages that use the single-byte character set (SBCS), whereas LEFTB
is designed for use with the double-byte character set (DBCS).
Usage demonstration:
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 try entering the formula again.
Support IE 11
Now Spreadsheet can also run on Internet Explorer 11.
Scroll the Screen Automatically When Selecting in Keyboard
Since this version, when you select cells with shift and arrow key and move the border of visible area, Spreadsheet will auto scroll the visible area according to the arrow key you pressed.
For example, we select F18:J18 first.
Then, we press the shift with down arrow key to select more cells (F18:J23), Spreadsheet will auto scroll the visible area according to our selection.
Upgrade Notes
The fields in enumeration Book.BookType are changed from EXCEL_2003
and EXCEL_2007
to XLS
and XLSX
respectively.
Comments
Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License. |