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.
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.
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 |
In previous versions, undo and redo for custom commands had to be handled with multiple functions. Now the user only needs to define the "execute" function, making it much simpler.
SpreadJS now supports tree hierarchies in the filter dialog, useful for dates and outlines. The hierarchies support conditional filters like text, number, and date, as well as color.
More protection options have been added to the sheet, including allowDragInsertRows/Columns, allowInsertRows/Columns, and allowDeleteRows/Columns. These options can also be set in the designer.
You can now add custom icons for individual IconCriterion in a custom icon set.
Diagonal line borders are now supported in cells and ranges. Several line styles are included, and they're supported in JSON serialize/deserialize, ExcelIO, and printing.
SpreadJS now supports vertical text in cells, just like Excel. Properties include alignment, indent, word-wrap, etc.
This feature is similar to the single underline support currently in SJS, but now provides a double underline option—ideal for any financial or accounting application. This also works well with the Cell Alignment, ForeColor, WordWrap, Indent, ShrinkToFit, and CellOverflow options.
For a detailed listing of fixed issues, please see the Release Notes for each platform.
SpreadJS now supports being used with the React and Vue.js frameworks! This includes specific tags as well as elements and events that make using the two together easy. With SpreadJS being released on NPM, you can use it with the frameworks by either using traditional HTML or the NPM package.
SpreadJS has now been publicly released as an NPM package! The package can be downloaded and used in your applications. Read more
To install the SpreadJS NPM Package, simply install it by using the command line:
npm install @grapecity/spread-sheets
You can also use the Package Manager in Visual Studio 2017 and search for "grapecity".
You will now be able to customize how the range group interface looks using CSS classes. This includes the icon, lines, group dots, and the outline area.
The sheet area now has an offset, which fixes issues where borders did not show.
Previous:
Now:
Read more about sheet area offset
For a detailed listing of fixed issues, please see the Release Notes for each platform.
Updates for SpreadJS v11
SpreadJS v11.2 - July 25, 2018
See Maintenance Releases Following This Release
SpreadJS v11.1 - April 25, 2018
See Maintenance Releases Following This Release
SpreadJS v11 - December 6, 2017
See Maintenance Releases Following This Release
Related Links