Enhancements from the Previous Release

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

• SpreadJS now supports ReactJS allowing users to build UI for web and mobile applications.

• Users can now build complex UI and web applications using VueJS.

• With the support for sheet area offset functionality, the outlines in the worksheet will be displayed even when the row/column header is hidden.

Changes from the Previous Release

This version of the product has the following changes.

• The appearance of range groups can be customized using different CSS classes.

Resolved Issues

The following issues have been resolved since the last release.

• Formulas and zeros now work correctly in an iOS application while loading the Excel file into SpreadJS. [251322]

• XIRR function now calculates accurate result. [252262]

• SUM function now calculates accurate result. [254207]

• The delete row operation now works appropriately after applying filters. [254409]

• The "Format Cells" dialog in SpreadJS Designer appears without any issues. [256249]

• The formula bar now works correctly when it gets focus with tab. [256290]

• The calculation precision issues have been fixed. [256943]

• The formula involving ZA column reference is changed to AA. [257196]

• The data "1E","2E",.. entered in the cell is converted to scientific notation without any issues. [257471]

• While exporting PDF, the canvas.arc now remains intact at its correct position. [257491]

• The results calculated by the calculation engine are now consistent with Excel. [257630]

• While performing the copy or paste operation in SpreadJS and while changing the row count, no exceptions are thrown. [257912]

• While exporting the PDF, the position of words is accurate. [258080]

• Formula calculation results are correct now. [258357]

• QualityFactor method now uses correct print layout. [258360]

• After importing the Excel file, numbers can be correctly copied from it. [258499]

• All the options now work appropriately after initialization of the Spread workbook. [258593]

• After performing the zoom out operation in Spread, the content and images are now displayed correctly. [258595]

• When SpreadJS includes the CJK character, the pdf export content can be managed without any hassle. [258806]

• The AVERAGEIF function now calculates accurate result even when one of the cells is blank. [258892]

• The word wrap feature now works correctly after the cell padding is set. [258954]

• Importing excel with shared formulas no longer throws any errors. [259112]

• The span feature now works without any errors after inserting rows. [259268]

• The format result of "hh:mm:ss:" is now correct after Chrome update. [259287]

• Table binding works appropriately even when the sheet is inactive. [259297]

• Browser no longer crashes after importing excel file containing CDATA. [259469]

• Users can now select the cell while editing formula by cross sheet. [259501]

• IRR function now calculates accurate result. [259515]

• While exporting Excel without formula, the date is correctly displayed. [259606]

• The result of AsyncFunction is now correct in print and export PDF operations. [260112]

• The JSON generated by the client side excelio follows SpreadJS JSON schema.[260098]

• The .xlfn prefix in formulas is now handled correctly. [260266]

• Exporting big row count to excel no longer throws an exception. [259428]

• While performing the import operation on frozen row or column, the worksheet can be scrolled vertically. [260033]

• The columnHeadersAsFrozenRows property can export the text of columnHeader. [260166]

• Charts are displayed appropriately in imported worksheets after the import operation is complete. [260441]