Released: Nov 10, 2021

14.2.3 での更新項目

機能

• Added support for Apple iOS 15 and iPadOS 15.
• Accessibility content has been enhanced.

不具合の修正

• The value from a MATCH formula that references a PivotTable range was incorrect.
• A custom formula would not show in edit mode.
• The workbook would not display correctly after switching sheets.
• The context menu would not work correctly after 14.2.0.
• The “Margun Gothic” font was missing in the designer font dialog.
• Specific keyboard shortcuts were not working.
• The merge cell operation was not...

Released: Oct 27, 2021

14.2.2 での更新項目

不具合の修正

• Dynamic arrays in an exported Excel file would display a "#spill" error if DoNotRecalculateAfterLoad was set to true.
• Dynamic array formulas would have an extra "@" after exporting to Microsoft Excel.
• A formula result changed after importing an SSJSON file.
• An error would show in the console after setting repeatRowStart and repeatRowEnd.
• Custom AutoFilters would cause SpreadJS to become unresponsive if the first option is left blank.
• The web browser would hang after pressing Command + Z...

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

Released: Aug 26, 2021

14.1.6 での更新項目

不具合の修正

• Chart text partially covered.
• Pivot: A specific Excel file with a PivotTable was not correctly imported.
• Cells are not indented when opening up an exported Excel file in WPS.
• Chart: Charts with external data links do not import correctly.
• Designer: Field positions when dragging fields from the template designer into the worksheet are not correct.
• Conditional formatting has no effect after exporting Excel files and opening in WPS.
• Chart : XY Scatter chart X-axis would import as dates...

Released: Aug 12, 2021

14.1.5 での更新項目

不具合の修正

• Designer: Fill color would not show inside the conditional format dialog.
• Designer: The icon for the data validation prompt was missing.
• Pivot: Dragging fields from row to columns sections in the pivot panel would change the state to dirty.
• Pivot: Pivot Panel would not be active if there were two SpreadJS instances.
• Shape fonts and positions would not show correctly when exported to PDF.
• Setting rows to invisible would cause shapes to disappear.
• Shapes couldn’t be moved correctly in an...

Released: Jul 29, 2021

14.1.4 での更新項目

不具合の修正

• Inserting formulas was enabled even though the sheet was protected.
• Quotes were not automatically added when adding text to a formula.
• Clicking a check box would take time to update the rest of the sheet.
• The result of a formula was different from Excel.
• PivotTable would update the data source incorrectly when incremental loading is enabled.
• The GETPIVOTDATA formula would not return the correct value.
• Cell formats would change after importing an Excel file.
• An exported Excel file could...

Released: Jul 16, 2021

14.1.3 での更新項目

不具合の修正

• Specific charts would not display correctly.
• DataLabels would not display in StackBlitz.
• Setting focus to false inside of a button command would cause the button to lose hover style.
• A specific chart would not import properly from an Excel file.
• Specific charts would not import correctly.
• Adding an input box to a context menu would result in an unresponsive input box.
• The TableRowsChanged event would not fire correctly if a row was deleted via undo.
• Designer: Sparkline options would not...

Released: Jul 1, 2021

14.1.2 での更新項目

不具合の修正

• Chart categories would not show the leading zero.
• A specific chart would work in earlier versions but not in the latest version.
• An exception would be thrown after removing a sheet.
• A "#" character would be added to the end of a cell value when using the "0.0#%" format.
• Printing a workbook would throw an exception.
• Using FitPagesWide would cause a CheckBox icon to not show correctly after printing.
• Designer: Adding conditional formatting would not work in some instances.
• Exporting a file...

Released: May 20, 2021

14.1 での更新項目

機能

Pivot Tables Add-on

• New Add-on includes support for Pivot Tables, PivotPanel UI and Microsoft Excel import/export capabilities. Supports various pivot table functions like sorting, filtering, and grouping.

Camera Shape

• Camera shape lets you create a dynamic snapshot of a specified range of cells - making it ideal for creating dashboards. This shape will reflect all of the live changes made in the actual cell range.
• It works like a normal shape and includes Excel import/export, grouping...

Released: Apr 1, 2021

14.0.10 での更新項目

不具合の修正

• Exporting to JSON would add empty columns.
• RangeBlockSparkline could not be set on the same sheet as the template.
• Hover cell state would prevent a merged cell’s border from being fully displayed.
• Inserting cells would not increase the filter range.
• Deleting a table row using the context menu would not work when adjacent cells were selected.
• Cell content would move down after drag-filling.
• Formulas could not be edited properly in FireFox.
• Adding a style from a dialog would make the...