Release Notes

Keikai EE 5.3.0

Released on Jul. 1, 2020

Keikai Spreadsheet is a modern & fast ajax web spreadsheet component that brings Excel functionalities into your web application.

Keikai 5.3.0 is an updated release containing 7 new features and 28 bug fixes. Highlighted features include supporting combochart, sparklines and double underline.

Keikai Spreadsheet is typically used for converting existing Excel files into web, integrating with DB and services, data processing, reporting and online collaboration. Download this latest version and try it out today!

What's New

  • KEIKAI-11 - Support combination chart
  • KEIKAI-69 - Improve cell style matching time when cloning a sheet
  • KEIKAI-208 - Add new font family in the toolbar
  • KEIKAI-222 - support double underline
  • KEIKAI-277 - Support an option to show blank cells as a gap or zero
  • KEIKAI-280 - Show empty label on an axis when its source cell is blank
  • KEIKAI-281 - Suport Sparklines

Bugs Fixed

  • KEIKAI-182 - Press key in toolbar would enter editing mode
  • KEIKAI-202 - Chart 's tooltip display with multiple axis format went wrong
  • KEIKAI-218 - chart can't display itself across frozen areas after moving
  • KEIKAI-220 - prime faces components can't work with keikai jsf in the same page
  • KEIKAI-234 - chart color doesn't match the color in Excel
  • KEIKAI-243 - keikai shows incorrect cell value under incorrect number format
  • KEIKAI-245 - a page without spreadsheet still loads spreadsheet related javascript
  • KEIKAI-255 - Cannot apply font filter
  • KEIKAI-267 - Colour Picker
  • KEIKAI-270 - undesired New Book tooltip
  • KEIKAI-273 - Row height/Wrap text
  • KEIKAI-275 - a picture is not displayed after importing
  • KEIKAI-276 - Evaluating conditional formatting formulas takes an unexpected long time
  • KEIKAI-279 - selection box should not be highlighted when it's on a merged cell
  • KEIKAI-283 - Render issue when setting cell values on sheet select
  • KEIKAI-286 - [demo] workflow: white cell border
  • KEIKAI-287 - [Demo] excel like: file > close NullPointerException
  • KEIKAI-288 - incorrect chart axis
  • KEIKAI-289 - render a hyperlink as a string
  • KEIKAI-292 - color picker renders incorrectly with ZK 9.1.0
  • KEIKAI-293 - a line chart in combo chart doesn't update when source cells change
  • KEIKAI-295 - Exporting a combo chart, scatter and doughnut are turned to different types
  • KEIKAI-296 - a chart without legend should not show a lengend
  • KEIKAI-297 - chart title is missing in an exported chart
  • KEIKAI-298 - 'updateRowAutoHeight' error
  • KEIKAI-299 - Charts are exported to different colors
  • KEIKAI-303 - keikai crashed with a hidden toolbar
  • KEIKAI-306 - Combo Chart series are not at the right position

Keikai EE 5.2.0

Released on Apr. 22, 2020

Keikai Spreadsheet is a modern & fast ajax web spreadsheet component that brings Excel functionalities into your web application.

Keikai 5.2.0 is an updated release containing 11 new features and 41 bug fixes. Highlighted features include supporting iPad, tab color and upgrading zkcharts to 7.2.1.0.

Keikai Spreadsheet is typically used for converting existing Excel files into web, integrating with DB and services, data processing, reporting and online collaboration. Download this latest version and try it out today!

What's New

  • KEIKAI-13 - Support mobile ( iOS & Android) browsers
  • KEIKAI-64 - Copy cells between books
  • KEIKAI-74 - the color of a chart series can follow the color in Excel
  • KEIKAI-78 - support tab color
  • KEIKAI-151 - Simplify client wgt structure
  • KEIKAI-169 - Toolbar supports iconSclass
  • KEIKAI-173 - Merge 2 seperate .zsrendering in ss.less and _kk.less
  • KEIKAI-174 - Replace deprecated org.zkoss.util.logging.Log
  • KEIKAI-224 - auto enlarge filtering range
  • KEIKAI-226 - auto enlarge filtering range when enabling auto filter
  • KEIKAI-231 - upgrade zkcharts to 7.2.1.0

