Released: Jun 5, 2025

18.1.2 中的更新

修补程序

• Data Binding:
  • The SpreadJS custom asynchronous function was triggered to execute twice after the setDataSource method is called.
  • The formula calculation in the first sheet affected the table binding speed of the second sheet.
• Filter: The tree node structure in the row filter was incorrect.
• Calculation Engine:
  • Result of COUNTIF and SUMIF was different from Excel comparing '-', '-'.
  • After exporting to Excel, the arc @ symbol in the formula caused calculation errors.
  • If you export ssjson, then import SpreadJS, the formula has an "@" symbol added.
  • setDataSource took a long time.
  • The spreads getPrecedents method did not support cross workbook formulas.
  • The result of the dot operator was null or undefined, and the calculation result was CalcError.
  • Formula resulted in a #Value! error when an XLSX file loads in SpreadJS.
  • The formula did not calculate as expected.
• Designer Component:
  • Data Manager did not set the schema column type by default.
  • CSS Leakage from SpreadJS "disabled" class affected global input styles.
• Worksheet:
  • Clarification on onClear hook behavior in Data Provider.
  • autoFitRows and autoFitColumns methods were optimized to only calculate used ranges.
  • Date pasted in Italian culture was parsed as English format after applying format.
• Workbook: Changed the default JP font of "Office" theme.
• Excel IO: Undefined length error was caused when saving or exporting large dataset.
• Report Sheet: [ReportSheet] Refresh() after RenderMode() returned an error.