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

Released: Jan 25, 2022

15 中的更新

特性

TableSheet and Data Manager

• Two of the most significant features we have added to SpreadJS v15 are the TableSheet and Data Manager. The SpreadJS TableSheet is a new type of sheet component that is an extremely powerful data table that can also take full advantage of the existing 500+ function SpreadJS calculation engine. This quick, data-bound table view includes a relational data manager that makes sorting, filtering, and many other data management functions incredibly fast.

PivotTable...

Released: Nov 29, 2021

14.2.4 中的更新

修補程式

• Chart logarithmic scale axis could not be removed.
• A security breach in jszip was found.
• Removing data series from a chart would change the color of data markers.
• The table name would display incorrectly after inserting a table column.
• An exception would be thrown if a blank chart was saved using toJSON.
• Inserting a copied row would change the height of the remaining rows in the sheet.
• Importing a specific Microsoft Excel file with a PivotTable would throw an error.
• The selected cell would...

Released: Nov 10, 2021

14.2.3 中的更新

特性

• Added support for Apple iOS 15 and iPadOS 15.
• Accessibility content has been enhanced.

修補程式

• The value from a MATCH formula that references a PivotTable range was incorrect.
• A custom formula would not show in edit mode.
• The workbook would not display correctly after switching sheets.
• The context menu would not work correctly after 14.2.0.
• The “Margun Gothic” font was missing in the designer font dialog.
• Specific keyboard shortcuts were not working.
• The merge cell operation was not synchronized...

Released: Oct 27, 2021

14.2.2 中的更新

修補程式

• Dynamic arrays in an exported Excel file would display a "#spill" error if DoNotRecalculateAfterLoad was set to true.
• Dynamic array formulas would have an extra "@" after exporting to Microsoft Excel.
• A formula result changed after importing an SSJSON file.
• An error would show in the console after setting repeatRowStart and repeatRowEnd.
• Custom AutoFilters would cause SpreadJS to become unresponsive if the first option is left blank.
• The web browser would hang after pressing Command + Z...

Released: Sep 22, 2021

14.2 中的更新

特性

• The Designer now supports the Go To Special feature to select a special group of cells in the worksheet.
• Additional keyboard shortcuts have been introduced.
• Users can now bind file import events in the Designer Component.
• The Designer now supports the Find and Replace function.
• The Designer UX has been enhanced.
• The Designer Component now includes a d.ts definition file with the React module.
• The Name Box in the Designer can now be used to work with cell ranges.
• Users can now customize the...

Released: Aug 26, 2021

14.1.6 中的更新

修補程式

• Chart text partially covered.
• Pivot: A specific Excel file with a PivotTable was not correctly imported.
• Cells are not indented when opening up an exported Excel file in WPS.
• Chart: Charts with external data links do not import correctly.
• Designer: Field positions when dragging fields from the template designer into the worksheet are not correct.
• Conditional formatting has no effect after exporting Excel files and opening in WPS.
• Chart : XY Scatter chart X-axis would import as dates.
• Pivot...

Released: Aug 12, 2021

14.1.5 中的更新

修補程式

• Designer: Fill color would not show inside the conditional format dialog.
• Designer: The icon for the data validation prompt was missing.
• Pivot: Dragging fields from row to columns sections in the pivot panel would change the state to dirty.
• Pivot: Pivot Panel would not be active if there were two SpreadJS instances.
• Shape fonts and positions would not show correctly when exported to PDF.
• Setting rows to invisible would cause shapes to disappear.
• Shapes couldn’t be moved correctly in an...