In this article, you will find all of the SpreadJS bugs that were fixed in first release of SpreadJS V10.

To view the release notes, see here: SpreadJS Release Notes

To download Spread V10, click here: Spread Downloads

SpreadJS



  • The column header will now print when it is set after data binding.

  • The EDATE function now has the same result in both IE and Chrome.

  • Copying values with quotes from SpreadJS and pasting into notepad no longer appends extra quotes.

  • DragFillUndoAction performance has been fixed.

  • HTML exporting no longer results in black backgrounds in some cells.

  • SpreadJS files save correctly in Google Drive now.

  • Copying and pasting text with double quotes from Excel no longer selects an extra row in the SpreadJS Designer.

  • Scrolling now works with filters.

  • Hyperlink with different fonts doesn’t show as strikethroughs in Firefox anymore.

  • Using multiple filters now shows hidden values as well.

  • Deleting rows after applying filters now works.

  • The Expression range no longer changes after adding/deleting a row.

  • Group Rendering and AddRow performance issues have been fixed.

  • SUM formula now evaluates correctly in Chrome.

  • autoFitColumn() with the AutoFitType set to CellWithHeader now works in Chrome.

  • The SheetNameChanged event works in Firefox now.

  • The browser doesn’t go into an infinite loop anymore when the value of a word wrapped cell is a space and its column width is set to be very small.

  • The DataValidation list does not change behavior when opening the XLSX file in SpreadJS.

  • There is no longer an error when using cross-sheet references in formulas.

  • There is no longer unexpected scrolling when setting a frozen row.

  • ExcelIO import issues have been fixed.

  • Setting the cell border now works when a default style is applied for the sheet.

  • A problem with the SpreadJS Designer Excel file open feature has been fixed.

  • The onRowChanged event now has a return-type and doesn’t throw a typescript compilation error.

  • Duplicate items in the FilterDropDown that use the same word no longer use a blank space.

  • Performance issues with floating objects have been fixed.

  • The DataValidation dropdown no longer gets stuck when hiding the Spread control.

  • An optional parameter has been added to removeTable() to allow the user to just remove table styles without removing the entire table.

  • Can now bind some columns in a table while also keeping data in other columns.

  • Certain formulas now work correctly.

  • The result of the EOMONTH formula is now in line with Excel.

  • Copying the buttonCellType now updates references so that changing the text of the new button does not affect the original one.

  • Users can now set tables without headers.

  • Print issues when setting spread.scrollbarMaxAlign(true) have been fixed.

  • Excel import issues have been fixed.

  • Setting borders for cells in Excel to none still shows borders when importing into SpreadJS.

  • Users can now edit sheet names when Spread is in a modal dialog.

  • AutoFitRow issues when zoom is less than 1 have been fixed.

  • Importing an XLS file with cross-sheet references no longer shows an error in the cell.

  • When multiple headers are copied and pasted into a span cell, there is no longer an error when undoing.

  • The startSheetIndex is now updated when the user adds a sheet.

  • When there are multiple row headers in a span, the celltype mouse event now fires when the second row is clicked.

  • Grouping performance issues have been fixed.

  • Hyperlink rendering in Firefox has been fixed.

  • Merge sort performance has been enhanced for the unbound use case.

  • Fixed the data validation drop-down not being hidden.

  • Fixed calculation bugs related to circular references.

  • Fixed an issue with the dynamic data validation list.

  • Copying and pasting text with a double quote from Excel no longer selects an extra row in the SpreadJS Designer.