ZK Spreadsheet 3.9.1 Release Note

The 1st embeddable Ajax spreadsheet for Java Web application!


Released on Nov. 29, 2016.


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.9.1 is an upgrade release that supports new features such as Support F2 to toggle arrow keys's function when editing formula, T.DIST.2T and T.DIST.RT from Excel 2010, etc.


Feature Highlights

  • ZSS-1274 - Support F2 to toggle arrow keys's function when editing formula
  • ZSS-1210 - Support Excel 2010 statistical functions: BINOM.INV, NORM.INV, LOGNORM.DIST, LOGNORM.INV, BETADIST, BETAINV, CRITBINOM, CHISQDIST, CHISQ.INV, CORREL, EXPONDIST, LOGINV, NORMDIST, NEGBINOMDIST, POISSON, POISSON.INV
  • ZSS-1235 - Support those statistical functions renamed in Excel 2010: BINOM.DIST, CHISQ.DIST.RT, CHISQ.INV.RT, EXPON.DIST, F.DIST.RT, F.INV.RT, GAMMA.DIST, GAMMA.INV, HYPGEOM.DIST, MODE.SNGL, NORM.DIST, POISSON.DIST, RANK.EQ, STDEV.S, STDEV.P, T.INV.2T, VAR.P, VAR.S, WEIBULL.DIST
  • ZSS-1236 - Support T.DIST.2T and T.DIST.RT from Excel 2010



What's New

  • New Features Tracker
    • ZSS-1210 - Support Excel 2010 statistical functions: BINOM.INV, NORM.INV, LOGNORM.DIST, LOGNORM.INV, BETADIST, BETAINV, CRITBINOM, CHISQDIST, CHISQ.INV, CORREL, EXPONDIST, LOGINV, NORMDIST, NEGBINOMDIST, POISSON, POISSON.INV
    • ZSS-1235 - Support those statistical functions renamed in Excel 2010: BINOM.DIST, CHISQ.DIST.RT, CHISQ.INV.RT, EXPON.DIST, F.DIST.RT, F.INV.RT, GAMMA.DIST, GAMMA.INV, HYPGEOM.DIST, MODE.SNGL, NORM.DIST, POISSON.DIST, RANK.EQ, STDEV.S, STDEV.P, T.INV.2T, VAR.P, VAR.S, WEIBULL.DIST
    • ZSS-1236 - Support T.DIST.2T and T.DIST.RT from Excel 2010
    • ZSS-1262 - Improve sorting performance
    • ZSS-1267 - Show busy message for client-side rendering
    • ZSS-1274 - Support F2 to toggle arrow keys's function when editing formula
    • ZSS-1283 - Improve the performance for initializing cells with formulas
  • Bugs fixed
    • ZSS-1209 - error message inserting math operators after parenthesis
    • ZSS-1238 - Inserting a URL into a cell causes it locked
    • ZSS-1256 - deleting a row causes ArrayIndexOutOfBoundsException
    • ZSS-1257 - Conditional formatting displays incorrect result when using row()
    • ZSS-1259 - The validation dropdown is cut when it is in the last row
    • ZSS-1261 - custom sort doesn't show available column when selecting 1 cell
    • ZSS-1266 - Cannot select an item in a validation dropdown
    • ZSS-1269 - Cannot evaluate eomonth() in lower case
    • ZSS-1270 - Conditional formatting cannot accept empty string formula
    • ZSS-1271 - Conditional formatting work incorrectly when using a formula
    • ZSS-1275 - When sheet protected and not allowed to insert link; the inserted LINK should be a String
    • ZSS-1276 - Some CSS class names are generated incorrectly with ZK 8.0.2
    • ZSS-1277 - copy the whole row doesn't copy the row height
    • ZSS-1280 - Deleting rows causes ConcurrentModificationException
    • ZSS-1281 - display an unexpected grey area in a file with a frozen panel
    • ZSS-1284 - Row insertion during initialization causes NPE