Released: Sep 10, 2024

Updates in 17.1.5

Funktionen

• Vue wrapper support has been added to the TypeScript Definition file.
• Vue wrapper support for the Designer has been added to the TypeScript Definition file.
• Filter items can now be checked/unchecked with keyboard shortcuts.

Fehlerkorrekturen

• The masking caret position was incorrect.
• Setting background color for cells was not working properly in certain circumstances.
• A row couldn't be removed if the removeRow method was used several times.
• A drop-down list does not appear in the right location for a text box.
• Issues would occur when entering formulas with a Turkish keyboard.
• Defining column currency caused strange behavior.
• A TypeError would occur when dragging calculated column fields to group them.
• The scrollbar would automatically scroll up after released by the mouse.
• A date format was incorrectly changed when copying and pasting from Excel to SpreadJS.
• Auto-filling a table would incorrectly add new rows.
• The range selector would not work in a SUM formula with the Alt+ shortcut.
• A shape was incorrectly copied when using copyTo span.
• A shape could not be dragged when the mouse is hovered over an inserted picture.
• The SheetChanged event was not working properly.
• Unlocked cells would become locked after pasting.
• The filter range could not be expanded after using setDataSource.
• Copying a blank cell from Excel could not be pasted.
• Calculation Fix:
  • isCircularReference was incorrectly false in the UserFormulaEntered event in some circumstances.
• Demo Fix:
  • Angular demos have been updated to use the standalone component.
  • React demos have been updated to functional component samples.
• ExcelIO Fix:
  • An error occurred after loading and exporting an Excel file.
  • A formula was lost after exporting to Excel.
• IO Fix:
  • Opening a SJS file was slower than a SSJSON in certain circumstances.
  • Opening a template file would cause isFileModified to be true if an IMAGE formula exists.
• Performance Fix:
  • A workbook would freeze when attempting to bulk edit font styles.
  • Using rowFilter to sort would freeze the sheet in some circumstances.
• PivotTable Fix:
  • After exporting a PivotTable to Excel, the date format would incorrectly change.
  • PivotTable: The refreshed result of a PivotTable was inconsistent with Excel.
  • Calculation fields cause some issue.
  • Newly created calculated fields had default value.
  • There were inconsistencies with importing and exporting PivotTables.
  • The showDataAsList field was missing after a PivotTable was serialized.
• ReportSheet Fix:
  • Setting protection options on a ReportSheet would change after importing again.
  • An exception would occur after copying the report.