Released: May 22, 2025

18.1.1 での更新項目

不具合の修正

• Calculation Engine:
  • Fixed a calculation engine bug where configuring PrintArea caused the AsyncFunction to trigger four recalculations.
  • Non-volatile Async Custom Function calculated the second time Print tiles were set.
  • Fixed an incorrect Formula Evaluation After Excel Import – SUMIF with Entire Column Reference and Use of addRows.
  • Fixed issue where import of sjs file failed.
• DataChart:
  • Changing chart type removed the existing bindings.
• Data Validation:
  • DataValidator reference did not change after change sheet named excel.
• Designer Component:
  • Set "Print entire workbook" as the default option.
  • Fixed a Cell Style display error when theme color is set.
  • Font Style Are Overridden to default in SpreadJS when applying the conditional formatting.
  • Changed the function name in lamda dialog as per language.
  • Cell Format Dialog stops working on copied rows from TableSheet.
• Filter:
  • Filtering text that contained whitespace characters worked differently than in Excel.
• GanttSheet:
  • [Designer Component]{v18.0.7} Adding/Editing GanttSheet Task Breaks Workbook Grid and Sheet Tabs.
• Report Sheet:
  • Fixed an error where there was no indentation and when there was one indentation, the preview effect was the same.
  • The data source panel cannot search for fields.
• SJS Server:
  • Fixed tag lost in collaboration save.
  • Fixed an issue where the page appeared empty when another user set a pivot field during Collaboration.
  • Corrected a bug that prevented row tags from being deleted during Collaboration.
• TableSheet:
  • Styles Not Persisting in Exported Excel File from TableSheet.
• Worksheet:
  • The areas obtained by getUsedRange were incorrect.
  • TypeError was thrown on calling moveTo method.