Released: Jan 2, 2025

18.0.1 中的更新

修補程式

• Fix:
  • A header image was not correctly displaying in WPS.
  • Scaling the worksheet size incorrectly altered the text layout in an area camera shape.
  • Formulas could not be copied using the copyTo method.
  • An issue was happening with the DataSource table column visible property.
  • ReportSheet image formats were not working correctly.
  • After filtering, data that was pasted into other sheets was incorrectly changed.
  • Pixel based scrolling would cause display issues.
  • The CalcArray.toArray result was not...

Released: Dec 18, 2024

18.0 中的更新

特性

New DataCharts Add-On

• For years, SpreadJS has empowered users with robust charting capabilities to display and summarize spreadsheet data seamlessly. While these existing charts cater to most needs, some scenarios require a more flexible approach.
• With the release of SpreadJS v18, MESCIUS introduces the DataCharts Add-On. This powerful new tool allows you to bind charts directly to the Data Manager data, eliminating the need to store data within the SpreadJS workbook.
• For ReportSheets Add-On...

Released: Nov 26, 2024

17.1.10 中的更新

特性

• SpreadJS now supports Angular 18.

修補程式

• Import Fix: The default starting number for each worksheet was incorrectly set to 1.
• Fix: Text in the context menu was cut off.
• Fix: Ctrl+Right/Left Arrow behavior was different from Excel.
• Fix: Pictures that were exported from reports could not be sorted with other data.
• Fix: A border line would disappear after clicking on a hyperlink cell.
• Fix: Sheet binding was not automatically saved.
• Designer Fix: The frameless button in the ribbon would not remove...

Released: Nov 7, 2024

17.1.9 中的更新

修補程式

• Ctrl+Shift+Arrow Key did not work when editing a formula.
• The sizing for comments was not working correctly.
• The Alt+";" shortcut key did not work correctly.
• A column could not be resized with the width was less that 3px.
• An error message would show related to an unsupported .xls file format.
• A selection range was lost after selecting all and then right-clicking the last line.
• The text color of a footer was not correct.
• The filter box would incorrectly jump to the filter result item after...

Released: Oct 24, 2024

17.1.8 中的更新

修補程式

• CellTypes were not working correctly in some circumstances.
• The date addition operation resulted in an error.
• The automatic line wrapping for text in a grouped column was not working correctly.
• The browser would freeze after changing the culture after importing an Excel file.
• A hidden sheet would incorrectly display with the hyperlink dialog.
• There was an error with deleting columns after using a custom cell.
• When both the text and value of a check box were "-", an error would occur when...

Released: Oct 10, 2024

17.1.7 中的更新

修補程式

• A context menu sub item was not displaying correctly.
• A format string displays as "#N/A" where there is a Chinese comma.
• An empty cell could not be copied when using a Mac.
• An icon could not be correctly set to the right of the text in a rich text cell.
• The Ctrl + Arrow Keys behavior was not correct.
• The list data verification would cause style problems.
• The range selector was not working in the SUM formula with the ALT + shortcut.
• There were some issues that affected a Data Manager...

Released: Sep 19, 2024

17.1.6 中的更新

修補程式

• The position of the field settings popup in the data source panel was incorrect.
• An issue was happening with pinning grouped column areas to the top of a spreadsheet.
• The position of the text in a floating box was incorrect.
• There was an issue with setting a slider marker in the sheet.
• A data type would incorrectly change after exporting to Excel.
• Pixel scrolling would throw an exception.
• AddFromDataSource was unable to be undone.
• Calculation Fix:
  • The SUMIFS formula did not calculate...

Released: Sep 10, 2024

17.1.5 中的更新

特性

• Vue wrapper support has been added to the TypeScript Definition file.
• Vue wrapper support for the Designer has been added to the TypeScript Definition file.
• Filter items can now be checked/unchecked with keyboard shortcuts.

修補程式

• The masking caret position was incorrect.
• Setting background color for cells was not working properly in certain circumstances.
• A row couldn't be removed if the removeRow method was used several times.
• A drop-down list does not appear in the right location for a text...

Released: Aug 22, 2024

17.1.4 中的更新

特性

• Filter Feature
  • Filter times can now be reordered.

修補程式

• Overflow behavior was different compared to Excel.
• SJS files opened slowly in lazy loading mode.
• Setting continuous page numbers did not work correctly.
• Text incorrectly overlapped in certain circumstances.
• Cell values copied from XLS were missing.
• Insert Copied Cells did not work correctly when executed in the same row as a table.
• Calculation Fix
  • Custom functions would incorrectly trigger twice when CalcOnDemand was enabled.
  • Certain...

Released: Aug 8, 2024

17.1.3 中的更新

特性

• Filter Enhancement
  • The filter items in a filter dialog can now be reordered.
• PivotTable Enhancement
  • The Pivot Panel can now be resized.

修補程式

• A blank space would appear when the tabStripPosition was set to the left.
• The scrollbar would incorrectly scroll back to column A after modifying column widths and using fromJSON.
• The result of row grouping was incorrect.
• The DragDropBlockCompleted event would incorrectly trigger after canceling the DragDropBlock operation.
• The delete sheet command would...