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