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

Released: Feb 23, 2020

13.0.6 中的更新

特性

• Improved context menu styles.
• Imported SSJSON formula update.
• Improved Cell Format dialog in online designer.
• Large password-protected Excel export update.
• Improved Data Validator.

Released: Feb 14, 2020

13.0.5 中的更新

修补程序

• Column widths after importing updated.
• Changing protection options and undo stack.
• Tables can be created by selecting range in designer.
• Cross-sheet formulas are now restored when undoing.
• Microsoft Excel export without display inconsistencies.
• Blank page no longer added when printing in landscape.
• Date formatted cells editing updated.
• NumberFormat.percentGroupSeparator in custom cultures enhanced.
• DateTimeFormat.dateSeparator in custom cultures enhanced.
• Shape text FontSize exports to...

Released: Dec 31, 2019

13.0.3 中的更新

修补程序

• Shapes no longer move when zooming in the sheet.
• A recover warning is no longer thrown for a specific exported Excel file.
• Shape position no longer changes when importing an Excel file.
• Changing a table data source now shows correct formula results.
• Pixel scrolling works correctly with the scroll bar.
• Changing the binding source no longer clears cell values adjacent to the table.
• Loading an Excel file no longer causes problems.
• Cutting and pasting does not cause a formula reference area...

Released: Dec 13, 2019

13.0.2 中的更新

修补程序

• Values less than 1 are calculated correctly on logarithmic axes.
• Updating formulas with many dependent formulas no longer freezes tab.
• CalcOnDemand option added to ExcelIO in the tutorial demo.
• Sorting now correctly triggers dirty data.
• Image background color is now correctly exported to PDF.
• HitTest returns correct location when clicking on the bottom-right of a cell.
• SPAN tag no longer breaks form layout.
• IMSUB result is now correct.
• Undo operation is now handled correctly for CellChange...