SpreadJS 新版本发表

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

Released: Jul 23, 2020

13.2.0 中的更新


  • New API member allowRotate is provided for shape rotation.
  • New API member showHandle is provided to hide shape outline and handles.
  • Unsupported charts can be preserved when imported from other file formats.
  • Supports sorting with grouped data.
  • Displays a warning dialog when data is copied in a non-continued cell range.
  • Chart is updated when values in named range countif are updated.
  • Supports sorting by skipping data in hidden rows.
  • The maximum and minimum zoom limit can be set.
  • Zoomed picture...

Released: Jun 24, 2020

13.1.4 中的更新


  • Conditional formatting style couldn’t be changed.
  • Sheet is deselected when canceling sheet hiding in the SheetChanging event.
  • The StatusBar.dispose() and formulaTextBox.destroy() methods wouldn’t properly restore the host element.
  • Conditional formatting didn’t work after exporting to Microsoft Excel.
  • Cell wouldn’t be correctly formatted as text.
  • Exporting a specific Microsoft Excel file throws an error.
  • Calling clearSelection after setting sheet protection caused the page to hang.
  • Editing...

Released: Jun 11, 2020

13.1.3 中的更新


  • Sub groups wouldn’t collapse when direction was reversed.
  • IRR formula didn’t calculate correctly.
  • Data display exception occurred after setting a data source.
  • Browser crashed when adding a sunburst or pie chart.
  • IRR formula result was different from Microsoft Excel.
  • Browser would hang when exporting to PDF.
  • Result of getViewportRightColumn was incorrect.
  • MOD formula doesn’t work correctly with date-time formatted values.
  • Input Text is incorrectly set to a different cell.
  • Custom celltypes...

Released: Apr 23, 2020

13.1.0 中的更新


  • Chart Series LineType is now supported which allows users to customize the line type of data series in a chart.
  • Various detailed rendering options on Sparklines are provided. The Bullet, Hbar, Vbar and Pareto Sparklines can be customized using these additional options.
  • Users can select multiple worksheets and apply hide or delete operations on them.
  • Hyperlink is supported where users can link any relevant information on a webpage, any range in the workbook or even send an email.
  • Selection of...