Configuration

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.

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.

Formula Cache

Importing

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.

<library-property>
    <name>io.keikai.import.cache</name>
    <value>true</value>
</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).

Exporting

Default value: false

Set the property to true and Keikai will export the formula cache into an Excel file.

<library-property>
    <name>io.keikai.export.cache</name>
    <value>true</value> 
</library-property>

Keep Cell Selection

Default value: true

If it’s true, when a dialog pops popup (Keikai loses its focus), Keikai still display cell selection box. Because sometimes an end user would like to know which range is selected when he/she is operating on a popup dialog.

If it’s false, then Keikai will hide cell selection.

<library-property>
    <name>io.keikai.ui.keepCellSelection</name>
    <value>false</value>
</library-property>

Comments