Enhancements from the Previous Release

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

• Widget Features
  • 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.

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 Spread.Sheets after calling resumePaint() method no longer gives error. [247296]
• Groups are now properly loaded in Spread.Sheets. [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 Spread.Sheets. [249367]