New Features of ZK Spreadsheet 3.0.0"

From Documentation
m (correct highlight (via JWB))
 
(4 intermediate revisions by 2 users not shown)
Line 26: Line 26:
  
 
== Configurable Chart's Font ==
 
== Configurable Chart's Font ==
Sometimes default font might not display your language properly, Spreadsheet now allows you to specify fonts used in charts globally. There are 4 parts of a chart where you can specify its font: title, legend, x axis, and x axis tick. Each part has a corresponding library property that you can specify its font family, weight, and size in <tt>zk.xml</tt>.
+
Sometimes default font might not display your language properly, Spreadsheet now allows you to specify fonts used in charts globally. There are 3 parts of a chart where you can specify its font: title, legend, and x axis tick. Each part has a corresponding library property that you can specify its font family, weight, and size in <code>zk.xml</code>.
  
 
'''zk.xml'''
 
'''zk.xml'''
Line 40: Line 40:
 
== Configurable Color Picker ==
 
== Configurable Color Picker ==
  
Users can now set library property, <tt>org.zkoss.zss.useColorPickerEx</tt>, in <tt>zk.xml</tt> to specify which color picker to use in the whole application. This property only works under Spreadsheet EE. If it's <tt>true</tt>, Spreadsheet uses ColorPicker of EE, <tt>false</tt> it uses CE's ColorPicker.
+
Users can now set library property, <code>org.zkoss.zss.useColorPickerEx</code>, in <code>zk.xml</code> to specify which color picker to use in the whole application. This property only works under Spreadsheet EE. If it's <code>true</code>, Spreadsheet uses ColorPicker of EE, <code>false</code> it uses OSE's ColorPicker.
  
 
ColorPicker of EE:
 
ColorPicker of EE:
Line 57: Line 57:
 
</source>
 
</source>
  
For complete information, please refer to [[ZK Spreadsheet Essentials/Working_with_Spreadsheet/Configuration]].
+
For complete information, please refer to [[ZK Spreadsheet Essentials/Working_with_Spreadsheet/Configuration | Configuration]].
  
 
= API Change =
 
= API Change =
Line 64: Line 64:
  
  
== <tt>CellStyleApplier</tt> and <tt>FontStyleApplier</tt>==
+
== <code>CellStyleApplier</code> and <code>FontStyleApplier</code>==
The interface <javadoc directory='zss'>org.zkoss.zss.api.CellOperationUtil.CellStyleApplier</javadoc> was simplified and <tt>FontStyleApplier</tt> was removed and replaced by <tt>CellStyleApplier</tt> directly. If you still need the visit logic of this utility, please refer to [https://github.com/zkoss/zkspreadsheet/blob/e7b51d029fbc6462b1b071603531efb64b26b1c4/zss/src/org/zkoss/zss/api/CellOperationUtil.java original implementation at github].
+
The interface <javadoc directory='zss'>org.zkoss.zss.api.CellOperationUtil.CellStyleApplier</javadoc> was simplified and <code>FontStyleApplier</code> was removed and replaced by <code>CellStyleApplier</code> directly. If you still need the visit logic of this utility, please refer to [https://github.com/zkoss/zkspreadsheet/blob/e7b51d029fbc6462b1b071603531efb64b26b1c4/zss/src/org/zkoss/zss/api/CellOperationUtil.java original implementation at github].
 
 
  
  
 +
[[Category:New Features]]
 
{{Template:CommentedSmalltalk_Footer_new|
 
{{Template:CommentedSmalltalk_Footer_new|
 
|name=Potix Corporation
 
|name=Potix Corporation
 
}}
 
}}

Latest revision as of 04:20, 20 January 2022

DocumentationSmall Talks2013NovemberNew Features of ZK Spreadsheet 3.0.0
New Features of ZK Spreadsheet 3.0.0

Author
Hawk Chen
Date
November 5, 2013
Version
ZK Spreadsheet 3.0.0


Overview

ZK Spreadsheet is an AJAX component that delivers Excel-like experience to your browser. Version 3.0.0 contains several new features and various bug fixes.

New Features

Support Different Zoom Level

Spreadsheet now supports viewing in different zoom level. You can change zoom level within a browser according to your need.

The screenshot below is a Spreadsheet which is zoomed to 150%.

Zss-essentials-feature-zoom150.png

Override Built-in Functions

Since this version, you can create a custom function which has the same name as a built-in function (e.g. SUM, MAX) to override its implementation. To know how to create your own function, please refer to Custom Formula Functions.

Displaying Chart/Picture in Freeze Panel

Since 3.0.0, Spreadsheet can display a chart (or a picture) inside a frozen area.

Configurable Chart's Font

Sometimes default font might not display your language properly, Spreadsheet now allows you to specify fonts used in charts globally. There are 3 parts of a chart where you can specify its font: title, legend, and x axis tick. Each part has a corresponding library property that you can specify its font family, weight, and size in zk.xml.

zk.xml

<library-property>
	<name>org.zkoss.zss.chart.title.font</name>
	<value>sansserif, italic, 30</value>
</library-property>

For complete information, please refer to Configuration.

Configurable Color Picker

Users can now set library property, org.zkoss.zss.useColorPickerEx, in zk.xml to specify which color picker to use in the whole application. This property only works under Spreadsheet EE. If it's true, Spreadsheet uses ColorPicker of EE, false it uses OSE's ColorPicker.

ColorPicker of EE:

Zss-essentials-configuration-colorPickerEE.png

ColorPicker of OSE:

Zss-essentials-configuration-colorPickerCE.png


Example in zk.xml

<library-property>
	<name>org.zkoss.zss.colorPickerExUsed</name>
	<value>false</value>
</library-property>

For complete information, please refer to Configuration.

API Change

Based on ZK Spreadsheet version 3.0.0 RC, there's only one minor API change in this version, please refer to the following:


CellStyleApplier and FontStyleApplier

The interface CellOperationUtil.CellStyleApplier was simplified and FontStyleApplier was removed and replaced by CellStyleApplier directly. If you still need the visit logic of this utility, please refer to original implementation at github.

Comments



Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.