SpreadJS 新版本發表

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

Released: Jul 29, 2021

14.1.4 中的更新


  • Inserting formulas was enabled even though the sheet was protected.
  • Quotes were not automatically added when adding text to a formula.
  • Clicking a check box would take time to update the rest of the sheet.
  • The result of a formula was different from Excel.
  • PivotTable would update the data source incorrectly when incremental loading is enabled.
  • The GETPIVOTDATA formula would not return the correct value.
  • Cell formats would change after importing an Excel file.
  • An exported Excel file could not...

Released: Jul 16, 2021

14.1.3 中的更新


  • Specific charts would not display correctly.
  • DataLabels would not display in StackBlitz.
  • Setting focus to false inside of a button command would cause the button to lose hover style.
  • A specific chart would not import properly from an Excel file.
  • Specific charts would not import correctly.
  • Adding an input box to a context menu would result in an unresponsive input box.
  • The TableRowsChanged event would not fire correctly if a row was deleted via undo.
  • Designer: Sparkline options would not be...

Released: Jul 1, 2021

14.1.2 中的更新


  • Chart categories would not show the leading zero.
  • A specific chart would work in earlier versions but not in the latest version.
  • An exception would be thrown after removing a sheet.
  • A "#" character would be added to the end of a cell value when using the "0.0#%" format.
  • Printing a workbook would throw an exception.
  • Using FitPagesWide would cause a CheckBox icon to not show correctly after printing.
  • Designer: Adding conditional formatting would not work in some instances.
  • Exporting a file to...

Released: May 20, 2021

14.1 中的更新


Pivot Tables Add-on

  • New Add-on includes support for Pivot Tables, PivotPanel UI and Microsoft Excel import/export capabilities. Supports various pivot table functions like sorting, filtering, and grouping.

Camera Shape

  • Camera shape lets you create a dynamic snapshot of a specified range of cells - making it ideal for creating dashboards. This shape will reflect all of the live changes made in the actual cell range.
  • It works like a normal shape and includes Excel import/export, grouping...