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
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:
- 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.
- If you use a customized function only supported in Keikai spreadsheet in a formula, the cached result is always
#NAME!
error. Application developers must enforce re-evaluation byRange.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>
Add Extra Font Family
since 5.3.0
Default: none
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
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