Released: Jul 11, 2024

17.1.1 での更新項目

不具合の修正

• AutoFill now supports structured reference adjustments.
• Some cells with data validation were incorrectly locked.
• Pasting over text would incorrectly add a line break.
• Copying sheets did not work properly.
• The InvalidOperation event was not triggered after filtering a locked cell.
• Text incorrectly automatically wrapped when cells were copied from Excel to SpreadJS.
• The font size of a rich text cell incorrectly changed when the scaling was set for printing.
• Calculation Fix
  • The INDIRECT...

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

Released: May 31, 2024

17.0.10 での更新項目

不具合の修正

• The Date Time Picker would not show the correct end date in some circumstances.
• Cell prefix single quotes would incorrectly be replaced.
• Create a tree diagram would throw errors when right-clicked in certain circumstances.
• Copying multiple cells in a column would result in extra \r\n characters at the end of the string.
• A locked attribute was true after filling some cells.
• A worksheet was frozen when there was an invalid formula in a table column.
• Calculation Fix
  • A #Value error would be...

Released: May 16, 2024

17.0.9 での更新項目

不具合の修正

• A conditional format was inconsistent with Excel.
• The SpreadJS instance would freeze after inserting a line and entering data.
• A range selector value would be cleared when changing sheets.
• There was an issue setting "100%" as a default value.
• A column would display incorrectly when using Ref and binding to a data source in a Vue3 project.
• There were not unique IDs for two different context menus.
• An error occurred when opening a filter dialog if listFilterArea and useTouchLayout were used...

Released: Apr 18, 2024

17.0.8 での更新項目

不具合の修正

• Calculation Fix
  • A formula result was incorrect when enabling calcOnDemand.
  • The result of the RANDBETWEEN function was not correct.
  • The result of the NETWORKDAYS function was not correct.
  • Turning off iterative calculation would result in different formula results.
  • The IMAGE function would not display correctly.
• Chart Fix
  • Charts were rendered incorrectly.
  • Data from hidden cells would not be displayed.
• Designer Fix
  • Setting a tooltip for drop down items would not work correctly.
• Excel IO Fix...

Released: Apr 10, 2024

17.0.7 での更新項目

不具合の修正

• Calculation Fix
  • The arrow keys could not be used to reference a cell in a formula.

Released: Apr 3, 2024

17.0.6 での更新項目

不具合の修正

• Angular Fix
  • The Angular version of the demo samples has been updated.
• Calculation Fix
  • Circular references would get stuck in large files.
  • The "COUNTA(UNIQUE())" formula behaved differently from Excel.
  • A drag and drop fill result was incorrect after enabling manual calculation.
  • A formula result was changed after upgrading to a newer version.
  • Some calculation results were inconsistent.
  • A formula result was inconsistent with Excel.
• Excel IO Fix
  • The text of a textbox was incorrect after...

Released: Mar 26, 2024

17.0.5 での更新項目

不具合の修正

• Calculation Fix
  • The ISREF and INDIRECT functions would have different formula results.
  • A specific formula was incorrect.
  • The formula editor would show as undefined for the listSeparator when the culture was changed.
  • A custom function would not show in a sheet.
• Chart Fix
  • The order of charts in a combo chart would not stay the same when using JSON.
  • Restricting the number of series in a chart was not working correctly.
  • Horizontal axis units were inconsistent.
• Microsoft Excel Compatibility...

Released: Feb 28, 2024

17.0.4 での更新項目

機能

• Added support for Next.js 14.
• Added support for Angular 17.

不具合の修正

• GanttSheet
  • GanttSheet tabs did not have a context menu.
• Filter
  • The filter function worked differently from Excel.
• Mobile
  • The Sheet bar couldn't be dragged properly.
• Calculation
  • The VALUE formula did not work correctly in some circumstances.
• Chart
  • The language of an imported chart series could not be changed correctly.
• Calculation
  • The GetPivotData formula did not display correctly after exporting to Excel.
• Excel IO
  • Exporting a...

Released: Feb 2, 2024

17.0.3 での更新項目

機能

• Language Release
  • Korean Language release for v17.

不具合の修正

• Chart
  • The order of a combo chart series was inconsistent with Excel.
  • Updating a table used by a chart would throw an error.
  • A hyperlink's tooltip would not correctly display in certain circumstances.
• Name
  • The name manager would incorrectly show custom names after a sheet was deleted.
  • The distribute option didn't work properly with the ja-jp culture set.
• Performance
  • Clicking on a slicer would cause the page to freeze or crash in some...