SpreadJS 17.0.10

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 displayed after copying and pasting a formula in another cell due to a list separator.
    • In certain circumstances a calculation would need to be done twice.
    • A protected sheet would incorrectly have AutoSum disabled.
    • SUMIFS formula results would display incorrectly.
  • Chart Fix
    • Scrolling in a chart area on mobile would not work in certain circumstances.
    • Combination chart insertion methods were inconsistent in certain circumstances.
  • Excel Compatibility Fix
    • A tree diagram in SpreadJS was different from Excel.
  • Excel IO Fix
    • Hiding the row and column headers after importing would cause lines to appear in a table.
    • Importing and exporting files with Sunburst or Treemap charts with text data sources would result in an error.
    • Importing files that were loaded incrementally would mean data in an Excel file would sometimes need to be refreshed to display properly.
    • An error would occur after importing a specific Excel file.
    • Importing and then exporting a file to Excel would cause style loss in certain circumstances.
    • Importing an protected Excel file with a password would result in an exception in certain circumstances.
  • ReportSheet Fix
    • Calculation results were inconsistent.