Released: Jul 11, 2024

17.1.1 中的更新

修補程式

• AutoFill now supports structured reference adjustments.
• Some cells with data validation were incorrectly locked.
• Pasting over text would incorrectly add a line break.
• Copying sheets did not work properly.
• The InvalidOperation event was not triggered after filtering a locked cell.
• Text incorrectly automatically wrapped when cells were copied from Excel to SpreadJS.
• The font size of a rich text cell incorrectly changed when the scaling was set for printing.
• Calculation Fix
  • The INDIRECT function behaved differently from Excel.
  • The iterative calculation functionality worked differently from Excel.
  • A formula result is different when setting ExcelCompatibleCalcMode to true.
  • An issue was present with circular calculations.
• Data Manager Fix
  • Changing a column name would incorrectly change the caption.
• Designer Fix
  • The printing function did not work properly.
• ExcelIO Fix
  • Exporting to SJS after merging cells would cause merged cells to disappear in specific circumstances.
  • Custom name formulas were incorrect after exporting to SSJSON.
• PivotTable Fix
  • Refreshing a PivotTable would not work after modifying the data source.
  • The GetPivotData formula result was not correctly displayed after exporting to Excel.
• ReportSheet Fix
  • Importing some templates would cause unresponsiveness.
  • Template pagination was incorrectly set even when some templates did not have pagination.
• Table Fix
  • Formula chain reference behavior was incorrect when deleting columns from a table.