Bugs Fixed

  • KEIKAI-156 - font family is not displayed correctly
  • KEIKAI-186 - [Demo] clicking a toolbar button, the highlight is unexpected
  • KEIKAI-197 - Exported chart missing border
  • KEIKAI-198 - Scrollbar display issue after hiding headers
  • KEIKAI-199 - Context Menu Layout
  • KEIKAI-207 - incorrect table header text color
  • KEIKAI-209 - keikai doesn't render the borders of the table
  • KEIKAI-210 - render a redundant table row after inserting a row
  • KEIKAI-212 - absolute sheet relation paths causing errors
  • KEIKAI-213 - users can't find some functions
  • KEIKAI-214 - Empty protection element causes NPE during import
  • KEIKAI-215 - Freeze panel is not displayed if using hidecolumnhead
  • KEIKAI-217 - import cache doesn't work for a date cell
  • KEIKAI-219 - keikai style is affected by zk-bootstrap addon
  • KEIKAI-221 - insert function dialog contains extra space
  • KEIKAI-223 - Format parser doesn't account for currency VND format, parse as date
  • KEIKAI-225 - the selection box (focus) moves slowly
  • KEIKAI-227 - filter result has an unexpected border
  • KEIKAI-228 - an extra property in Array causes Keikai crashed
  • KEIKAI-229 - filter submenu exceeds the visible range
  • KEIKAI-230 - Filter causes null pointer exception
  • KEIKAI-232 - Copy paste from/to keikai and excel failed on some browsers
  • KEIKAI-233 - Undefined error
  • KEIKAI-236 - filter icons are affected by zk-bootstrap addon
  • KEIKAI-237 - Hard to scroll horizontally sometimes by clicking the scrollbar white area
  • KEIKAI-238 - keyboard will jump out when scrolling the screen (not clicking the cell)
  • KEIKAI-239 - can't see the cells when the keyboard jumps out
  • KEIKAI-240 - Colored currency format is not supported
  • KEIKAI-241 - [Demo]: closing data validation window freezes
  • KEIKAI-242 - keikai shows a hidden sheet
  • KEIKAI-244 - the formula bar is broken by bootstrap css
  • KEIKAI-246 - Failed to mount: Unknown widget: zss.Spreadsheet
  • KEIKAI-247 - JS error on show/hide toolbar
  • KEIKAI-249 - cell border misalign with row header
  • KEIKAI-250 - IE11 scrolling issue
  • KEIKAI-251 - mouser cursor doesn't become a finger pointer when hovering on the toolbar
  • KEIKAI-252 - Dialog display issue
  • KEIKAI-254 - Sheet tab border error
  • KEIKAI-256 - ipad - font not displayed correctly
  • KEIKAI-258 - ipad - the style of filter icon can be improved
  • KEIKAI-260 - ipad - return key doesn't work in editing area
  • KEIKAI-262 - SUBTOTAL() function_num 109 should exclude hidden cells by a filter
  • KEIKAI-263 - SUM() should not exclude hidden cells by a filter
  • KEIKAI-264 - Table filter button still appeared when the header was hidden
  • KEIKAI-268 - protect message breaks
  • KEIKAI-269 - [Demo] thinner cell border when editing cell

Keikai EE 5.1.1

Released on Mar. 5, 2020

Keikai Spreadsheet is a modern & fast ajax web spreadsheet component that brings Excel functionalities into your web application.

Keikai 5.1.1 is a hotfix based on 5.1.0. It contains two fixes for wrong wpd path and deformed image in hidden rows. For 5.1.0 new features and bug fixes, refer to the release note below.

