SpreadJS

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

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

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

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

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

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

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

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

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

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

Versionshinweise: Adds Gauge charts plus support for password-protected worksheets. 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 ...

Versionshinweise: Adds enhancements for TableSheet, Designer, Calculation, Shape, Workbook. 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 ...

Versionshinweise: Adds multi-select support to Table Slicer plus new Name Box component. 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 ...

Versionshinweise: Adds support for cross workbook formulas along with support for timeline slicers. Cross Workbook Formulas- This new feature allows your users to enter formulas that contain references to data in other SpreadJS workbooks. PivotTable Enhancements Timeline ...

Versionshinweise: Adds new data-bound table view that includes a relational data manager. 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 ...

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

Versionshinweise: Adds support for iOS 15 and iPadOS 15. 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. ...

Versionshinweise: Improves dynamic array formulas and cell merging. 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 ...

Versionshinweise: Adds support for Find and Replace. 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 ...

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