SpreadJS 17.1.6

Released: Sep 19, 2024

Updates in 17.1.6

Fixes

  • The position of the field settings popup in the data source panel was incorrect.
  • An issue was happening with pinning grouped column areas to the top of a spreadsheet.
  • The position of the text in a floating box was incorrect.
  • There was an issue with setting a slider marker in the sheet.
  • A data type would incorrectly change after exporting to Excel.
  • Pixel scrolling would throw an exception.
  • AddFromDataSource was unable to be undone.
  • Calculation Fix:
    • The SUMIFS formula did not calculate correctly.
  • CellType Fix:
    • The time format would incorrectly change in a time CellType.
  • Designer Fix:
    • Adding a data source did not work in some circumstances.
  • Excel IO Fix:
    • There was an issue with an exported Excel file.
    • The behavior of a filter was incorrect after exporting to Excel.
    • A filter button was missing after exporting to Excel.
  • Export Fix:
    • Text would disappear when a PDF was exported.
  • Filter Fix:
    • The order when finding values in a column filter was incorrect.
    • Filter items were incorrectly checked.
  • Performance Fix:
    • Pasting after using fromJSON would cause the browser to crash.
  • PivotTable Fix:
    • When fillDownLabels was true, the text of the grouping statics label displayed the PivotTable incorrectly.
  • ReportSheet Fix:
    • There was an issue with the position of a ReportSheet picture over merged cells.
    • Icons would disappear in certain circumstances in a ReportSheet.
    • The image of the report was not in the correct position in preview mode.