New Features of ZK Spreadsheet 3.5.0

Author
Hawk Chen & Henri Chen

Date
July 07, 2014

Version
ZK Spreadsheet 3.5.0

New Features / Enhancements

Model Performance Enhancement

In this new version, we introduce a brand new model implementation. This enhancement doesn't change the way you use the Spreadsheet's public API mostly, but reduces Spreadsheet's memory consumption.

According to our tests which were done with a model operation of 500 rows and each row containing 10 numbers and 3 formulas, memory consumption was reduced to 1/3 of 3.0 under Java 1.6 and 1/6 under Java 1.7. These figures reflect big improvements with lower memory consumption saving you more money not only in an enterprise environment.

Customizable Theme

In this new version we have established a new theme mechanism that you can design your own theme with CSS and change it dynamically. Please see this article for details on how to do it. Also we have designed a new Skyline theme as the default theme for version 3.5. Of course, you can stick to previous classic theme if you like to with the provided classic.jar.

Localization of Number/Formula Input

In some country/region, people use ','(comma) instead of '.'(dot) as the decimal point for decimal numbers. This will enforce users to use ';'(semicolon) as the argument separator of formula functions. In previous version, we did not allow you to input numbers and formulas with your usual practice and now you can.

• Note that we have not been able to support localized formula function names yet.

Row/Column Style

In previous versions, when you apply a style on the entire row, Spreadsheet will create one style object for each visible cell of that row. Row / column style now create only one style object for the entire row (or column) which saves lots of memory.

Support Chart and Picture Operations for XLS Format

In previous versions, users are not able to move or delete charts and pictures because ZK Spreadsheet's old model for XLS files doesn't support it. However, with the new model now that it has no difference in design between XLS and XLSX, it now supports chart and picture operations for XLS files. Notice that this version still does not support exporting charts and pictures to XLS format but you can export them to a XLSX format file.

Upgrade Notes

Removed APIs

1. Book.getPoiBook(): you can't get any poi model object from this version, but you can get internal book model by getInternalBook().
2. Sheet.getPoiSheet(): get the internal sheet by getInternalSheet()
3. ChartData getPoiChartData(): get the internal chart data by getInternalChartData()

Changed APIs

1. SheetOperationUtil.addChart() : It will add a chart directly based on the selected data in the range. No need to pass a chart data object.
2. CellSelectionType is moved from org.zkoss.zss.ui.event to org.zkoss.zss.ui

Deprecated APIs

1. Range.SyncLevel and Range.setSyncLevel().
2. Book.getSync() : we use a new ReadWriteSync, you can get the lock by getLock()
3. CellStyle.getBackgroundColor(): use getFillColor()
4. EditableCellStyle.setBackgroundColor() : use setFillColor()
5. Exporter.export(Sheet sheet, OutputStream fos) and export(Sheet sheet,AreaRef selection,OutputStream fos): Use those subclasses of org.zkoss.zss.range.SExporterFactory. For example, to export an Excel XLSX format file, you can use new ExcelExportFactory(Type.XLSX).createExporter().export(SBook book, File file)

Comments

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.