SpreadJS 18.0.3

Released: Feb 13, 2025

Mises à jour de 18.0.3

Correctifs

  • Miscellaneous:
    • A template preview effect was not consistent.
    • Arrow key navigation was slow.
    • The transpose pasting effect was inconsistent with Excel.
    • The padding text for a cell resulted in an incorrect font style.
    • Conditional formatting formula incorrectly applied a prefix.
    • Color is lost after using auto wrap in Rich Text.
    • A red mark would appear in the corner of a cell when modifying the value in preview mode.
    • Different values of a bound column could not be edited.
    • Vertical mode character display was inconsistent with Excel.
    • Adjusting the top row height doesn't trigger the TopRowChanged event.
    • In some circumstances, filter items would not appear in a filter box.
    • Some definitions were missing in gc.spread.sheets.d.ts.
    • Font names were not matching between the ribbon and a dialog.
    • The linked cell value of a checkbox did not correctly set the checkbox.
    • The async function was incorrectly evaluated every time a row was added to a table.
    • SetDataSource with a field name that contained Chinese characters would cause it to fail.
    • The page would crash in some circumstances after modifying cell values.
    • Setting cancel to true in the ClipboardPasting event would cause issues in some circumstances.
  • Excel IO:
    • Grouping was lost after importing an Excel file.
    • The font color in a table would change after exporting to Excel.
    • Column width would become wider after importing an Excel file in macOS.
    • Form protection would be lost after importing a file.
    • Footer image sizes change when exporting to Excel.
    • Exporting an automerged cell with source binding caused issues in the Excel file.
    • Using the BC_CODABAR formula would sometimes cause crashes when exporting.
  • PivotTable:
    • An exception was thrown when a PivotTable was refreshed.
    • Creating a PivotTable did not trigger the activeSheetChanged event.
    • Dynamically introducing PivotTable resources incorrectly shows the panels in English.
    • Setting a number format would throw an error.
    • A PivotTable had some performance issues.
  • ReportSheet:
    • An issue was occurring with date filters in a ReportSheet.
    • Exporting a ReportSheet to PDF caused issues.
  • TableSheet:
    • A definition regarding TableSheet was missing in the definition file.
    • AllowExtendPasteRange was not working as expected.
    • A value was not updating in the TableSheet after canceling a paste.
  • Documentation:
    • API documentation was incorrect.
    • A documentation page was incorrect.
  • Localization: Japanese resources were not properly applied in an exported Excel file.
  • GanttSheet: The FinishData was incorrect in the "Project Information" dialog.
  • Performance: A PivotTable had some performance issues.
  • Calculation: The INDIRECT formula was not working correctly.
  • Shape: Shapes are not displayed correctly in some circumstances with the addPictureShape method.
  • Chart: A border would incorrectly disappear when "Invert if Negative" was enabled.