ZK Spreadsheet Essentials/Working with Spreadsheet/Configuration

Overview

Here we list all available configurations of Spreadsheet.

Chart's Font

For default font might not display your language properly, Spreadsheet allows you to specify fonts used in charts. There are 4 parts of a chart 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 name, style, and size in zk.xml. Once you put the configuration, it affects to all charts of the whole application.

Example configuration in zk.xml

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

• The above configuration sets title font to italic SansSerif with size 30.

Available property names:

Name	Which font in chart
org.zkoss.zss.chart.title.font	title font
org.zkoss.zss.chart.legend.font	legend font
org.zkoss.zss.chart.xAxis.font	x axis font
org.zkoss.zss.chart.xAxisTick.font	x axis tick font

Value's format:

[NAME], [STYLE], [SIZE]

• [NAME] : Those font names your system supports.
• [STYLE] : plain, bold, italic
• If you specify a incorrect format in the property value, the property will be ignored.

Color Picker

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

ColorPicker of EE:

ColorPicker of OSE (fewer color choices):

Example in zk.xml

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

• The configuration above will make Spreadsheet use Color Picker of CE.

All source code listed in this book is at Github.