Released: Sep 22, 2021

14.2 での更新項目

機能

• The Designer now supports the Go To Special feature to select a special group of cells in the worksheet.
• Additional keyboard shortcuts have been introduced.
• Users can now bind file import events in the Designer Component.
• The Designer now supports the Find and Replace function.
• The Designer UX has been enhanced.
• The Designer Component now includes a d.ts definition file with the React module.
• The Name Box in the Designer can now be used to work with cell ranges.
• Users can now customize the Designer Component status bar using the StatusBar.findControl method.
• The "Insert" tab layout in the Designer has been updated.
• The Designer Component now supports the toolbar ribbon mode.
• Users can now customize the Designer Component localization.
• Added support for Vue 3 and Angular 12.
• The Designer now provides automatic outline for cell ranges with formulas.
• Users can now launch the Designer Component with the collapsed ribbon.
• Users can now move sheets and copy sheets. The operations can be performed in the Designer as well.
• SpreadJS now supports Apple iOS14 and iPadOS14.
• The Designer now provides format painter button to copy and paste formatting from one object to another.
• Users can now unhide multiple sheets in the Designer.
• SpreadJS Designer now provides the shape selection pane to manage and arrange multiple shapes in a worksheet.
• Users can now sort the cells by background color and font color.
• The incremental loading feature now provides a new parameter in the incrementalLoading callback function to access worksheet-related information.
• Users can now create and use custom components in the Designer Component.
• The workbook constructor has been enhanced to accept the host ID string.
• Users can now close a dialog programmatically in the Designer Component.
• Users can now customize existing language packages and translate them into a particular language.
• SpreadJS Designer now enables ribbon scrolling when the designer width is small enough to hide ribbon buttons and navigation tabs.
• The paste formatting option has been enhanced to adjust the pasted format according to the size of the target region.

不具合の修正

• When the chart is serialized, it changes along with the data.
• Double borders in cells apply correctly after importing JSON.
• Floating objects are visible when moved around.
• Merged cells are retained when pasting a picture on the worksheet.
• While opening an exported file in Excel, no pivot table issues are prompted.
• Line breaks work correctly in chart labels like the Y-axis and legend area.
• VLOOKUP formula gives the correct result.
• The background color of a chart title is retained when copying a chart using fromJSON or toJSON.
• The performance of CalcEngine is improved when importing large Excel files.
• The XLOOKUP formula shows the correct result when returning an array.
• Conditional formatting works correctly when inserting rows in a table.
• The formula reference range is updated correctly when inserting rows in the formula range.
• Formula referenced by a camera shape is displayed correctly in the worksheet area.
• Formula calculation results in SpreadJS are consistent with Excel.
• Drag fill is implemented correctly with a locked cell within the drag fill range.
• The pivot background color is applied correctly.
• The applicable cell range of conditional format is retained when extending table rows.
• The performance of CalcEngine is improved to display correct formula results.
• The contents of merged cells are displayed correctly when scrolling horizontally.
• Formula references are displayed correctly in a camera shape.
• Shape size is retained when grouped columns or rows are opened and closed.
• Sheets fit correctly on one page when exporting to PDF.
• The chart displayed in a sheet is consistent after using fromJSON or toJSON.
• DATEDIF results are consistent between SpreadJS and Excel.
• The performance of incremental loading is improved while loading a JSON file.
• Formula using brackets show correct results after importing a file.
• Rowchanging and columnchanging events include the cancel attribute.
• ActiveSheetChanged and ActiveSheetChanging are triggered correctly in events.
• Cells can set a formula correctly after importing an XLSX file.
• Cells do not appear underlined after importing an Excel file.
• Cell border is retained when hover action is performed.
• Banded rows or columns information is exported correctly to Excel file if table style is none.
• Copy pasted CustomName returns correct value after performing undo of row deletion.
• The WEEKNUM formula is enhanced to have the same behavior as in Excel.
• XLSX file including shapes is imported correctly in the SpreadJS Designer.
• The chart displays correctly after modifying the chart type.
• The camera shape is updated when an event is suspended.
• Data validation content is deleted correctly by Clear All operation in Designer Component.
• Custom Cell format is displayed correctly in the imported file.
• Options are provided to unhide the column headers after they are hidden.