Configuration

Overview

The library properties below allow you to configure spreadsheet’s behaviors. There are other properties for underlying ZK framework, please refer to ZK Configuration Reference.

Chart’s Font

For default font might not display your language properly, Spreadsheet allows you to specify fonts used in charts. There are 3 parts of a chart you can specify its font: title, legend, 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

1
2
3
4
<library-property>
    <name>io.keikai.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

io.keikai.chart.title.font

title font

io.keikai.chart.legend.font

legend font

io.keikai.chart.xAxisTick.font

x axis tick font

Value’s format:

1
[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, io.keikai.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:
center

ColorPicker of OSE (fewer color choices):
center

Example in zk.xml

1
2
3
4
<library-property>
    <name>io.keikai.colorPickerExUsed</name>
    <value>false</value>
</library-property>
  • The configuration above will make Spreadsheet use Color Picker of CE.

Example in zk.xml

1
2
3
4
<library-property>
    <name>io.keikai.theme.preferred</name>
    <value>classic</value>
</library-property>

Importing Formula Cache

Default value: false

Set the property to true and Keikai will import formula cache of an Excel file and it can reduce the file loading time because Keikai doesn’t need to re-evaluate formulas at loading.

1
2
3
4
<library-property>
    <name>io.keikai.import.cache</name>
    <value>true</value> <!-- turn the import cache on; default is false if not specified -->
</library-property>

Few points need to be noticed:

  1. If some functions not yet supported by Keikai spreadsheet are used in a formula, re-evaluation breaks the cached value even if precedent cells do not change.
  2. If some customized function only supported in Keikai spreadsheet are used in a formula, a cache is always #NAME! error. Users must enforce re-evaluation by calling Range.refresh(true, true, true).

Keep Cell Selection

Default value: true

Set the property to false and Keikai will set default value of keepCellSelection attribute to false. In older versions, when Keikai Spreadsheet component loses its focus, it will hide the cell selection mark automatically. However, sometimes an end user would need to know which range is selected when he/she is operating on another control component (e.g. a dialog window). We have set the default value of keepCellSelection to true to avoid the confusion. However, if you would like Keikai to behave as before, you can set this property to false.

1
2
3
4
<library-property>
    <name>io.keikai.ui.keepCellSelection</name>
    <value>false</value> <!-- turn the keep-cell-selection off; default is true if not specified -->
</library-property>

Comments