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

Released: Mar 12, 2020

13.0.7 での更新項目

不具合の修正

• Error with cell references to other sheets.
• Increased memory consumption opening/closing dialogs.
• Increased memory consumption creating and destroying spread instances.
• DeletedItem property missing from TableRowsChanged event when deleting a table row.
• MIN formula showing different results between Spread and Microsoft Excel.
• Data not being cleared when using sheet.fromJSON.
• CommaStyle format in Designer is different from Excel.
• HyperLink CellType has incorrect hit position when the cell...