Enhancements from the Previous Release

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

• The easy outline feature using column indents has been added.

• The Hyperlink cell now supports call back actions.

• The Hyperlink cell now supports word wrap.

• The hitTest method has been added to Spread.

• The SheetMoved and SheetMoving events have been added.

• Vertical alignment is now supported while editing a cell.

• Indenting text now works with Hyperlink cells.

• The suspendDirty, resumeDirty, and isDirtySuspended methods have been added.

• Many new formula functions have been added.

• The allowUserDragMerge option has been added.

• The DragMerged and DragMerging events have been added.

• The accounting format is now supported.

• The OutlineColumn is now supported.

• The export to PDF is now supported.

• The UMD pattern is now supported.

• Eight chart type groups, comprising 28 chart types, have been added. Also provided support for combo chart ability which could combine multi-chart typess in one.

• Context menu has been added to the workbook.

• Widget Features

Changes from the Previous Release

This version of the product has the following changes.

• The built-in formula editor displays additional colors.

• Using a quote as a prefix to store a string is now supported.

• The NameInfo constructor has an additional parameter.

• The addCustomName method has an additional parameter.

• The Spread schema has been updated.

• The Workbook toJSON and fromJSON methods have additional parameter options.

Resolved Issues

The following issues have been resolved since the last release.

• Cell borders now print correctly when the showBorder method is false.

• Contents of formula TextBox can now be correctly copied. [240268]

• Computational error with formula is no longer observed. [240451]

• Cell lock issue and border width issue are now fixed. [240109]

• RangeChanged event now returns consistent data on pasting a value in a cell and putting formula in the same cell. [241203]

• SelectionChanged event now fires correctly. [227675]

• SetRowVisible now works correctly after importing an excel file with hidden rows. [237749]

• Client ExcelIO now works correctly in IE10. [242866]

• RepeatRow setting now works correctly when setRowPageBreak is used. [242802]

• Formula now displays correctly in tableBind sample. [242737]

• Cursor of float object no longer moves when mouseover locked float object. [243266]

• Copying a cell with "=" value and pasting it to another spread now works correctly. [243264]

• CORREL, SLOPE, and INTERCEPT functions now work correctly in SpreadJS Designer. [243125]

• Importing excel with formulas into SpreadJS Designer no more give formula errors. [243295]

• SpreadJS navigation now works correctly on pressing command+f then arrow key in 64-bit mac chrome. [243947]

• Named ranges do not show error upon exporting .xlsx file from SreadJS Designer. [243875]

• Time to load group on using Spread.SuspendPaint() method is now reduced. [244337]

• Formulas no longer get prefixed with "_xlfn" on importing attached Excel file in SpreadJS [244391]

• Loading an imported excel file with unsupported local id (symbol) no longer throws exception. [242765]

• SpreadJS no more throws exception while exporting excel with printInfo settings containing JP font style to PDF. [232533]

• Formula is now shown correctly and excel file opens without error when the excel file with cross workbook reference is imported to SpreadJS and exported to excel again. [226931]

• Performance of setFormula code is now improved in binding mode. [241002]

• SelectionPolicy.single no longer disables [Tab] key navigation. [241853]

• VALUE() function now gives correct result. [240101]

• Touch resize indicator is no more shown in protected sheet. [242378]

• Exported excel now opens correctly on setting conditional format and exporting to Excel using Excel IO component. [239281]

• Sheet paint suspend status is now correct after reset. [245639]

• The full column condition formula now works correctly on setting SaveBothCustomRowAndColumnHeaders while exporting. [234545]

• Code to update data source now works correctly in Angular sample. [245474]

• Select Range border of a column that is frozen and hidden is now visible. [244536]

• Header cells of SpreadJS can now be correctly copied and pasted to Excel. [246548]

• Contents of cells containing text within '<>' tags can now be correctly copied and pasted to another cell. [245487]

• Contents of cells are now correctly copied from excel file and pasted to Spreadsheet without creating extra spaces. [246214]

• Spreadsheet with formula containing special sheet reference now opens without error in MS Excel 2007. [246452]

• Html content can be correctly copied and pasted to Spreadsheet. [246457]

• ColumnName no longer changes on moving and copying table. [247078]

• Exported excel file now opens correctly in Excel 2007. [246148]

• Imported excel file now retains the column width [246844]

• INDIRECT formulas now work correctly. [245724]

• Performance of filtering and modifying formula has now been improved. [247472]

• Workbook can now be correctly imported into a new sheet in a separate workbook. [247380]

• New annotations can now be correctly saved. [247229]

• Formula can now be updated without error. [247469]

• Formula text box now works correctly while switching sheets. [247572]

• Moving mouse over SpreadJS after calling resumePaint() method no longer gives error. [247296]

• Groups are now properly loaded in SpreadJS. [247565]

• Editing an invalid formula no longer throws exception. [248545]

• Position of frozen line is now correct with hidden rows and columns in the frozen area. [249715]

• Cells that contain different fonts and size characters are now rendered correctly. [249724]

• Complex Formula DataValidation now calculates correctly. [249992]

• Background color now renders correctly on importing custom theme file. [249710]

• User no longer needs to undo pasting on canceling pasting in ClipboardPasting. [248974]

• File exported with SpreadJS no longer gives error. [248770]

• Behavior of SpreadJS is now consistent with MS Excel and sheet can no longer expand group when cell is editing. [245606]

• DataBar rule now works correctly for negative values as well. [248395]

• EditChange event now fires correctly in FireFox with IME input. [248663]

• Value of formula no longer changes on exporting the excel file by client side ExcelIO. [248666]

• Floating objects are now rendered correctly on the exported excel file containing images. [248397]

• Images in the imported excel files are now imported correctly. [249133]

• INDIRECT formula now works correctly in the excel file imported to SpreadJS. [249367]