New Features of ZK Spreadsheet 3.5.0-RC"
m (Created page with "{{Template:Smalltalk_Author| |author= Hawk Chen |date=April 01, 2014 |version=ZK Spreadsheet 3.5.0 RC }} = New Features / Enhancements = == Model Performance Enhancement == I...") |
m (correct highlight (via JWB)) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 9: | Line 9: | ||
== Model Performance Enhancement == | == 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 | + | 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 <b>reduces Spreadsheet's memory consumption</b>. |
− | |||
− | |||
+ | 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. | ||
== Row/Column Style == | == Row/Column Style == | ||
Line 28: | Line 27: | ||
== Removed APIs == | == Removed APIs == | ||
− | # < | + | # <code>Book.getPoiBook()</code>: you can't get any poi model object from this version, but you can get internal book model by <code>getInternalBook()</code>. |
− | # < | + | # <code>Sheet.getPoiSheet()</code>: get the internal sheet by <code>getInternalSheet()</code> |
− | # < | + | # <code>ChartData getPoiChartData()</code>: get the internal chart data by <code>getInternalChartData()</code> |
== Changed APIs == | == Changed APIs == | ||
− | # < | + | # <code>SheetOperationUtil.addChart() </code>: It will add a chart directly based on the selected data in the range. No need to pass a chart data object. |
− | # < | + | # <code>CellSelectionType</code> is moved from <code>org.zkoss.zss.ui.event</code> to <code>org.zkoss.zss.ui</code> |
== Deprecated APIs == | == Deprecated APIs == | ||
− | # < | + | # <code>Range.SyncLevel</code> and <code>Range.setSyncLevel()</code>. |
− | # < | + | # <code>Book.getSync()</code> : we use a new <code>ReadWriteSync</code>, you can get the lock by <code>getLock()</code> |
− | # < | + | # <code>CellStyle.getBackgroundColor()</code>: use <code>getFillColor()</code> |
− | # < | + | # <code>EditableCellStyle.setBackgroundColor()</code> : use <code>setFillColor()</code> |
− | # < | + | # <code>Exporter.export(Sheet sheet, OutputStream fos)</code> and <code>export(Sheet sheet,AreaRef selection,OutputStream fos)</code>: Use those subclasses of <code>org.zkoss.zss.range.SExporterFactory</code>. For example, to export an Excel XLSX format file, you can use <code>new ExcelExportFactory(Type.XLSX).createExporter().export(SBook book, File file)</code> |
Latest revision as of 04:20, 20 January 2022
Hawk Chen
April 01, 2014
ZK Spreadsheet 3.5.0 RC
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.
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 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
Book.getPoiBook()
: you can't get any poi model object from this version, but you can get internal book model bygetInternalBook()
.Sheet.getPoiSheet()
: get the internal sheet bygetInternalSheet()
ChartData getPoiChartData()
: get the internal chart data bygetInternalChartData()
Changed APIs
SheetOperationUtil.addChart()
: It will add a chart directly based on the selected data in the range. No need to pass a chart data object.CellSelectionType
is moved fromorg.zkoss.zss.ui.event
toorg.zkoss.zss.ui
Deprecated APIs
Range.SyncLevel
andRange.setSyncLevel()
.Book.getSync()
: we use a newReadWriteSync
, you can get the lock bygetLock()
CellStyle.getBackgroundColor()
: usegetFillColor()
EditableCellStyle.setBackgroundColor()
: usesetFillColor()
Exporter.export(Sheet sheet, OutputStream fos)
andexport(Sheet sheet,AreaRef selection,OutputStream fos)
: Use those subclasses oforg.zkoss.zss.range.SExporterFactory
. For example, to export an Excel XLSX format file, you can usenew ExcelExportFactory(Type.XLSX).createExporter().export(SBook book, File file)
Comments
Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License. |