SpreadJS 17.1.5

Released: Sep 10, 2024

Aggiornamenti in 17.1.5

Funzionalità

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

Correzioni

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