Released: Aug 8, 2024

17.1.3 での更新項目

機能

• Filter Enhancement
  • The filter items in a filter dialog can now be reordered.
• PivotTable Enhancement
  • The Pivot Panel can now be resized.

不具合の修正

• A blank space would appear when the tabStripPosition was set to the left.
• The scrollbar would incorrectly scroll back to column A after modifying column widths and using fromJSON.
• The result of row grouping was incorrect.
• The DragDropBlockCompleted event would incorrectly trigger after canceling the DragDropBlock operation.
• The delete sheet command would throw an exception.
• A new column was incorrectly added after dragging a column by the header if the row count was 0.
• Inserting a picture in a repeating line would result in the picture not displaying on a second page.
• Doc properties didn't properly use the resource for custom properties.
• Right-clicking in a cell on a specific sheet would throw an exception.
• Using getUsedRange after re-reading JSON results were incorrect.
• Dragging a column to the first column position was difficult after setting frozenColumnCount.
• Using a dialog box to modify cell formatting after importing an Excel workbook was invalid.
• When isPrintLineVisible was false, the preview and PDF export was blank.
• Calculation Fix
  • Cross-workbook formula calculation results were inconsistent.
  • Incremental calculation did not work correctly with manual CalclationMode.
  • The result of the AVERAGEIF calculation was not correct.
  • The goalSeek calculation results were consistent with Excel.
• Designer Fix
  • The insert function was incorrectly disabled after clicking a cell again after editing it.
  • Setting an invalid formula would incorrectly show a blank message box.
  • The height of tab control in a designer dialog was incorrect.
• ExcelIO Fix
  • An XLSX file exported by SpreadJS would stop when filtering.
  • After importing JSON, the exported PDF would not display correctly.
  • Exporting a specific workbook caused a corruption issue.
  • An Excel file could not load properly in SpreadJS in a Node environment.
• Performance Fix
  • Large data rendering memory usage continued to increase in certain circumstances.
• PivotTable Fix
  • The placement of the subtotal "Total" text was not correct.
  • A page would get stuck after modifying the PivotTable's calculated fields and saving.
• ReportSheet Fix
  • Switching the RenderMode interface will cause stuttering if there are many pictures in the report.
  • Images and sparklines did not work after previewing and using toWorksheet.
  • The status of the sheet protection in the format menu of a ReportSheet was not updated correctly.
  • A report cell was set to adaptive, but the image was not displayed in the correct position.
  • Two error dialogs would show when inserting an invalid formula.
  • An exception would be thrown when editing certain ReportSheet properties.
• TableSheet Fix
  • The undo list would display incorrectly after executing an undo action in a TableSheet.