Enhancements from the Previous Release

The following features have been added with this version of the product.                      

• Users can set diagonal line border in the cell in order to organize the complex data headers.
• The vertical text style is now supported, just like in Excel.
• The filter dialog has been enhanced in order to execute the sort and filter operations more smoothly.
• SpreadJS supports the hierarchial tree display in the FilterDialog ListBox wherein users can filter the date type data or group data by filter dialog.
• Custom icon sets are fully supported. Users can set a custom icon for each individual IconCriterion.  
• Users can use various protection options in order to protect a worksheet.
• SpreadJS supports double underline while setting text decoration in a cell. 

Changes from the Previous Release

This version of the product has the following changes.

• SpreadJS fully supports the undo and redo operations.

Resolved Issues

The following issues have been resolved since the last release.

• When the "ReCalc' button is clicked, the formula result generated is accurate.
• The TRIMMEAN function now calculates the result correctly.
• The behavior of MouseMove event is inconsistent with IE11 and Chrome.
• The import operation can now be executed significantly faster with many styles.
• Now, there is no difference between the Excel before import and after import.
• In the designer, the Y-axis is opposite to the X-axis at the bar chart.
• When the filter button is clicked, a cell click event is fired on Chrome, but no event is fired on iOS Safari.
• After excel import, charts in the column group are now shown correctly.
• There are some hidden columns that can be unhidden.
• The JSON template loads completely without any errors.
• When the frozen issue arises, the column width is adjusted.
• In the designer, the tag in the context menu is invalid.
• The images generated using the method SavePDF is now clear.
• There is no difference between RangeFiltering and RangeFiltered events.
• The SpreadJS drag-fill feature no longer shows #ref in this version.
• The outside formula textbox doesn't work in JP IME when it is running on Chrome.
• There are no memory leaks in Spread JS.
• The cell padding no longer shows weird behavior with word wrap and backcolor.
• The fomula =VALUE("-1") is #VALUE
• SpreadJS no longer crashes when the comments are added.
• The cursor cannot be moved to left/right key in the editable combo box.
• The auto size of the comments could not calculate correctly for CJK characters.
• There are no problems of formula with the Chinese input method.
• The source code in this version exports the excel font "Italic" correctly.
• There are no problems in formula input.
• The excel import operation crashes for the formula cell.
• When the add operation is performed in the Firefox browser, it no longer causes the page to be blank.
• SpreadJS doesn't show the touch toolbar or gripper when the cells are touched on Microsoft Edge.
• The floating objects can't be deleted on Mac operating system.
• The EvaluateFormula doesn't work correctly with the online demo.
• The floating objects set the first column or row position wrong.
• The Range Selector can't lose focus.
• The Destroy method causes an error in the JS file.
• [dbnum2] is no more different from Excel.
• The vertical scroll feature doesn't work after an Excel file is imported.
• When you set the frozen row or column count to 0, the sheet is not scrolled.
• The accounting format is now displayed correctly.
• POISSON.DIST and BINOM.DIST now work in SpreadJS
• The time taken to copy and paste data from Excel is now much faster. 
• SpreadJS no longer crashes after importing ssjson to delete rows or columns
• When copy paste operation is performed from SpreadJS to excel, the line width remains intact.
• The DateTime format now displays correctly when imported.
• Now, you can export data to Excel from JSON file.
• The filter is no longer different to Excel.
• The paste formula doesn't work on the Formula Textbox.
• The DEL keypress in the Microsoft Edge browser now works as expected.
• Importing a large Excel file now takes only 5 minutes.
• The line break feature no longer displays an error.
• The hidden row now doesn't gets displayed after importing to Excel.
• The formula in SpreadJS is no longer different to Excel.
• Now, there's no problem of cell level binding path.