SpreadJS Release Information

SpreadJS v11 - December 6, 2017

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.

New Function Support - 462 Total Functions

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

Other Enhancements to SpreadJS v11

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.

See Maintenance Releases Following This Release

SpreadJS v11.1 - April 25, 2018

Undo/Redo enhancement

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.

FilterDialog UI enhancement

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.

Protection Options Enhancement

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.

Custom IconSet

You can now add custom icons for individual IconCriterion in a custom icon set.

Diagonal line

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.

Vertical text

SpreadJS now supports vertical text in cells, just like Excel. Properties include alignment, indent, word-wrap, etc.

Double underline

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.

See Maintenance Releases Following This Release

SpreadJS v11.2 - July 25, 2018

SpreadJS Now Supports React and Vue.js

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 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".

Customize Range Group Interfaces Using CSS

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.