ZK Spreadsheet 3.8.1 Release Notes

The 1st embeddable Ajax spreadsheet for Java Web application!


Released on Aug 18, 2015.


ZK Spreadsheet is an embeddable Ajax spreadsheet that delivers rich functionalities of Excel within browsers using pure Java without the need for any plugins.

Version 3.8.1 is a minor release to enhance functions like increasing max visible rows, etc.
Version 3.8 is an upgrade release introducing new features including the display vertical text, 90 degree text orientation, show table data models from excel and many more!


Feature Highlights




What's New

  • New Features Tracker
    • ZSS-998: Show all online users on the top of the page
    • ZSS-1000: Support ctrl + arrow key
    • ZSS-1044: Keep selection box visible even when spreadsheet losing focus
    • ZSS-1050: Filter by searching for AutoFilter
    • ZSS-1063: Support new password mechanism introduced since 2012
    • ZSS-1082: Users can increase max visible rows
    • ZSS-1084: Can initialize max row and column automatically by detecting file content
  • Bugs fixed
    • ZSS-929: javascript exception when copy a merged cell, freeze and switch sheet tabs
    • ZSS-930: Continuously copy and paste merged cell cause selection error
    • ZSS-932: Chart should change label name after cell's value changed
    • ZSS-949: Should show space character in Cell
    • ZSS-969: Javascript error "no element found" happens on firefox 36
    • ZSS-976: Exported PDF doesn't look the same as original file on the screen
    • ZSS-983: Rename Table then Rename column, the column name in formula inside table should change accordingly
    • ZSS-1020: Rotation info should be included into exported excel file
    • ZSS-1055: Comment should not be visible when exporting
    • ZSS-1061: exporting a file loses vertical alignment
    • ZSS-1062: sheet protection not working as expected
    • ZSS-1064: ZSS does not recognize @Listen events after 3.8.0 update
    • ZSS-1065: Mouse position offset in y direction
    • ZSS-1067: JS Error showed when hiderowhead/hidecolumnhead attribute is set to true
    • ZSS-1068: Cannot set background color by EditableCellStyle
    • ZSS-1069: Typing a character causes a javascript error
    • ZSS-1071: Formula bar content messed when moving arrow key
    • ZSS-1072: The font "Calibri" is missing from the dropdown in the toolbar
    • ZSS-1073: applying a filter to an empty sheet (area) causes an error
    • ZSS-1074: Exported pdf missing background color when setting the color with whole row/column
    • ZSS-1075: Scroll to right quickly and a javascript error happens
    • ZSS-1076: Toolbar menu icon shouldn't be broken
    • ZSS-1077: PDF export ignores chinese characters
    • ZSS-1078: NullPointerException is thrown when importing a file having a protected sheet with empty password
    • ZSS-1079: When editing a formula, switching to another sheet doesn't stop editing
    • ZSS-1080: A formula is moved after switching to another sheet
    • ZSS-1081: Inconsistent behaviours when entering an incorrect formula and switching to another sheet
    • ZSS-1083: ZSS scroll back unexpectedly when entering any value under autofilter enabled
    • ZSS-1085: Press left arrow key on a protected sheet and Javascript busy.
    • ZSS-1086: Firefox only. Formulabar dost not gain focus when click on formula name.
    • ZSS-1087: invalidate() make sheet scroll back to top.
    • ZSS-1089: ZSS doesn't apply searching result when the filter is applied
    • ZSS-1090: External book reference failed
    • ZSS-1091: Support customized header and footer
    • ZSS-1092: option (Select All) in autofilter dialog is not correctly shown
    • ZSS-1093: ClassNotFoundException when loading zssjsf
    • ZSS-1094: Many Classes do not implement the Serializable Interface and in Cluster mode Fails
    • ZSS-1095: Create new book causes js error
    • ZSS-1096: Invalid named range causes importing failure
    • ZSS-1098: PageUp does not stop editing
    • ZSS-1099: Cannot disable moving a sheet left and right
    • ZSS-1100: UiException: Illegal request when change sheet
    • ZSS-1101: JavaScript NPE
    • ZSS-1108: IE only. +90/-90 degree text not showing correctly.
  • Upgrade Note
    • Set org.zkoss.zss.ui.Spreadsheet#setMaxVisibleRows() to zero or leave as default; then ZK Spreadsheet will determine the max visible rows per the sheet's content.
    • Set org.zkoss.zss.ui.Spreadsheet#setMaxVisibleColumns() to zero or leave as default; then ZK Spreadsheet will determine the max visible columns per the sheet's content.
    • org.zkoss.zss.ui.Spreadsheet#getCurrentMaxVisibleRows(): new API which returns the max number of visible rows of the currently selected sheet. If you ever used getMaxVisibleRows() or getMaxRows() in application should replace with this new API instead.
    • org.zkoss.zss.ui.Spreadsheet#getCurrentMaxVisibleColumns() now API which returns the max number of visible columns of the currently selected sheet. If you ever used getMaxVisibleColumns() or getMaxColumns() in application should replace with this new API instead.