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.
• When pixel scrolling was enabled, some offsets would show when showRow and showColumn were used.
• The context menu could not be used to shift cells down to allow more overflow space to resolve a SPILL.
• Pasting over a dynamic array via right-click would not work.
• If a dynamic array formula referred to an array of cells on a different sheet, inserting rows to resolve the SPILL did not work.
• A sheet would become blank after a slicer was inserted.
• A sort result was different between Firefox and Chrome.
• A clipboardPaste setting with "Paste only format" was invalid.
• The RepeatColumn setting would conflict with FitPageWide.
• Excel IO Fix
  • Importing a specific Excel file would fail.
  • An error would be thrown when exporting a specific Excel file.
  • An invalid outline would appear after exporting a file from SpreadJS and importing in Excel.
  • The forecolor of a hyperlink would change after importing.
• ReportSheet Fix
  • The right-click menu for the row and column headers was invalid.
  • Changing a dropdown value would not submit changes.
  • Data entry would be enabled even if the settings were empty.
• Calculation Fix
  • A formula result after replacing a value was inconsistent.
  • Calculation results were inconsistent.
  • The result of an XMATCH function was incorrect when the find array length was 1.
  • The IFERROR function would incorrectly processing null as 0.
• PivotTable Fix
  • A pivot slider panel was blank in certain circumstances.
  • SpreadJS and Excel had different behaviors for Pivot Panels.
• Designer Fix
  • The Designer.sheetSettings command would not correctly fire.
• Performance Fix
  • Setting isPrintLineVisible to true caused cell editing operations to lag.
• Table Fix
  • The column header dropdown of a table would overlap an autofitted column title.