SpreadJS 18.0.1

Released: Jan 2, 2025

18.0.1 での更新項目

不具合の修正

  • Fix:
    • A header image was not correctly displaying in WPS.
    • Scaling the worksheet size incorrectly altered the text layout in an area camera shape.
    • Formulas could not be copied using the copyTo method.
    • An issue was happening with the DataSource table column visible property.
    • ReportSheet image formats were not working correctly.
    • After filtering, data that was pasted into other sheets was incorrectly changed.
    • Pixel based scrolling would cause display issues.
    • The CalcArray.toArray result was not correct in certain circumstances.
    • The toggleCollapseState API was not working correctly.
    • Setting incrementalLoading when using fromJSON threw an error.
  • Calculation Fix:
    • After modifying a value, a formula would not calculate.
    • The result of a formula was not displayed correctly.
    • Formula results were inconsistent.
    • A formula was not automatically calculated after importing a file.
    • The WORKDAY formula was giving a different result compared to Excel.
    • The VLOOKUP formula with a Wildcard Character was giving a different result compared to Excel.
  • Chart Fix:
    • A chart position was incorrect when rows were hidden while events were suspended.
    • A chart's percentage label was not displayed correctly.
    • A pie chart was incorrectly converted to a bar chart.
    • A char was not displayed correctly after importing an Excel file.
  • Designer Fix:
    • A data source field was incorrect.
  • ExcelIO Fix:
    • A cell's foreColor was changing in a Pivot Table after exporting.
    • The autoFitColumn feature did not work after importing an Excel file.
    • An error occured when exporting to XLSX.
    • Rendering of an imported chart was incorrect.
  • File Fix:
    • A specific SJS file could not be opened.
  • PDF IO Fix:
    • The font in the area snapshot of an exported PDF was changed.
  • Performance Fix:
    • Copying and pasting was slow with hidden rows.
  • PivotTable Fix:
    • An ampersand was not correctly displayed when re-opening a workbook with a PivotTable.
  • Shape Fix:
    • A picture shape of frozen rows was visible when hiding rows.
    • A camera shape was having an issue with QR codes.
  • Table Fix:
    • Table resizing was not working.