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.

Scope

You can configure a property to apply at various scopes, please read ZK Configuration Reference.

Formula Cache

Importing

Default: false

Applicable Scope:
globally in zk.xml via <library-property>
nested in a zul file via <custom-attributes>

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

Applicable Scope:
globally in zk.xml via <library-property>
nested in a zul file via <custom-attributes>

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

Applicable Scope:
globally in zk.xml via <library-property>
nested in a zul file via <custom-attributes>

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>

Add Extra Font Family

since 5.3.0

Default: none

Applicable Scope:
globally in zk.xml via <library-property>
nested in a zul file via <custom-attributes>

You can add more fonts in font family drop-down of the toolbar by the property:

<library-property>
    <name>io.keikai.ui.Spreadsheet.customFontFamily</name>
    <value>Roboto, Helvetica Neue</value>
</library-property>

Keikai will appends the specified fonts in the drop-down list.

Show a Blank Cell as a Gap or Zero

since 5.3.0

Default: false

Applicable Scope:
globally in zk.xml via <library-property>
nested in a zul file via <custom-attributes>

When a chart’s data source contains a blank cell, you can configure it to display it as a gap or zero.

<library-property>
    <name>io.keikai.chart.emptyAsGaps</name>
    <value>true</value>
</library-property>

Comments