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.
This version of the product has the following changes.
SpreadJS fully supports the undo and redo operations.
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.