Released: Jul 2, 2024

17.1.0 での更新項目

機能

• Added autoFit support in ReportSheet to resize the rows and columns in a report automatically.
• Enhanced support for effectively managing and validating data changes using data entry events within the ReportSheet.
• Tablesheet now displays row numbers in an independent row header, similar to the row numbers displayed in a worksheet.
• Added undo/redo support to reverse and reapply changes to the tablesheet data.
• Added support for enabling defined column functionality for tablesheet that allows you to add, update, or remove a column with meaningful column types to design the table at runtime.
• Added support for tablesheet grouping layouts like Tabular and Condensed, in addition to the existing Outline mode.
• Added support for creating charts using structured table referencing strategies.
• Enhanced support for creating unordered (bulleted) and ordered (numbered) lists in rich text formatting.
• You can now save the 'r1c1' style formula in the JSON or SJS file for better export performance.
• Users can now change the cell-text direction to right-to-left by setting the style's textDirection property.
• The existing R.V function has been enhanced to get spilled cell values on the current page.
• Charts have been enhanced to apply cell number formatting using linked cells to dynamically update the format of chart elements such as data label, axis, and tooltip.
• Added support for the FileUpload cell type to upload any file or image.
• Users can now apply conditional formatting rules to a specific area, such as the Current selection or This worksheet, to focus on relevant data.
• You can now set cell references in the data labels and display the values of the selected cell range as data labels in the charts.
• Added support for setting different x-axis values for each data series in a scatter/bubble chart.
• Users can now customize the color schemes of the charts using the ColorScheme property to suit their needs and preferences.
• Added support for right-to-left orientation by setting the rightToLeft option of the worksheet.
• Added support for hiding formula cells in a protected sheet.
• Added support for renaming custom names which updates all referenced formulas.
• You can now copy the chart/shape/slicers as an image to the clipboard like Excel.
• Added support for setting the interval between axis labels in a chart using the tickLabelSpacing property.
• The existing pivot table grouping/ungrouping feature has now been improved to support the grouping of time type fields at fixed time intervals.
• Added support for incremental calculation that divides the entire calculation into segments during execution when the calculation task is huge.
• You can now copy and paste formatters to and from Excel and SpreadJS.
• Added support for managing custom table/pivot table/slicer themes by retrieving, adding, removing, and updating table styles.
• You can now move/insert columns or rows by dragging their respective headers.
• You can now set document properties within the workbook.
• You can now adjust the dialog's position in the designer by setting the dialogOpeningPosition parameter to screenCenter or designerCenter.
• Enhanced support to formula adjustment logic when inserting or deleting rows/columns to improve performance.
• Improved support to use the isMergeUpdate parameter in the updateExternalReference method to update the partial of the external source value.
• Users can now customize the behavior of the Save File dialog when importing and saving files in the Spread Designer component.
• SpreadJS Designer now provides a UI option to show the border while printing the worksheet.
• Enhanced the fill dialog for a better user experience.
• Updated the license model to support IPv6.
• Added support for NextJS version 14.
• To create a Next.js application, ensure the Node.js version installed should be greater than v18.17.
• Angular 17 is now supported.
• Updated Angular demo samples to standalone components usage.

不具合の修正

• Resolved the performance issues while using conditional formatting rules manager to manage multiple conditional formats in SpreadJS Designer.
• The ClipboardPasted event now works properly when the cell content contains double quotes.
• Resolved the issue where the cellClick event was not triggered when clicking on the disabled area on mobile devices.
• Resolved Pivot table style issues.
• Resolved issue with exported HTML content not wrapping cell text.
• Resolved the issue where an error is thrown when the browser was resized while the Formula tab was active and did not use any ReportSheet resources.
• Resolved performance issue where tips appeared only for the first cells in AutoMerge.
• Resolved performance issue where the text box is set to obscure the text when the font is tilted to the right.
• When double-clicking the fill handle, the cell now responds as expected.
• Resolved the issue where clicking the Preview option would crash the browser.
• Resolved the issue where the pivot table could not find the maximum value for the date.
• The data validator's inputMessage() method with a line break code now displays correctly when importing an Excel file using the SheetsIO module.
• The function list present in the formula bar now appears correctly.
• Selection or active state is now working properly when using the hidden or veryHidden option when importing an Excel or SJS file.
• The HighlightInvalidData property now appears correctly.
• The display effect of a tree diagram is now consistent with Excel.
• The formatting result is now displayed correctly when printing or exporting the report to PDF.
• When the autoSize comment is set to true, the cell content is now displayed as expected.
• No error occurred while exporting Excel files.
• Resolved the performance issue where deleting all content in the rich text editor did not erase the cell contents.
• Resolved the issue where SJS files created and saved by the designer could not be opened, and Incorrect File Format is prompted.
• Borders are now displayed as expected in the exported Excel file.
• Resolved the issue when importing and exporting Excel files resulted in an extra text box.
• Resolved the performance issue where Convert Text to Columns Wizard didn't convert the value to the Date value.
• The GETPIVOTDATA function now works properly with the custom culture.
• The Window function now returns the expected results after changing data for the second time.
• Resolved the inconsistency issue between SpreadJS and Excel for displaying charts.
• Resolved the issue where PrintInfo is missing from the worksheet when the workbook instance is created without a host element.
• Resolved the inconsistency issue between SpreadJS and Excel when setting null values for charts.
• SpreadJS name manager value computation is now consistent when set to TRUE.
• The width of the chart series border is now consistent with Excel after configuration.
• Resolved performance issue with the SpreadJS Designer ribbon dropdown popup.
• SpreadJS filtering behavior is now consistent as expected.
• Resolved the performance issue where there is a picture below the table and adding a row to the table does not shift the picture down.
• No error is thrown while accessing page setup options for custom culture using the SpreadJS Designer component.
• Resolved the issue where formulas' Optional parameters are not marked as optional in the brief description.
• The chart series is now consistent with the Excel after updating the chart data range.
• Resolved the issue where Name Manager didn't show the value field when deleting a row.
• Resolved the issue where the Name Manager filter displayed an error as Name with Errors.
• Resolved the issue where the copy-pasting in cross-spreadsheets splits the content into two cells.
• Resolved the issue where the cantered style of the exported Excel file was lost and the font size increased.
• Resolved the issue where the line break could not be deleted using the backspace key after pasting a multiline cell.
• Resolved the issue where images could not be exported to PDF.
• Resolved the issue where the DragDrop event did not undo properly after a series of operations.
• Resolved the issue where the designer's shortcut Ctrl + A is invalid after resetting the workbook.
• Resolved the issue where the Select Locked Cell and Select Unlocked Cell protection option settings were lost after exporting XLSX.
• Resolved the issue where the style of the vertical axis title becomes ineffective after setting the border of the chart area.
• Resolved the issue where the data range of the chart was lost when exporting JSON and then importing.
• Resolved the performance issue with the table auto-fill feature.
• Resolved the issue where inserting a row caused the table formula to change.
• Resolved the performance issue when exporting the XLSX file required refreshing the pivot table style to match SpreadJS.
• Resolved the inconsistency issue in an active cell behavior between SpreadJS and Excel with the pivot table.
• Resolved the issue where the conditional formatting icon set inversion icon and actual effect were incorrect.