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

Released: Apr 1, 2021

14.0.10 中的更新

修補程式

• Exporting to JSON would add empty columns.
• RangeBlockSparkline could not be set on the same sheet as the template.
• Hover cell state would prevent a merged cell’s border from being fully displayed.
• Inserting cells would not increase the filter range.
• Deleting a table row using the context menu would not work when adjacent cells were selected.
• Cell content would move down after drag-filling.
• Formulas could not be edited properly in FireFox.
• Adding a style from a dialog would make the...

Released: Mar 18, 2021

14.0.9 中的更新

修補程式

• Conditional format covered certain text in a cell.
• Importing an Excel file exported from SpreadJS would add blank rows.
• Adding a sheet in the designer would set an incorrect sheet name.
• Format Cell dialog dropdown would not show properly.
• Designer: The bottom border line of the Designer Component was not displayed.
• Errors were thrown when adding columns dynamically.
• Designer: Designer Component would not show the new file dialog when files were imported.
• Designer: Custom style names would...

Released: Mar 4, 2021

14.0.8 中的更新

修補程式

• Importing an Excel file would change some styles.
• Imported a specific SSJSON would have a different result from the original Excel file.
• Shape text was not importing.
• Shape display was inconsistent with Excel.
• Shape sizing button would behave strangely if the zoom factor was not 100%.
• A specific formula would show a “#N/A” result when imported from Excel.
• The outline column expand/collapse functionality did not work on mobile devices.
• Designer: Font styles were not being applied.
• Comments...

Released: Feb 19, 2021

14.0.7 中的更新

修補程式

• CMD+Z did not work in edit mode on Apple macOS.
• Print preview and results were inconsistent in some cases.
• Connector shapes not correctly added from top to bottom.
• Designer: Moving charts and changing chart types would prevent the preview from loading correctly.
• A tooltip wouldn’t disappear when moving away from a hyperlink.
• Using external formulas on one sheet affect formulas on another sheet.
• Cell text color different from Microsoft Excel.
• Custom shape line information not exported to...

Released: Nov 17, 2020

14 中的更新

特性

• New v14 Designer - GrapeCity have created a separate add-on product known as the SpreadJS Designer Component. It is an implementation of a Microsoft Excel-like user interface with SpreadJS features including a ribbon, status bar, formula bar, context menus, and associated dialogs. The SpreadJS v14 Designer includes:
  • Add or remove buttons for tabs in the ribbon.
  • The option to change styling.
  • The ability to change the functionality of different buttons.
  • Custom dialogs.
• Cell Interactions...

Released: Sep 15, 2020

13.2.3 中的更新

特性

• Clipboard data can now be cleared when starting cell edit or using the Esc key.

修補程式

• Line length of borders was inconsistent after importing a Microsoft Excel file.
• Negative numbers with spaces would not parse correctly when pasted into SpreadJS.
• Shapes were not restored from JSON correctly when imported.
• The outline row symbol would be hidden when exporting to Excel.
• Scrolling and editing was slow after importing an SSJSON.
• SetCollapsed() would not work with the index from outline.group...