/
release-note
1236 lines (1154 loc) · 67.7 KB
/
release-note
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
ZK Spreadsheet 3.5.0
*Features:
ZSS-651 Need to enhance performance for partial evaluation
ZSS-665 Smart number input handling
ZSS-666 Smart number "General" formatting
ZSS-576 Support Excel "Protect Sheet" allowed actions
ZSS-565 Support input with Swedish locale into formula
ZSS-685 Do not import duplicate cell style
ZSS-684 Auto expand editing area's width when editing cell
ZSS-678 Support creating reference between two sheets
ZSS-691 Support calculation in Excel's double precision
ZSS-459 VALUE function support smart input format
ZSS-702 Fine tune DataValidation to hold multiple regions
ZSS-708 Support theme customization
ZSS-703 Allow user to use use their own PivotTableHelper implementation
ZSS-713 Make a modern design theme as default
*Bugs:
ZSS-652 Cut Formula shouldn't be shifted when it is not in cut range
ZSS-655 Formula that contains Name doesn't update
ZSS-654 if I directly right click on different cell in IE 8 and 9, the context menu often close automatically
ZSS-644 Fail to export to XLSX format when the book has a hyperlink with invalid URI
ZSS-645 Fail to export to XLS format when the book has a named range referring to an external book
ZSS-294 cannot create a named range
ZSS-658 Right click on cell only show style menupopup
ZSS-661 Formula is incorrect after rename Name or it's refersTo region.
ZSS-641 Desktop not found if I submit the form.
ZSS-662 Paste large text into a cell, visible area of the worksheet moves to the left
ZSS-672 Input #NAME? shall be deemed as an Error value
ZSS-656 Copy-paste from clipboard to ZSS not working for Mac OS
ZSS-674 Edit a cell but do not leave, hit save, changes not saved
ZSS-670 A dot is replaced with colon in a formula causes exported Excel file corruption under German (Polish) locale
ZSS-562 IllegalArgumentException showed when referencing a Spring bean that contains List type properties
ZSS-664 page down/up move by page size, not 100 rows
ZSS-679 Edit objects option in sheet protection is inconsistent when save to excel
ZSS-680 ZSS App always save to xlsx format.
ZSS-677 AbstractExcelImporter doesn't reuse imported font
ZSS-683 Enter formula with bad syntax, would cause infinite error message window
ZSS-661 Formula is incorrect after rename Name or it's refersTo region.
ZSS-649 After delete row, NameRange doesn't update
ZSS-687 Formula that refer to a NameRange does not update contents correctly
ZSS-514 if the font size is larger than 24, the text will overlap each other when using inline editor
ZSS-609 The input text box doesn't disappear when rename sheet bar with empty name and click another sheet
ZSS-648 Validation position doesn't shift up when delete rows shift up
ZSS-681 Open context menu and press tab, the upper style panel should close
ZSS-692 Label may be mismatched in ClearCellHandler class
ZSS-693 Sorting should shift formula accordingly
ZSS-694 The Validation of a Cell should be pasted to the new range accordingly.
ZSS-696 Cut a single cell and Paste to a merged cell should unmerge the merged cell and paste to the left-top cell of the original merged cell
ZSS-675 Context menu does not close when left click inside the selection
ZSS-646 Apply filter incorrectly when contained merged cells
ZSS-704 Add one more value in the bottom cell of an autofilter column, press button does not list the new value
ZSS-705 Failed on handle the case when merged cells are in the top row of AutoFilter
ZSS-556 Scroll then change sheet, make autofilter disappear
ZSS-706 Open context menu, click between style popup and menu popop, the style popup does not close
ZSS-555 Insert a row on the row with autofilter cause double autofilter
ZSS-707 The sorting order of AutoFilter dropdown is not correct.
ZSS-689 Edit cell formula and use mouse to select a merged cell, it will insert range
ZSS-579 Undo doesn't notify toolbar button to change status
ZSS-632 mailto link should not appear in web address textbox in "Insert Hyperlink" dialog
ZSS-578 Insert a picture at Range(0,0) and drag it left or top will cause null pointer exception
ZSS-699 Crash with medium xlsx file
** Upgrade Notes
* Following api are deprecated
* Range.protectSheet(String password): Use the new
Range.protectSheet(String password,
boolean allowSelectingLockedCells, boolean allowSelectingUnlockedCells,
boolean allowFormattingCells, boolean allowFormattingColumns, boolean allowFormattingRows,
boolean allowInsertColumns, boolean allowInsertRows, boolean allowInsertingHyperlinks,
boolean allowDeletingColumns, boolean allowDeletingRows,
boolean allowSorting, boolean allowFiltering, boolean allowUsingPivotTables,
boolean drawingObjects, boolean scenarios)
API instead to protect the sheet with more protection options; use the new
Range.unprotectSheet(String password) to unprotect the sheet; use the new
Range.getSheetProtection() to tell the current protection options.
* Customized theme can be registered using SpreadsheetThemes.register(themeName, displayName, priority)
API. The user could switch to any registered themes by setting 'zsstheme=default' in cookie or
library property:
<library-property>
<name>org.zkoss.zss.theme.preferred</name>
<value>default</value>
</library-property>
------------
ZK Spreadsheet 3.5.0 RC
*Features:
ZSS-606 Support to handle multiple-area formula
ZSS-623 Support handling row/column style
ZSS-634 Support chart and picture operation for XLS format
*Bugs:
ZSS-350 When using cell validation with cell list, the drop-down list won't update after the referred cells changed
ZSS-581 Formula lost to update after rename 2 sheet
ZSS-583 NullPointerException when the sheet has hyperlinks with empty URL
ZSS-582 Can't display chart after rename the sheet name to dot(.)
ZSS-587 wrong gridline display after delete column
ZSS-588 get exception when import xls
ZSS-590 Chart shows to another sheet after delete sheet
ZSS-591 Get console exception after delete sheet
ZSS-593 Spreadsheet doesn't be released immediately after close tab in collaboration
ZSS-594 wrong display when insert/delete row/column in freeze column/row panel
ZSS-596 Possible memory leak when formula evaluation
ZSS-598 Cell doesn't display correctly
ZSS-585 Java SE 5 Compliance
ZSS-577 Can't display chart correctly
ZSS-601 Once I use right click context menu on sheet bar, it will never work again
ZSS-605 Spreadsheet doesn't fit in screen with hflex, vflex is 1 and show scroll bar
ZSS-602 Horizontal alignment dropdown in context menu doesn't show any items after one click on it
ZSS-603 Color dropdown in context menu displays incorrectly after I click it one time
ZSS-604 After change cell alignment twice times will cause right click event doesn't show context menu
ZSS-610 Can't get correct book type.
ZSS-613 Duplicated Event-Queue Event when set sharescope to application
ZSS-618 Bad performance when setting hug among of data in collaboration mode
ZSS-619 Wrong evaluation result after insert/delete
ZSS-620 Large response data when update a big region with same style
ZSS-600 First time right click shows empty context menu
ZSS-589 Hidden rows are still displayed in IE
ZSS-617 After spreadsheet loads a book, a mask is blocking the sheet
ZSS-612 Cannot sort files name value in ZSS app "Open Book Dialog"
ZSS-616 Selection box is displayed at wrong position
ZSS-592 Insert row/column on freeze panel with Range API is a illegal operation but doesn't get any information from server and cause js error
ZSS-595 Perform insert row operation on rows cover freezed row and non-freezed row will cause js error
ZSS-608 Copy a single cell to a merge cell cause unexpected result
ZSS-622 Spreadsheet toolbar function not work correctly if creating the instance at runtime
ZSS-626 Formula result is not correct after insert/delete cells
ZSS-627 Paste format doesn't work
ZSS-633 Importer doesn't import custom column width for XLS format
ZSS-635 Set row height or column width with empty value will cause NPE
ZSS-636 Insert a chart with all blank cells, but the chart contains value
ZSS-639 a formula refer to one cell at other sheet with freeze panel. change the refered cell cause JS error
ZSS-640 cells with formula in freeze panels didn't be update after changing refered cells
ZSS-637 Cannot export XLS format
ZSS-631 Cannot drag fill with merge cell
ZSS-643 Wrong cell value and display after undo
ZSS-642 Spreadsheet throws an exception when exporting PDF with charts
ZSS-630 when setting font style via context menu, first click doesn't work
ZSS-586 Select all then insert row cause javascript error (insert column work fines)
ZSS-553 "clear style" and "clear all" can unmerge cells, but undo can't merge them back
ZSS-481 Undo doesn't work correctly when delete a row with merged cell
** Upgrade Notes
* Following api are removed
* Book.getPoiBook() : you can't get any poi model object from this verion, instead of you get internal book model by getInternalBook()
* Sheet.getPoiSheet() : get the internal sheet by getInternalSheet()
* ChartData getPoiChartData() : get the internal chart data by getInternalChartData();
* Following api are changed
* addChart() : It will add the chart directly from the selected area/data in the range
* CellSelectionType is moved from org.zkoss.zss.ui.event to org.zkoss.zss.ui
* Following api are deprecated
* Range.SyncLevel and Range.setSyncLevel() : It is always synchronized on Book by a read-write lock.
* Book.getSync() : we use a new ReadWriteSync, you can get the lock by getLock()
* CellStyle.getBackgroundColor() : use getFillColor()
* EditableCellStyle.setBackgroundColor : use setFillColor()
* Exporter.export(Sheet sheet, OutputStream fos) and export(Sheet sheet,AreaRef selection,OutputStream fos)
------------
ZK Spreadsheet 3.0.2
*Features:
*Bugs:
ZSS-541 date autofill timestamp is incorrect
ZSS-547 Sheet index (31) is out of range (0..30) error when deleting sheets in a workbook
ZSS-569 Range.notifyChange can't update formula value
ZSS-593 Spreadsheet doesn't be released immediately after close tab in collaboration
ZSS-596 Possible memory leak when formula evaluation
ZSS-585 Java SE 5 Compliance
ZSS-589 Hidden rows are still displayed in IE
ZSS-617 After spreadsheet loads a book, a mask is blocking the sheet
ZSS-612 Cannot sort files name value in ZSS app "Open Book Dialog"
ZSS-616 Selection box is displayed at wrong position
ZSS-622 Spreadsheet toolbar function not work correctly if creating the instance at runtime
ZSS-621 Delete the cell with a shared formula and export, spreadsheet cannot load the file back correctly
ZSS-624 Copy a row on top of itself, get an error
** Upgrade Notes
------------
ZK Spreadsheet 3.0.1
*Features:
ZSS-511 LEFTB and REPLACEB return #NAME
ZSS-527 Enter formula with bad syntax, would like "bad" formula to remain in cell
ZSS-537 Spreadsheet supports Internet Explorer 11
ZSS-544 Support ignore row break and column break when export PDF
ZSS-475 Select shift and down arrow, scroll the screen automatically
*Bugs:
ZSS-510 ApplyDataFormat with "" then getCellFormatText from range will cause IndexOutOfBoundaryException and spreadsheet crash.
ZSS-515 Delete freeze row then insert a row causes javascript exception
ZSS-509 Protecting only selected rows or columns protect ALL empty cells
ZSS-519 Do not display background color of empty cells
ZSS-524 After change chart font library setting, the chart without title throws NPE.
ZSS-517 Apply background works strangely
ZSS-523 misleading error message for text formulas
ZSS-520 Rapid typing causes error in spreadsheet
ZSS-512 when performing "clear style" on merged range can unmerge it, but "clear all" doesn't
ZSS-538 Ctrl+u doesn't apply underline to a cell
ZSS-534 font size not displayed properly in toolbar
ZSS-536 Type on a cell something get empty result
ZSS-533 formula's function with non-existed name should be resolved to #NAME? and an name be created in file
ZSS-513 inline editor is at wrong position when re-edit cell with validation
ZSS-205 scroll bar in function bar is not persistent
ZSS-528 Unwrapping text in a cell does not resize cell
ZSS-561 Closing a book than open a book, the cell will become chaos when using IE 10 and IE 11
** Upgrade Notes
* Members of BookType of Book are changed from EXCEL_2003,EXCEL_2007 to XLS,XLSX because of Spreadsheet depends on file format not Excel version.
------------
ZK Spreadsheet 3.0.0
*Features:
ZSS-438 Support view with different zoom level
ZSS-251 Support to override the default formula implementation
ZSS-10 Support to display chart/picture in freeze panel
ZSS-463 support configurable font color popup
*Bugs:
ZSS-399 export to PDF - no gridlines
ZSS-420 Cannot focus on cell when set rowfreeze="0" or columnfreeze="0"
ZSS-421 Cannot open inline editor when use rowfreeze or columnfreeze
ZSS-439 Delete rows cause XmlValueDisconnectedException
ZSS-392 Freezing panes with preload attribute cause cell data not render
ZSS-423 JS error when rowfreeze > preloadRowSize or columnfreeze > preloadColumnSize
ZSS-376 throw exception when drawing unsupported chart in xls format
ZSS-369 throw exception when rendering line chart with non-contiguous series data in xls format
ZSS-412 Cell layout crash after cut overlap on merge cell after undo
ZSS-433 adjust column width and javascript errors showed
ZSS-432 after insert new sheet and export it, then input some data into this new sheet and export again. such file can't load by ZSS and Excel
ZSS-431 if freeze the specific xlsx file and export it, its freeze position is wrong in Excel
ZSS-418 if two or more cell with comment in a row and shift them, the exported file will make Excel occur error when loading
ZSS-378 ZK spreadsheet selected cell can type in English but can not input Chinese
ZSS-434 insert,delete whole column or row when overlap merge cell will cause unexpect result
ZSS-446 border patterns around a cell it is not showing in the exported pdf file
ZSS-219 Problem with org.zkoss.zss.ui.Spreadsheet.focusTo
ZSS-447 Date format and display doesn't match
ZSS-214 NPE when I try to rename sheet
ZSS-256 hidden column is not hiding when displaying a excel file
ZSS-313 after several switching sheets and resize row height, cells frame become a mess
ZSS-272 when spreadsheet displays an Excel 2003 file that contains "conditional formatting" setting, it crashed and cannot render anything
ZSS-428 occur exception when switching sheet with specific xlsx file
ZSS-440 IE10 resizing column (java.lang.Double cannot be cast to java.lang.Integer)
ZSS-441 Wrong sum results
ZSS-404 JS Error after insert column when freeze
ZSS-443 change width of columns in corner freeze panel will cause Javascript exception
ZSS-449 Freeze panels and change row/column size, then switch to other sheet and back, freeze panel's headers will be chaos.
ZSS-233 hyperlink event doesn't work
ZSS-348 onHyperlink event of Spreadsheet isn't fired
ZSS-400 Hyperlink doesn't be shift after insert or delete
ZSS-451 delete one column at most right and bottom position and scroll up will cause JavaScript exception
ZSS-242 set max rows dynamically doesn't work
ZSS-270 error evaluating some statistical formulas
ZSS-271 evaluation result of some engineering formulas are slightly different from expected
ZSS-453 NullPointerException when the sheet has hyperlinks with empty URL
ZSS-455 Chart/Image doesn't move location after change column/row width/height
ZSS-312 A picture (or chart) should not be allowed to move out of the cell area's top and bottom border
ZSS-458 Strange behavior when re-sizing North or West of chart/image in scrolling
ZSS-311 When you move a chart, it should become selected
ZSS-452 Inserting a row at non-selected sheet with API doesn't work
ZSS-252 A Javascript error thrown when right clicking spreadsheet without showing toolbar
ZSS-280 reapply autofilter doesn't filter newly added the data
ZSS-299 after applying 2nd filter, the second one should only contain non-filtered data for selection
ZSS-450 After scrolling down to bottom of sheet quickly, insert a row on a row with data and delete a row, the last row's cells will have data and same as selected row
ZSS-456 hasMergedCell API doesn't work correctly
ZSS-454 Cannot click on hyperlink in the merge cell.
ZSS-231 get wrong row,column in onCellClick if I click on merged cells
ZSS-222 AutoFitler doesn't work correctly when selecting have some empty cell
ZSS-427 occur exception when exporting specific xlsx file to PDF
ZSS-330 hide merged cell's left-top column/row will cause text disappear
ZSS-382 If hide columns and overlap partial merged cell, cells' alignment will be chaos
ZSS-448 Filter popup menu is scrolled if setFreezePanel() and unfrozen region is also scrolled
ZSS-461 Get exception when evaluating hyperlink after export & clear cell
ZSS-322 Cannot remove a hyperlink
ZSS-457 Insert a hyperlink on a cell with empty hyperlink doesn't work as expected
ZSS-296 "Protect Sheet" doesn't prevents cells from using auto filter
ZSS-202 Cannot display chart title correctly
ZSS-416 No all border color could apply to cell in 2003
ZSS-379 The cell's has weird text when using time format in Chinese environment
ZSS-370 Click cell multiple times, cell turn into gray and cannot edit the cell
ZSS-380 When input wrong formula, the formula bar will change to below cell and "Enter" key can't blur it
ZSS-464 Other styles are changed (background color, font size) when just changing cell border
ZSS-288 email address, https://, ftp:// don't convert to a hyperlink automatically
ZSS-472 Formula result doesn't change after named-range updated
ZSS-470 "Blanks" in Autofilter drop-down list never shows checked
ZSS-471 Multiple filters doesn't work correctly
ZSS-473 get exception if renamed sheet contains '(' or ')'
ZSS-468 The color picker in context(popup) menu disappeared if didn't select any color and re-open context menu
ZSS-462 Can't copy all selected cells to other application when using Chrome
ZSS-479 Missing left border color when copying a cell
ZSS-482 Rename sheet with character "." on specific Excel file will cause exception
ZSS-477 Set outline border around a merged cell doesn't get correct result
ZSS-485 Paste multiple rows and their order is different from original rows
ZSS-488 After undoing a deleted column under frozen rows, gridline is in disorder
ZSS-483 Toolbar button's status doesn't update after switching sheets
ZSS-490 move a sheet with chart causes an exception
ZSS-476 Image width becomes very small after exporting
ZSS-492 If reorder a sheet and modify a cell on it, the value of formula referred to such cell will be incorrect.
ZSS-230 js loading dependence is not correct
ZSS-232 onCellClick doesn't fire again if the cell has focus
ZSS-234 No way to cancel copy highlight rect
ZSS-249 Overflow not work correctly
ZSS-250 Doesn't handle well if I delete the sheet from outside button
ZSS-495 Can't get correct edit text if set a cell value by Date
ZSS-497 Get wrong cell format text after click reset in jsf/jsp demo
ZSS-496 Opening "Insert Picture" dialog twice causes whole Spreadsheet disabled
ZSS-225 protect sheet icon doesn't display correctly if no sheetBar
ZSS-494 If using xls format and reorder sheet, the sheet reference in formulas will be modified
ZSS-491 change column width and JS errors show
ZSS-498 Formula Edit throws RunTimeException
ZSS-501 Click check mark of formula bar after entering a value, all cells become unable to edit
ZSS-499 Insert rows above cells where the chart header references will cause NPE
ZSS-506 After deleting a sheet, the charts which reference the deleted sheet cause an exception
ZSS-505 delete the last sheet, chart on another sheet show in the last sheet.
ZSS-500 After hiding a row contained overflow cells, the hidden row's cell text is still shown and overlap
ZSS-504 hide all column and all row only can recover by undo (not by drag UI)
** Upgrade Notes
* For the fix of ZSS-464, interface of CellStyleApplier(of CellOperationUtil) was simplified and FontStyleApplier was removed (replace by CellStyleApplier directly). If you still need the visit logic of this utility, please refer to original implementation at github (https://github.com/zkoss/zkspreadsheet/blob/e7b51d029fbc6462b1b071603531efb64b26b1c4/zss/src/org/zkoss/zss/api/CellOperationUtil.java).
------------
ZK Spreadsheet 3.0.0 RC
*Features:
ZSS-338 When share book, could the friend focus shows user name of another editor
ZSS-353 Support head tag in JSP/JSF
ZSS-388 Support to freeze row of column of sheet
ZSS-394 Support undo/redo of cell operation
ZSS-396 provide an API to cut and paste cells at once
*Bugs:
ZSS-224 text overflow doesn't work correctly
ZSS-268 get exception if I listen to onValidateDrop
ZSS-304 hiding columns doesn't work
ZSS-229 Only the last picture can be moved
ZSS-325 Cannot copy an area of cells from Excel to Spreadsheet
ZSS-275 Range.getRow() return unexpected row number
ZSS-327 server-side paste data will be replaced by client-side paste
ZSS-310 Rename a sheet to its original should not show up a error message
ZSS-292 left click row header (or column header) appears context menu
ZSS-324 Hiding all columns causes non-stopping AU and columns cannot be unhided
ZSS-291 sorting a group of number with style causes null pointer exception
ZSS-333 Preload bug
ZSS-332 Chart was moved if I move another chart in different book in different spareadsheet in same desktop
ZSS-334 A book can't reset to another book-series
ZSS-335 When share book, the friend focus color was always change when I switch tab
ZSS-343 ActiveRangeHelper caches sheet object and doesn't release after reload a book
ZSS-308 when renaming a sheet, if you click another sheet, the original sheet won't be renamed
ZSS-255 "data validation" setting causes null pointer exception
ZSS-351 The validation dialog can't press "yes" button to force input a invalid text when using list validation
ZSS-254 some "accounting" data format causes NullPointerException
ZSS-352 Can't set share scope of a book if it is not in zk execution.
ZSS-317 When importing a xlsx file with images exported from Spreadsheet 2nd time, an exception is thrown
ZSS-246 Exception when toggle auto filter
ZSS-259 merges cells have missing bottom border when displaying a excel file
ZSS-245 Exception when delete columns
ZSS-326 Insert a chart after deleting first chart causes an exception
ZSS-349 When adding a chart, if selected cells contains errors, spreadsheet throw a runtime exception
ZSS-367 Attribute "ctrlKeys" doesn't work
ZSS-257 unsupported charts cause spreadsheet crash
ZSS-140 Sheet with XYModel chart throw NullPointerException (xls format)
ZSS-137 Sheet with chart throw NullPointerException (xls format)
ZSS-300 When pasting range overlaps copying range, pasting works incorrectly
ZSS-113 delete sheet's chart cause NPE, xls format only
ZSS-286 Focused Cell is getting completely white in IE10
ZSS-383 In IE browser, pop-up format dialog (right click on cell) can't be operated.
ZSS-302 some rows can only be deleted with twice deletion
ZSS-260 Data validation doesn't work correctly
ZSS-387 get js error when resize row height with row freeze
ZSS-315 paste a text on a merged cell will make the cell unmerged
ZSS-277 paste a horizontal merged cell in transpose doesn't become a vertical merged cell
ZSS-390 browser took long time without response if I use freeze panel when select whole row or whole column
ZSS-389 Shift cell up doesn't work correctly
ZSS-386 Inserting a picture after deleting first picture causes an exception
ZSS-331 select all cell has poor performance even not many cells
ZSS-391 Filter popup menu is hidden by freeze column
ZSS-354 delete the first column of merged cell and alignment of cells will be chaos
ZSS-393 Sheet out of sync after cut to different sheet
ZSS-290 after merging and unmerging cells, input and style both work incorrect
ZSS-395 Unmerge cell operation doesn't work when the selected range overlap part of merged range.
ZSS-298 perform "clear style" on a merged cell doesn't split it back to original unmerged cells.
ZSS-301 cut a merged cell and paste to another cell, the original cell doesn't become unmerged cells.
ZSS-398 Sheetbar protectSheet menuitem check state is not correct
ZSS-397 Once deleting a picture on xlsx format, the exported xlsx file cannot be load by Excel or pictures are incorrect.
ZSS-358 Exported Excel 2007 file with charts cannot be read by Excel 2007
ZSS-406 Spreadsheet doesn't be release when use application share scope
ZSS-407 Shouldn't allow to drag row/column size in protected sheet
ZSS-357 if a file contains #REF! cells, it will throw a exception and can't be rendered when importing such file
ZSS-410 Undo style action get NPE in 2003
ZSS-415 Get Exception after save and load a sheet that has comment in 2003
ZSS-408 Cannot save 2003 format if the file contains auto filter configuration.
ZSS-414 get NPE when paste from client text
ZSS-409 Set font color doesn't work in 2003
ZSS-419 if delete two or more rows at once, the exported file will make Excel error when loading
ZSS-235 Typo, in toolbar there is 'Outsizde Borders'
ZSS-237 Exception if rename to same sheet name.
ZSS-261 Math formula SERIESSUM evaluating error
ZSS-265 some Info formulas are not found
ZSS-266 Info formula "ISERR" is evaluated to a wrong result
ZSS-267 error evaluating some date formulas
ZSS-269 error evaluating some financial formulas
ZSS-293 vertical merged cells must be selected by clicking first cell
ZSS-296 Protect Sheet" doesn't prevents cells from using auto filter
ZSS-307 move sheet left should not move to first sheet
ZSS-314 The dependency "commons-io" is not configured in ZSS
ZSS-264 Some text formula are not found
ZSS-310 Rename a sheet to its original should not show up a error message
ZSS-318 A Zsshtml project's resource file (excelStyle.css) is not included in compiled result
ZSS-321 Unsupported formulas cause an exception and crashed
ZSS-341 2 statistical formulas throw NotImplementedException
ZSS-342 When a ZK defined formula has missing required arguments, it throws NotImplementedException
ZSS-355 When given start date is later than end date In NETWORKDAYS(), it returns #NAME?
ZSS-409 Set font color doesn't work in 2003
ZSS-414 get NPE when paste from client text
ZSS-253 click component away from Spreadsheet but keeps focus
ZSS-425 Can't update style when save twice
ZSS-424 get exception when undo after save
ZSS-426 Endless loop when export demo swineFlu.xls pdf
ZSS-241 wrap text does not wrap text like excel
** Upgrade Notes
* Classes inside 'org.zkoss.zss.model' is duplicated and removed, please use the new classes & api
that inside 'org.zkoss.zss.api' & 'org.zkoss.zss.api.model'
* Spreadsheet Api changes:
* get/set Book/Sheet API use the new classes of Book & Sheet that inside 'org.zkoss.zss.api.model'
* get/set rowfreeze and columnfreeze are deprecated, use Sheet#getColumnFreeze(),Sheet#getRowFreeze() and Range#setFreezePanel(int, int)
* Rect and Position (in org.zkoss.zss.ui) are deprecated, please use CellRef and AreaRef instead (in org.zkoss.zss.api)
* Action, ActionHandler are removed. To override a default action, use AuxAction, UserActionManager instead.
* Constructor of CellSelectionEvent is changed from left,top,right,bottom to topRow,leftCol,bottomRow,rightColumn
* SelectionChangeEvent is renamed to CellSelectionUpdateEvent and arguments sequence is also redefined.
* HeaderEvent is renamed to HeaderUpdateEvent
* SheetCreateEvent, SheetSelectedEvent and SheetUpdateEvent are removed, use SheetEvent instead.
* FilterMouseEvent is renamed to CellFilterEvent
* HyperlinkEvent is renamed to CellHyperlinkEvent
* Event name change:
onValidateDrop > onCellValidator
onFilter > onCellFilter
onHeaderSize > onHeaderUpdate
onSelectionChange > onCellSelectionChange
onCellFocused > onCellFocus
* Event name change:
onSheetNameChange > onAfterSheetNameChange
onSheetOrderChange > onAfterSheetOrderChange
onSheetDelete > onAfterSheetDelete
onSheetCreate > onAfterSheetCreate
onCellChange > onAfterCellChange
* JSF
Main package is renamed to org.zkoss.zss.jsf, Component is renamed to JSFSpreadsheet
* JSP
Main package is renamed to org.zkoss.zss.jsp
------------
ZK Spreadsheet 2.6.0
*Features:
ZSS-187 Better support for CellStyles while setBorders
*Bug
ZSS-171 Input "=" on cell shall not append cell reference
ZSS-177 Resizing the browser wraps the toolbar but the overflow goes under the formula bar
ZSS-179 spreadsheet exception :XmlValueDisconnectedException
ZSS-181 on_ctrl_keys (#up#down$#home$#down^#up^#down^#right^#leftt) not works with zk spreadsheet
ZSS-183 Cannot enable save button when using collaboration Edit
ZSS-184 Merge and Center in Demo Site (as well as ours) is sporadically unclickable
ZSS-188 onHeaderClick not work
ZSS-189 PDF export throws Color 'auto_color' not found exception
ZSS-196 Data validation list source cannot refer to different sheet's value
ZSS-197 Data Validation shall not show dropdown button when data source is not list
ZSS-198 Data validation's message shall auto-disappear when focus on other cell
ZSS-199 Select a row and apply filter doesn't work well
ZSS-204 cell context menu covers text formatting menu for cells in lower part of the screen
ZSS-207 Date validation button not show on first focus
ZSS-209 NullPointerException when set spreadsheet book in a loop
ZSS-210 CellStyle.cloneStyleFrom not work when copy cell style from different book
ZSS-213 Protection doesn't work with drag fill & copy-paste
ZSS-212 Missing characters when export to PDF
ZSS-216 Disable button cause the button expand
ZSS-217 Javascript error with ZK 6.5.1.1 version
ZSS-218 get NotImplementedException exception
ZSS-220 Can't get correct selection if I didn't listen to onCellSelection
ZK Spreadsheet 2.5.0
*Features:
ZSS-124 Support import pivot table API
ZSS-128 Support export pivot table API
*Bug
ZSS-125 Zk Spreedsheet performances problem with an excel file generated with jexcel
ZSS-126 ZKS performances problem with an excel file generated AND FORMATTED with Apache POI
ZSS-127 Cannot open a popup/modal window including ZSS with IllegalStateException
ZSS-131 Sheets contains unsupported drawing object cannot opening, get null pointer exception
ZSS-134 Sheets contains unsupported cell format, cannot opening, get null pointer exception
ZSS-132 Export to PDF on a sheet get null pointer exception
ZSS-136 Export to PDF with image, the same image will repeat on each page (when using portrait)
ZSS-138 Initiate book with property cause NullPointerException
ZSS-141 Export sheet to PDF doesn't show last column
ZSS-142 Invalid format cause NullPointerException
ZSS-143 Cell addres gets into cell value on user input
ZSS-145 Freezing a row causes the rows above the frozen row to be unselectable.
ZSS-147 Exporting to pdf throws NullPointerException
ZSS-148 Open sheet with chart without label cause exception
ZSS-149 DateValue does not reconize Leap day
ZSS-150 The row/column header size is not correct on Firefox
ZSS-152 Set new cell text with wrap text, should change row height accordingly
ZSS-154 Cannot delete the first row, throw IllegalArgumentException
ZSS-153 After adding a user defined function to a sheet the application throws a NPE inserting/deleting rows/columns/cells
ZSS-155 Spreadsheet's color button doesn't work with ZK 6.5
ZSS-156 Insert a image first, then insert a chart, delete the chart cause NullPointerException
ZSS-157 With frozen area, contiguous scrolling down, cells may missing
ZSS-158 Second sheet doesn't update cell value
ZSS-159 Cell with overflow shall has right border when text total width is smaller then cell width
ZSS-160 Formula button in toolbar is missing
ZSS-161 Cancel edit button on formula bar not working
ZSS-162 Insert columns, then scroll down, cell width is wrong
ZSS-163 In protected sheet, shall not allow user to delete or move chart
ZSS-164 Mouse click on chart widget, the sheet will move up, chrome only
ZSS-166 Insert columns, then switch sheet cause wrong cell content
ZSS-167 Delete rows, then switch sheet, cause cells missing
ZSS-168 Color button shall close when close when mouse click on cell or other button
ZSS-169 Copy/Paste sometimes not work correctly
ZSS-170 Insert row at certain row not work correctly
ZSS-171 Input "=" on cell shall not append cell reference
ZSS-172 Edit cell formula and use mouse to select cell, press enter cause wrong cell selection
ZSS-173 Set row freeze and column freeze, scroll down, cause JS error
------------
ZK Spreadsheet 2.3.0
*Features:
ZSS-85 Range support createSheet API that supports collaboration
ZSS-86 Range support setSheetName API that supports collaboration
ZSS-87 Range support setSheetOrder API that supports collaboration
ZSS-97 Spreadsheet support row/column/cell context menu
ZSS-98 Spreadsheet support toolbar
ZSS-99 Spreadsheet support sheetbar
ZSS-100 Spreadsheet support sheet cache
ZSS-104 ZPOI upgrade to POI 3.8 - Final
*Bug
ZSS-80 Press ESC cannot cancel editing when formula bar is hidden.
ZSS-81 Cannot input formula with proper external book name
ZSS-82 Exception when user input an inexisting book or sheet in formula
ZSS-83 Drag header not able to hide, unhide
ZSS-84 Validation button doesn't show after row 20
ZSS-88 Merge and wrap cell shall not change row height
ZSS-89 AutoFilter not work correctly on sheet first load
ZSS-91 zssjsf.jar not work with GlassFish
ZSS-92 hide column/row by menu, and unhide it by drag doesn't work
ZSS-93 paste all expect border shall not set paste destination border to empty
ZSS-94 set sheet name twice throw exception
ZSS-95 wrap cell cause cell border invisible
ZSS-96 inline editor shall not input cell ref when click a cell
ZSS-103 SLN function throws NotImplementedException
ZSS-109 scroll sheet down and drag widget, the drag view's position is wrong
ZSS-110 move chart will cause NPE when using xls format file
ZSS-107 area/scatter chart not show chart content
ZSS-112 set book that contains chart, switch sheet not show chart correctly
ZSS-113 delete sheet's chart cause NPE, xls format only
ZSS-116 export sheet with chart cause Exception (xls format only)
ZSS-120 insert new row not work well
ZSS-122 Cell editing is blocked with regular expression check in Japanese locale
ZSS-123 zssapp insert image cause exception, xls format only
------------
ZK Spreadsheet 2.2.0
*Features:
ZSS-01 Support validation dropdown list
ZSS-13 Support Open hyperlink in a separate browser tab window
ZSS-26 Need css running in zk.wcs not css.dsp
ZSS-41 Support showing more charts: area, stacked area, scatter, bubble, stacked bar, stacked bar3d in 2007 file format(.xlsx)
ZSS-44 Support API to add a new chart in 2007 file format(.xlsx)
ZSS-45 Support API to add a new picture in 2007 file format(.xlsx)
ZSS-46 Support API to delete an existing picture in 2007 file format(.xlsx)
ZSS-47 Support API to move an existing picture in 2007 file format(.xlsx)
ZSS-48 Support API to move an existing chart in 2007 file format(.xlsx)
ZSS-49 ZSS Spreadsheet App shall support insert chart dynamically
ZSS-50 ZSS Spreadsheet App shall support insert image dynamically
ZSS-51 Support API to delete an existing chart in 2007 file format(.xlsx)
ZSS-54 Chart/Image widget shall be able to move, sizing and delete
ZSS-55 Auto filter dialog support search function
ZSS-58 Support collaboration editing with color cell selection focus box
ZSS-59 Formula editor support cancel button and apply button
ZSS-60 Editing formula support use mouse to select a cell or a selection
ZSS-62 ZPOI upgrade to POI 3.8 beta5
ZSS-64 ZK Spreadsheet App shall support sheet deletion collaboration
ZSS-66 POI row object should provide information about the height is changed by end user or not
ZSS-67 Support locale aware Date and Number input
ZSS-68 Support showing Date and Number with current locale
ZSS-69 Support locale aware drag fill for Month and Week
*Bug
ZSS-15 edit date cells doesn't work
ZSS-20 Incorrect PDF export results if merged cell span across page breaks
ZSS-21 Right click on hyperlink should not jump to the link
ZSS-22 Shall not allow Copy and Paste operation in a protected spreadsheet
ZSS-24 key on numpad is not work on Opera
ZSS-27 Wrap text does not change row height to make all content visible
ZSS-29 Formula editor cursor not correctly positioned in different browser when focus changed when composing formula
ZSS-40 Press Ctrl+V for long time does not work correctly
ZSS-42 Export PDF, merged cell's border doesn't show up correctly
ZSS-43 Export PDF, sheet break, contains empty page
ZSS-52 Past special, copy column width's behavior doesn't correct
ZSS-56 Unlock a cell, protect sheet, cannot double click to edit the cell
ZSS-61 setSrc doesn't work on a empty spreadsheet
ZSS-65 When cell wrap, cell shall hide overflow text
ZSS-70 scroll down with freeze column, in freeze area, some row is empty
ZSS-71 Use preloadRowSize width column freeze, when scroll down very fast and multiple times in short time, doesn't work well
ZSS-72 Set one column freeze, and set preloadColumnSize, cause JS error
ZSS-73 Scroll down and scroll right, then scroll top, cause empty area
ZSS-74 Set maxcolumns 20 cause JS error
ZSS-75 Set book null, cause NPE
ZSS-76 Set data format cause NPE in US locale
ZSS-77 Drag fill "Jan" on new sheet, cause NPE
ZSS-78 Implementation of RangeImpl#setValue() is not correct
ZSS-79 zss JSF component cause JS error
* Upgrade Notes
+ Per the feature ZSS-13, Spreadsheet will always open hyperlink in a separate browser tab window.
If you need to keep the original behavior (click to open hyperlink in the same browser tab window;
CTRL-click to open hyperlink in a separate browser tab window), please specify in zk.xml the
following library property to false:
<library-property>
<name>org.zkoss.zss.ui.Spreadsheet.linkToNewTab</name>
<value>false</value>
</library-property>
------------
ZK Spreadsheet 2.1.1
*Features:
*Bug
ZSS-25 Cell with hyperlink in Firefox got redundant line
ZSS-28 Spreadsheet data binding does not work
ZSS-31 NullPointerException in some application server. ex Domino
ZSS-32 xls file set cell style cause exception
ZSS-33 Nullpointer when change the color of cell
ZSS-34 cell background color does not show in excel
ZSS-35 A exported xlsx is not loadable again by Excel or Spreadsheet
ZSS-36 Exception when exporting excel twice
ZSS-37 A timer doesn't cleanup, cause tomcat cannot stop
ZSS-39 Hide row on IE7 will popup javascript error message
------------
ZK Spreadsheet 2.1.0
*Features:
26 Support copy/paste value to local Excel
161 Support copy&paste from clipboard to a cell
238 ZK Spreadsheet App: Support select cell reference for formula entrance
293 Support AutoFilter in 2007 file format(.xlsx)
294 Support 2003, 2007 Excel file format export to HTML
309 Support vertical merge
310 Autofill support number auto linear increase
312 Autofill support month/week auto increase
314 Autofill support date auto increase
316 Autofill support number auto growth(multiply increase)
319 Support cell vertical alignment
323 Protecting cells/cell ranges
330 Support Range#applyFilter for 2007 file format(.xlsx)
331 Support Range#showAllData for 2007 file format(.xlsx)
*Bug
290 Formula cells not always updated
296 Can't insert formula "=A1" by java
297 cell color is not right in xls file
298 input/output/format of number-cells doesn't respect current locale
300 Numbers in Text-cells are not treated as text (leading zero is removed)
303 Spreadsheet Mask not removed when set visible of the container
304 Resizing guiding line does not show
305 ZK Spreadsheet App: Formula bar text box is not left aligned to just right of f(x) button
307 chart not shown when set visible of the container of the spreadsheet
308 Set empty String to cell shall be deemed as blank cell
311 =20.6+3.6 formula shows incorrect number
313 Typemismatch exception when Copy formula onto a Text cell
315 freezed pane rows/columns don t work when setting Spreadsheet from Composer.
317 Number 0 shall be date 1900/1/0 0:00 (Java Date 1899/12/31 0:00)
318 xlsx only. IllegalArgumentException when formula cause a circular reference
320 NullPointerException when move cell focus
322 CellStyle.getLocked() always return false in 2007(xlsx) file format.
324 Spreadsheet wrap text doesn't work
325 Spreadsheet unwrap text doesn't work
326 Sizing row height the associated Merged area should sizing accordingly
328 ZK Spreadsheet App throw ComponentNotFoundException when press "hyperlink" button
329 Move Focus on hidden row/column, the row/column header highlight is not correct
332 Scroll sheet down and up cause javascript error
333 Merged cell with auto filter has more one filter button
334 AutoFilter cause exception
336 Showing incorrect contents when press filter drop button in merge cell
337 Filter dropdown button incorrectly change to "filter icon" after click the dropdown button and press OK.
338 Reapply filter fail to work
339 "=" + mouse click to input formula
340 Spreadsheet hyperlink font underline in wrong position
341 ZK Spreadsheet App: open custom sort range twice, UI doesn't work well
342 ZK Spreadsheet App: use compose formula dialog, when focus one last textbox, focus will change to first textbox
343 ZK Spreadsheet App: insert image cause class cast exception
344 ZK Spreadsheet App: after close sheet should not able to click save sheet menu
345 ZK Spreadsheet App: select a column and apply number format, cause server no response
346 ZK Spreadsheet App: compose formula dialog input formula to wrong cell
347 Wrong page orientation for PDF export in Portrait mode
348 Formula cell formatting lost in PDF export file
------------
ZK Spreadsheet 2.0.1
*Features:
169 xls file support full rgb color
277 ZK Spreadsheet App: Formula Editor shall support multiple line and extensible
281 Support wrapping of ZK Spreadsheet as a JSP tag
278 ZK Spreadsheet App: press ESC shall close(cancel) any wizards/dialogs
*Bug
268 Enter multiple line in cell but show as one single line only
269 ZK Spreadsheet App: multiple line in cell but single line in formula bar
270 Set font style with a cell has white color cause NPL
271 ZK Spreadsheet App: NPE when focus on formulabar editor with a no book Spreadsheet
272 ZK Spreadsheet App: NPE when close the book
273 ZK Spreadsheet App: Shall disable formula bar, insert menu items when there is no book
274 Rename sheet with a chart inside and export to excel, chart is missing
275 Rename sheet with a chart and switch sheets cause NPE
276 ZK Spreadsheet App: Selection shall move to left when shift-Tab on Formula bar editor
279 ZK Spreadsheet App: a error dialog in compose formula dialog
280 ZK Spreadsheet App: NPE in compose SUM formula dialog
282 After "export to Excel", cause XmlValueDisconnectedException
283 set spreadsheet visible="false" cause error dialog
284 ZK Spreadsheet App: after delete a sheet, the horizontal scrollbar will disappear
285 Spreadsheet component with Liferay, on Chrome and IE, Layout is wrong
286 NPE when load the attached xls file
287 click on specific cell and set font bold, cause NPE
288 ZK Spreadsheet App: number format dialog select "General" cause error dialog
289 xls font color does not match to what was in Excel
------------
ZK Spreadsheet 2.0.0
*Features:
46 Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 97-2003, xls)
134 Support Math formula functions for Matrix operations
135 Support Math formula functions
136 Support Statistical formula function for calculating distribution
137 Support Statistical formula functions for calculating mean
138 Support Text formula functions
140 Support Information formula functions
141 Support showing chart(Bar, Bar3D, Line, Line3D, Pie, Pie3D, Donut, Excel 2007, xlsx)
142 Support for Date & Time functions
143 Support for Logical formula functions
145 Support select range by shift key
152 Support Ranges.range(sheet, namedRange)
158 ZK Spreadsheet App support colorbutton without depending zkex
160 ZK Spreadsheet App support import, open file
165 Support 2007 Excel file format export to PDF
192 Support exporting Excel Chart to PDF
194 ZK Spreadsheet App support shift cell, entire row or column
199 ZK Spreadsheet App shall support wrap text.
212 Cannot shift select left on merge cell
222 ZK Spreadsheet App shall support number format
234 Support export to xls and xlsx
246 ZK Spreadsheet App support save file
247 ZK Spreadsheet App editor shall support tab and cancel key control
251 ZK Spreadsheet App support set column width and row height
*Bug
132 view ZK Spreadsheet App index.zul cause NullPointerException
139 "Unexpected ptg class" RuntimeException when loading Excel file with special formula
144 copy from a cell to a range
146 selected range should stay emphasised when click menubutton
148 Can't delete row in the bottom
149 change size of multi-column
150 change size of multi-row
153 column header is not aligned when resize a freezed column
154 border not well in all borders, inside borders, inside horizontal borders, inside vertical borders
155 source region of copy get highlighted in different sheet
156 spring DelegatingVariableResolver in Spreadsheet doesn't work
157 fail to delete rows out of original xlsx
163 Can't set backgrond color to excel 2007 file format
164 no grid line while export to pdf
166 ZK Spreadsheet App, Modify the font size, cell height won't automatically adjust
167 set background color seems like multiple selection in color choosing
168 Exception while set background color
170 Set font color of a region with different font size, will resize the font size.
171 Once clicked, merge button remain pressed state
172 paste transpose error
180 ZK Spreadsheet App support hide column/row function
182 Exception when right click row header and insert a row
187 Select and focus shall not move when insert/delete columns/rows/cells
188 NullPointerException when delete columns
189 Cell formula is not properly shifted when delete rows
190 Selection is not correctly placed after paste.
191 Shall return #NAME? when entering a random named function
193 Throw exception when open a sheet with random named function
195 Exception when not specified src or book to <spreadsheet>
196 Range fill down, fill left, fill right, fill up doesn't work
197 Text color does not respect condition format
198 Shall be interpret as hyperlink if user enter "http://" into cell
200 Exception in paste special from context menu
201 Cell Background Color is not correctly shown in Excel 2007 xlsx
202 Enter key after copy/cut does not do "paste"
203 ESC key after copy/cut does not cancel the copy/cut.
204 ZK Spreadsheet App gridline checkbox is not updated when change sheet
205 Copy and paste does not copy a merge cell
206 Cell editing after copy/cut does not cancel copy/cut.
207 ZK Spreadsheet App focus on formula edit box after copy/cut does not cancel copy/cut
208 Spreadsheet focus position is lost onBlur
210 Bug in spreadsheet date-time display
211 Shift + arrow key selection does not respect merge cell.
213 ZK Spreadsheet App compalins "Not unique in ID space <Window mainWin>: formulaWin"
215 ZK Spreadsheet App View->Formula Bar complains "Fellow component not found: formatNumberWin"
217 ZK Spreadsheet App delete sheet not working
219 ZK Spreadsheet App rename Sheet, current tab move to 1st sheet tab
220 ZK Spreadsheet App Formula function selection dialog title is not correct
221 ZK Spreadsheet App NPE if leave Insert Function Dialog without select an item
223 Insert/delete row/column to book shall NOT affect maxrows and maxcolumns of the Spreadsheet
224 Select a range to delete but only left-top cell removed
225 Exception when remove a row which is referenced by a cell
226 Exception when change sheet quickly
227 ZK Spreadsheet App set display gridline doesn't work on IE
228 In IE, press F2, won't focus on cell for input value
230 IE cursor position is not at the text end when press F2
231 Absolute Cell Reference shall not move when copy, paste
232 NPE when load the attached xlsx file
233 Right click header selection doesn't work well
235 Transpose pasteSpecial shall reverse Row/Column formula reference
236 Delete current sheet and set selected sheet cause exception when use xlsx as source
239 Bad error code(-60)
240 Irrelevant merged regions faultly unmerged when delete a cell and shift left
241 Shall complains about an incorrect formula
242 Delete key not working when edit cell
244 ZK Spreadsheet App: formula bar cursor will unexpectedly move to the end of the text
248 ZK Spreadsheet App: Tab on formula editor if focus on the last visible column, shall not move focus right
249 ZK Spreadsheet App: Enter on formula editor if focus on the last visible row, shall not move focus down
252 ZK Spreadsheet App: Click on formula bar editor, the spreadsheet Cell did not change to formula accordingly
253 ZK Spreadsheet App: Cell wrongly set to incorrect value
254 Illegal highlight exception when copy and switch sheet
255 ZK Spreadsheet App: change sheet lost the focus
256 ZK Spreadsheet App: A Currency number format does not match expected
257 Style is wrongly copied when insert a row
258 ZK Spreadsheet App insert whole row/column cause set selection out of range exception
261 ZK Spreadsheet App: click a cell and set border, cause NPE
262 ZK Spreadsheet App: unwanted error dialog when sort
264 ZK Spreadsheet App: Cut should has no memory of area after once copied
266 ZK Spreadsheet App: Toolbar button Grid line easily unsync
267 ZK Spreadsheet App: cut & paste column takes too long
* Upgrade Notes
+ Package names of classes in zpoi.jar are renamed from org.apache.poi.* to org.zkoss.poi.* to avoid class
name conflicts with of those in poi.jar, so it is now OK to put both zpoi.jar and poi.jar in class path.
+ Spec. of Range#getColumn(), Range#getRow(), Range#getLastColumn(), Range#getLastRow(), Range#getCells() has
changed from 1-based to 0-based so it consists with other APIs. That is, in new spec, Range#getColumn()
return 0 for column A (1st column) and Range#getRow() return 0 for row 1 (1st row).
+ Spreadsheet#getSelectedSheet() return org.zkoss.zss.model.Worksheet
+ Methods range(org.apache.poi.ss.usermodel.Sheet sheet, ...) in org.zkoss.zss.model.Ranges changed signature
to range(org.zkoss.zss.model.Worksheet sheet, ...)
------------
ZK Spreadsheet 2.0.0 RC
*Features:
65 Honer displayGridlines parameter
70 Support insert rows(Excel 2007, xlsx)
71 Support delete rows(Excel 2007, xlsx)
74 Support insert columns(Excel 2007, xlsx)
75 Support delete columns(Excel 2007, xlsx)
76 ZK Spreadsheet App support set font by toolbarbutton and menu
77 ZK Spreadsheet App support set font size menu and toolbarbutton
78 ZK Spreadsheet App support set color to cell and font by menu and toolbarbutton
79 ZK Spreadsheet App support set font bold by menu and toolbarbutton
80 ZK Spreadsheet App support set font italic by menu and toolbarbutton
81 ZK Spreadsheet App support set font underline by menu and toolbarbutton
82 ZK Spreadsheet App support set font strike by menu and toolbarbutton
83 ZK Spreadsheet App support set cell alignment by menu and toolbarbutton
84 ZK Spreadsheet App support clear cell style by menu
85 Support insertRange(Excel 2007, xlsx)
86 Support deleteRange(Excel 2007, xlsx)
88 Support moveRange(Excel 2007, xlsx)
89 Support merge(Excel 2007, xlsx)
95 Support for ACCRINT financial funcion
96 Support for ACCRINTM financial funcion
100 Support COUPON financial functions
101 Support DISC financial function
102 Support DOLLAR conversion financial function
105 Support DURATION financial function
107 ZK Spreadsheet App support export PDF
108 Support showing pictures(Excel 2007, xlsx)
111 Support exporting selected sheet to pdf
112 Support exporting selected area to pdf
113 Support annual interest rate financial functions EFFECT and NOMINAL
114 Support security related financial function
115 Support yield related financial function
116 Support Treasury Bill related financial functions
120 ZK Spreadsheet App support set hyperlink menu and toolbarbutton
121 Support Binary number conversion engineering functions
122 Support Decimal number conversion engineering functions
123 Support Hexadecimal number conversion engineering functions
124 Support octal number conversion engineering functions
126 Support Bessel engineering functions
127 Support DELTA ERF ERFC and GESTEP engineering functions
128 Support complex number engineering functions
129 Support input mask for entering Date or Time into cell.
130 ZK Spreadsheet App Support display, hide gridlines
131 Support wrapping ZK Spreadsheet as a JSF Ajax Component
*Bug
44 Locale is not respected
61 Fronzen row/column does not comply with Spreadsheet's maxrows/maxcolumn
64 pasteSpecial copy Validation cause Null pointer exception (Ptgs must not be null)
66 Unexpected gridlines shown
67 Exception when enter value 0.3308589607635 into cell with text format "# ???/???"
68 Exception when set text format to ?/2, ?/4, ?/8, ?/16, ??/100
69 Incorrect text output when enter value 0 into cell with text format "???/???"
72 IE6 rendering issue - fixed column & row sizes/positions
73 Edit on the shorter last visible row cause the grid moving up
87 =HYPERLINK() function in Excel 2007xlsx not follow as a hyperlink
91 NPE when load cell with color style(Excel 2007, xlsx)
93 NPE when load sheet with merge cell
97 StringIndexOutOfBoundsException if cell text format is _(*"_"??_)
98 Freeze area is not rendered if it is on the second sheet
99 freeze column and freeze row is not reset.
103 Freeze row/column is not correctly interpreted
106 NPE when load Excel 2007 file with rich text string
109 2nd picuture is not shown.
110 merge area is not reset
117 Barcode Scanner data incomplete
119 Typing in 234-6 or 344/2 into cell cause junk number value
------------
ZK Spreadsheet 2.0.0 beta3
*Features:
36 Support Range.setStyle
37 Support Range.autoFill
38 Support Range.clearContent
40 Support Range.fillUp
41 Support Range.fillDown
42 Support Range.fillRight
43 Support Range.fillLeft
48 Honer hidden columns
49 Honer hidden rows
50 Support drag to hide column
51 Support drag to hide row
52 Support drag to sizing so un-hide a hidden column
53 Support drag to sizing so un-hide a hidden row
28 Support hideRows
29 Support unhideRows
30 Support hideColumns
31 Support unhideColumns
55 Support Range.setHidden
57 ZK Spreadsheet App support sort/custom sort menu and toolbarbutton
62 Support getRepeatingRowsAndColumns
58 Support printing ZK Spreadsheet to PDF file
63 ZK Spreadsheet App support copy/paste/pastSpecial menu and toolbarbutton
*Bug
56 zss error in log
47 zss2 beta 2 IE support
54 data input errors - lost characters when switching to edit mode
60 Sort function when select multiple columns cause Nullpointer exception
59 Sort with case sensitive should be in special spreadsheet order
------------
ZK Spreadsheet 2.0.0 beta2
*Features:
6 Support insert rows(Excel 97-2003, xls)
7 Support delete rows(Excel 97-2003, xls)
9 Support insert columns(Excel 97-2003, xls)
10 Support delete columns(Excel 97-2003, xls)
12 Support sortByColumns
13 Support sortByRows
15 Support insertRange(Excel 97-2003, xls)
16 Support deleteRange(Excel 97-2003, xls)
17 Support moveRange
18 Support merge
19 Support showing bullet list in cell
20 Support unMerge
21 Support setBorders
22 Support setColumnWidth
23 Support setRowHeight
25 Support pasteSpecial
27 Support Hyperlink follow up.
*Bug
11 NPE when click on an empty cell
14 Picture is not correctly shown(ZK Spreadsheet EE)
24 Drag selecting an area shall snap to the boundary of merged cells
32 Wrong height when insert rows
33 Wrong width when insert columns
34 moveRange fail to shift formula correctly
35 Hyperlink should show the formated text
------------
ZK Spreadsheet 2.0.0 beta (Work with ZK 5 and after)
* Features:
1 Support ZK 5
2 Support importing Excel 2007 xlsx file
3 Showing rich text