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.