SpreadJS 新版本发表

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...

Released: May 3, 2023

16.1 中的更新

特性

PivotTable Enhancements

  • SubTotal Option for Single Fields - Enhanced PivotTable support by adding a subtotal option for single fields. Previously, SpreadJS would change the subtotal position to be at the bottom of each field. Now you can change the position for individual fields.
  • GetPivotData functions for PivotTable references - The "Use GetPivotData functions for PivotTable references" option has been added as an option for the formulas in the workbook and can be enabled or disabled. This...

Released: Dec 21, 2022

16 中的更新

特性

New File Format

  • Added a new, improved .sjs file format to improve the performance of importing large Microsoft Excel files while also creating a smaller, better-optimized file when saving.
    • Bypasses the previous need to first export to SSJSON.
    • Translates the data directly to the model.
    • The resulting data is saved to a zipped .sjs file with smaller SSJSON files, making it similar to Excel’s own XML structure.
    • Makes the ExcelIO process much faster and smaller.

TableSheet Enhancements

  • Hierarchy...

Released: Aug 25, 2022

15.2 中的更新

特性

Name Box Component

  • Added Name Box as a standalone component - The Name Box component is used to display selected ranges, items, named ranges, and create and navigate to custom names within a spreadsheet. The name box has several features:
    • The user can enter text into the name box:
      • If the text can’t be parsed into ranges, SpreadJS will create a custom name for the selected cells.
      • If the text can be parsed into ranges, SpreadJS will add those ranges as selections in the worksheet.
      • If the text...

Released: May 22, 2022

15.1 中的更新

特性

  • Cross Workbook Formulas - This new feature allows your users to enter formulas that contain references to data in other SpreadJS workbooks.
  • PivotTable Enhancements
    • Timeline Slicer Support - SpreadJS PivotTables now support timeline slicers, which give your users the ability to slice data by specific dates.
    • Show Items with no Data - By default, PivotTables will only display items containing data. With the new 'Show items with no data' option, you can enable the PivotTable to show these blank...