Keikai Spreadsheet is typically used for converting existing Excel files into web, integrating with DB and services, data processing, reporting and online collaboration. Download this latest version and try it out today!

Bugs Fixed

  • KEIKAI-75 - an image is deformed for hidden rows
  • KEIKAI-204 - wpd path doesn't change at 5.1.0

Keikai EE 5.1.0

Released on Mar. 3, 2020

Keikai Spreadsheet is a modern & fast ajax web spreadsheet component that brings Excel functionalities into your web application.

Keikai 5.1 is an updated release containing 10 new features and 33 bug fixes. Highlighted features include supporting public API to get named range, pasting multiline-text from Excel to a single cell, and various improvements on filters.

Keikai Spreadsheet is typically used for converting existing Excel files into web, integrating with DB and services, data processing, reporting and online collaboration. Download this latest version and try it out today!

What's New

  • KEIKAI-38 - copy a cell with multiline text in Excel, paste it as one cell
  • KEIKAI-159 - ClipboardPasteEvent.getArea() doesn't return the area a user pastes values to
  • KEIKAI-164 - importer can throw more specific information when importing fails
  • KEIKAI-165 - Get rid of IE9 support in Keikai codebase
  • KEIKAI-166 - Move CSS style code from server side to client side
  • KEIKAI-170 - improve removeToolbarButton
  • KEIKAI-171 - Release configuration
  • KEIKAI-172 - keikai spreadsheet XSD supports event attributes
  • KEIKAI-177 - Hiding ZK Knowledge from using Keikai JSP tag
  • KEIKAI-180 - support public API to get named range list of a sheet

Bugs Fixed

  • KEIKAI-45 - row height changes after input
  • KEIKAI-50 - Missing bottom border when filtering
  • KEIKAI-51 - Missing cell border after merge
  • KEIKAI-66 - edit cells referenced by OFFSET doesn't update the formula result
  • KEIKAI-68 - text goes out of the filter dialog
  • KEIKAI-72 - Edit cells doesn't work after selecting a sheet
  • KEIKAI-73 - a chart has missing y-axis value labels
  • KEIKAI-82 - hidden rows cause a chart not displayed
  • KEIKAI-88 - zcss.setRule performance too slow when adding a lots
  • KEIKAI-108 - PDF export layout issue
  • KEIKAI-134 - Filtering cause server down
  • KEIKAI-137 - work with DB: button text broken (FF)
  • KEIKAI-138 - Wrong result after filtering and coloring
  • KEIKAI-149 - IE11: select multiple rows highlights everything
  • KEIKAI-150 - IE11: frozen row & column doesn't work correctly
  • KEIKAI-153 - right alignment spacing issue
  • KEIKAI-157 - arrow keys don't work in safari
  • KEIKAI-160 - failed to render dash borders
  • KEIKAI-161 - can't delete an image
  • KEIKAI-178 - Remove unnecessary book lock under Spreadsheet.java (Refix for ZSS-618)
  • KEIKAI-179 - clone a sheet doesn't clone its named range
  • KEIKAI-181 - failed to import a cell with string cache
  • KEIKAI-183 - selecting a sheet doesn't work for the first time
  • KEIKAI-184 - 5.1FL breaks layout
  • KEIKAI-185 - [Demo] WorkFlow template border
  • KEIKAI-187 - new book button causes toolbar disappeared
  • KEIKAI-189 - missing data validation drop-down icon
  • KEIKAI-190 - Clear filter does not always work
  • KEIKAI-191 - paste a data validation causes an IllegalStateException
  • KEIKAI-192 - keikai can't evaluate EOMONTH after upgraded from ZSS
  • KEIKAI-195 - observed thick border when hiding headers
  • KEIKAI-196 - a row height shrinks unexpectedly
  • KEIKAI-201 - evaluate a named range throws IndexOutOfBoundsException