Released: Apr 18, 2024

17.0.8 中的更新

修补程序

• Calculation Fix
  • A formula result was incorrect when enabling calcOnDemand.
  • The result of the RANDBETWEEN function was not correct.
  • The result of the NETWORKDAYS function was not correct.
  • Turning off iterative calculation would result in different formula results.
  • The IMAGE function would not display correctly.
• Chart Fix
  • Charts were rendered incorrectly.
  • Data from hidden cells would not be displayed.
• Designer Fix
  • Setting a tooltip for drop down items would not work correctly.
• Excel IO Fix...

Released: Apr 10, 2024

17.0.7 中的更新

修补程序

• Calculation Fix
  • The arrow keys could not be used to reference a cell in a formula.

Released: Apr 3, 2024

17.0.6 中的更新

修补程序

• Angular Fix
  • The Angular version of the demo samples has been updated.
• Calculation Fix
  • Circular references would get stuck in large files.
  • The "COUNTA(UNIQUE())" formula behaved differently from Excel.
  • A drag and drop fill result was incorrect after enabling manual calculation.
  • A formula result was changed after upgrading to a newer version.
  • Some calculation results were inconsistent.
  • A formula result was inconsistent with Excel.
• Excel IO Fix
  • The text of a textbox was incorrect after...

Released: Mar 26, 2024

17.0.5 中的更新

修补程序

• Calculation Fix
  • The ISREF and INDIRECT functions would have different formula results.
  • A specific formula was incorrect.
  • The formula editor would show as undefined for the listSeparator when the culture was changed.
  • A custom function would not show in a sheet.
• Chart Fix
  • The order of charts in a combo chart would not stay the same when using JSON.
  • Restricting the number of series in a chart was not working correctly.
  • Horizontal axis units were inconsistent.
• Microsoft Excel Compatibility
  • Cell...

Released: Feb 28, 2024

17.0.4 中的更新

特性

• Added support for Next.js 14.
• Added support for Angular 17.

修补程序

• GanttSheet
  • GanttSheet tabs did not have a context menu.
• Filter
  • The filter function worked differently from Excel.
• Mobile
  • The Sheet bar couldn't be dragged properly.
• Calculation
  • The VALUE formula did not work correctly in some circumstances.
• Chart
  • The language of an imported chart series could not be changed correctly.
• Calculation
  • The GetPivotData formula did not display correctly after exporting to Excel.
• Excel IO
  • Exporting a...

Released: Feb 2, 2024

17.0.3 中的更新

特性

• Language Release
  • Korean Language release for v17.

修补程序

• Chart
  • The order of a combo chart series was inconsistent with Excel.
  • Updating a table used by a chart would throw an error.
  • A hyperlink's tooltip would not correctly display in certain circumstances.
• Name
  • The name manager would incorrectly show custom names after a sheet was deleted.
  • The distribute option didn't work properly with the ja-jp culture set.
• Performance
  • Clicking on a slicer would cause the page to freeze or crash in some...

Released: Jan 18, 2024

17.0.2 中的更新

特性

• Language Release
  • CN Language release for v17.

修补程序

• Chart
  • Chart content did not change with data.
  • A timeline is not displayed after importing.
  • A chart series did not display correctly.
  • A chart did not refresh with data changes in a table.
  • The position of a chart legend would change after exporting.
  • A radio button could not be selected.
  • The curve chart auto functionality did not work correctly.
  • Setting the data source for a table does not refresh the chart.
• Export
  • An exported file did not...

Released: Jan 5, 2024

17.0.1 中的更新

修补程序

• Calculation
  • A formula was automatically changed incorrectly.
  • A formula was not updated with the RemoveRow RowAction.
  • Certain formulas had incorrect results.
  • Some formulas would not calculate correctly after using resumeCalcService.
  • The lambda formula would not calculate correctly.
  • Deleting a row that contained bound data would prevent a referenced formula from being recalculated.
  • The COUNTIF formula did not calculate correctly.
  • There was a delay in calculating specific formulas.
• Chart
  • A...

Released: Dec 18, 2023

17.0 中的更新

特性

• Added new ReportSheet and GanttSheet add-ons.
  • ReportSheet is a simple and flexible way of creating complex reports. It supports data entry, pagination, data filtering, sorting, conditional formatting, and more.
  • With GanttSheet, users can assign different tasks to different resources to effectively manage tasks, schedules, and resources. You can also display the task progress status as a percentage in the 'complete' field.
• SpreadJS now supports shape-based charts to set the stack order of a...

Released: Aug 16, 2023

16.2 中的更新

特性

• Users can now recalculate formulas automatically or manually using the calculation options.
• Added support for setting the default active ribbon tab and get the same tab when the Designer Component is initialized.
• Added support for setting a default value of a cell when a cell has no data or values in the data source.
• Added support for selecting the date and number ranges using the date time picker dropdown and slider dropdown, respectively.
• Added support for using customized themes and font...