SpreadJS 11's set of JavaScript libraries has been enhanced to solve even more of your spreadsheet and data grid needs. We have fixed customer-reported issues and added a few different enhancements that will make SpreadJS the only spreadsheet component you will need.

Chart Support

Spread Sheets can now successfully import and export Excel files with charts. With Spread Sheets, customers can make changes to those charts, and developers are given the tools to add and edit charts with the Spread Sheets Designer. New charts include column, bar, line, pie, doughnut, area, scatter, bubble, stock, and combination.

Combination charts

Scatter charts

Line, stacked column, pie

Stylized stacked column

New function support: 462 total!

SpreadJS now features a more extensive function library with 462 functions—more than any other spreadsheet component! The functions are for use in scientific, statistical, engineering and business formulas:

ACOT F.INV NORM.S.DIST
ACOTH F.INV.RT NORM.S.INV
AGGREGATE F.TEST NUMBERVALUE
ARABIC FILTERXML PDURATION
AREAS FINDBs PERCENTILE.EXC
ASC FISHER PERCENTILE.INC
BAHTTEXT FLOOR.MATH PERCENTRANK.EXC
BASE FLOOR.PRECISE PERCENTRANK.INC
BETA.DIST FORMULATEXT PERMUTATIONA
BETA.INV GAMMA PHI
BINOM.DIST GAMMA.DIST POISSON.DIST
BINOM.DIST.RANGE GAMMA.INV QUARTILE.EXC
BINOM.INV GAMMALN.PRECISE QUARTILE.INC
BITAND GAUSS RANK.AVG
BITLSHIFT HYPERLINK RANK.EQ
BITOR HYPGEOM.DIST REPLACEBs
BITRSHIFT IFNA RIGHTBs
BITXOR IFS RRI
CEILING.MATH IMCOSH RTD
CEILING.PRECISE IMCOT SEARCHBs
CELL IMCSC SEC
CHISQ.DIST IMCSCH SECH
CHISQ.DIST.RT IMSEC SHEET
CHISQ.INV IMSECH SHEETS
CHISQ.INV.RT IMSINH SKEW.P
CHISQ.TEST IMTAN STDEV.P
COMBINA INDIRECT STDEV.S
CONCAT INFO SWITCH
CONFIDENCE.NORM ISFORMULA T.DIST
CONFIDENCE.T ISO.CEILING T.DIST.2T
COT ISOWEEKNUM T.DIST.RT
COTH JIS T.INV
COVARIANCE.P LEFTBs T.INV.2T
COVARIANCE.S LENBs T.TEST
CSC LOGNORM.DIST TEXTJOIN
CSCH LOGNORM.INV UNICHAR
DAYS MAXIFS UNICODE
DBCS MIDBs USDOLLAR
DECIMAL MINIFS VAR.P
ENCODEURL MODE.MULT VAR.S
ERF.PRECISE MODE.SNGL WEBSERVICE
ERFC.PRECISE MUNIT WEIBULL.DIST
ERROR.TYPE NEGBINOM.DIST WORKDAY.INTL
EXPON.DIST NETWORKDAYS.INTL XOR
F.DIST NORM.DIST Z.TEST
F.DIST.RT NORM.INV

We've added the following enhancements to SpreadJS:

  • The HitTest functionality is now supported at the workbook level.
  • Columns can now be easily indented for tree structures.
  • Events have been added for when sheets are moved around.
  • The Hyperlink Cell Type now supports callback actions when the users clicks on them.
  • Text cell types can now be vertically aligned in edit mode.
  • The formula text box can now be used inside of cells.
  • Hyperlinks can now utilize the textIndent property.
  • Our SpreadJS JSON file size has been reduced by matching Excel’s validation feature storage.
  • The Excel quote prefix feature is now supported.
  • Gridlines and borders for the first column and row now show completely after printing.
  • Excel 2013-2016 functions are now supported.
  • Cells can now be merged with drag selection.
  • Added a comment property to the NameInfo class.
  • The Excel Accounting format is now supported.
  • Hyperlinks can now utilize the wordWrap property.
  • ToJSON and FromJSON now have enhanced options.
  • Support for exporting to PDF files has been added.
  • Context menus have been added.
  • You can now use built-in context menus in SpreadJS for user actions instead of having to build them from the ground up.
  • UMD patters and the NPM server are now supported.

For all the details and bug fixes, check out What's New in SpreadJS 11

Get SpreadJS 11 now