SpreadJS 18.1.3

Released: Jun 19, 2025

18.1.3 中的更新

特性

  • Published Online Collaboration Demo.

修補程式

  • Calculation Engine fix:
    • Result of COUNTIF and SUMIF is different from Excel comparing 'ー', '―'.
    • Formulas fail to evaluate as expected when loading Excel file.
    • Adding name "Ynp1" throws invalid custom name error.
    • XIRR function calculates to incorrect result.
    • Prompt bindingPath error after upgrading version.
    • Export and import sjs setting includeCalcModelCache true, reference cell isn't updated.
  • Charts fix:
    • Loading files containing charts takes too long.
  • Command fix:
    • Hitting the ESC key does not get the cancelInput command in the command manager listener.
  • Conditional Formatting fix:
    • Out of memory when importing XLSX file.
  • Designer Component fix:
    • ConditionalFormats with FontSize doesn't work.
    • [Forguncy] reportSheet combo cells' value/text field UI order question.
    • Set Allow Dynamic Arrays to True in online Designer Demo.
  • Editing fix:
    • Right Arrow key doesn't work after pressing Home key with multi line cell.
  • Excel IO fix:
    • Using lazyMode, when the activeSheet is deleted, the content of the next selected sheet is empty.
    • Import file takes long time.
  • None Functionality fix:
    • Added information in doc about setting required to use UNIQUE formula.
  • Tables fix:
    • After the table above rebind the columns, the formula in the table below changes.
  • Worksheet fix:
    • Deleting first column of merged cells caused right border to disappear and span still exists.