(Showing Draft Content)

Release Notes for Version 12.0.0

Enhancements from the Previous Release

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

  • Barcodes are now supported.

  • Rich text formatting is now supported in cells.

  • Radar, Sunburst, and Treemap chart types have been added.

  • Shapes are now supported.

  • Excel-like precision selection/deselection behavior is now supported.

Changes from the Previous Release

This version of the product has the following changes.

  • Animation is now supported in Column, Bar, Line, and Pie charts.

  • Color transparency can now be set in different chart elements.

  • Border and background color of chart legends can now be customized.

Resolved Issues

The following issues have been resolved since the last release.

  • The DATEDIF formula now calculates accurate result. [261230]

  • On clicking the gray area in Spread, the formula text box now does not append random numbers. [261278]

  • Values are now displayed properly on loading Excel and then exporting to Excel. [261144]

  • Format now returns the JavaScript precisions correctly. [261088]

  • Fixed the issue where pressing backspace key on a floating object made active cell editable. [261277]

  • Fixed the issue where picture borders appear different on importing Excel from that in the Excel display. [261743]

  • Fixed the issue where clicking "Check all" or "Uncheck all" caused browser to loose response. [261784]

  • Fixed the issue where conditional formatting on border is not applied after exporting to Excel. [261622]

  • Combo chart from Excel can now be imported correctly into SpreadJS. [261559]

  • Excel with namespace defined in xml node can now be loaded successfully. [261560]

  • The SpreadJS and Excel displays are now same. [261429]

  • Fixed the issue where clicking on Spread.Sheet, after importing Excel, caused blank display. [262293]

  • The SpreadJS performance now remains unaffected even when Excel containing INDEX formula is opened in Spread. [259806]

  • The cell alingment remains intact on changing cell value and while exporting to Excel. [262085]

  • Fixed the issue where the formatter round logic is different with Excel in negative value. [262366]

  • The precision issue in percentage format has been resolved. [262237]

  • The value format is now correctly displayed after export to Excel. [262095]

  • The COUNTBLANK formula is now calculated accurately. [261841]

  • The evaluation performance of SUMIFS function is now improved. [262583]

  • The worksheet operation response is now fast. [262253]

  • The zoom issue where content became blurred has been fixed. [258595]

  • The RANK function now gives the correct result in SpreadJS. [262719]

  • The CountIF formula now works correctly on importing Excel. [263024]

  • The Excel value now does not change on loading Excel file in SpreadJS. [263441]

  • Fixed some Excel importing issues. [262888]

  • Fixed the issue where 'workbookInitialized' event could not get sheet object. [263870]

  • Fixed the issues that caused loss of data binding on dragging swap columns in sheet. [264236]

  • The Lookup formula now evaluates correctly. [264538]

  • The exported Excel files now follow the Open XML specification. [264328]

  • The difference in performance issue while applying style on cell between SpreadJS "11.0.6" and "11.2.4" has been resolved. [263663]

  • Fixed the issue where backColor is null after import. [263964]

  • Fixed the issue where designer gets crashed on adding a chart while column header is selected. [263997]

  • Full DataRange area is now highlighted correctly on selecting Bubble chart. [260624]

  • Now FIXED formula calculates the result correctly. [261840]

  • Conditional formatting 'Fill No Color' now works correctly after save operation is performed. [264253]

  • The styles are correctly merged and applied on cells in SpreadJS designer, in the same way as in Excel. [264259]

  • Fixed the issue where exception is thrown while opening Excel in SpreadJS. [264411]

  • The Date column in table data binding exports properly to Excel. [264501]

  • Fixed the issue where excel containing formula with string concatenation is not loaded properly in Spread. [264553]