SpreadJS 18.0.7

Released: Apr 10, 2025

18.0.7 での更新項目

不具合の修正

  • Calculation Engine fix:
    • Cell reference is not updating.
    • Conditional formatting does not display consistently with Excel.
    • Formula String Lost After Import Xlsx To SpreadJS.
    • Inconsistency with Excel's calculation.
    • String In Date Format Will Regard As Date Value In SumIf Function.
    • The calculation results of the calculation worksheet and calculation are different.
  • Comments fix:
    • Import file annotations cannot be viewed.
  • ConditionalFormatting fix:
    • Conditional formatting not being displayed correctly when importing Excel file in SpreadJS designer.
  • Demos update:
    • Remove Vue2 Demos (now only Vue3 are hosted).
  • Designer Component fix:
    • Custom font family list take no effect from v18.0.3.
  • Events fix:
    • When worksheet is protected, clicking the row header or column header will also pop up the "Cell protected" prompt.
  • PivotTable fix:
    • The pivot table does not refresh correctly after modifying the name of value field.
  • Report Sheet fix:
    • An error of "getCells undefined" occurred when importing sjs.
    • File import and preview take a long time.
  • Shapes fix:
    • The 'toImageSrcSync()' method can only obtain the Base64 strings of some of the images in the sheet.
  • Tables fix:
    • Abnormal insertion of camera shape.
    • After the table is bound to Data Manager, an exception occurs after clearing the filter.
  • Worksheet fix:
    • Support for drag drop of data range.