Skip to main content Skip to footer

SpreadJS v19 Hotfixes

The latest updates and information on the SpreadJS JavaScript Library.

Please tell us what you think in the SpreadJS forums channel.

  • SJS-10401: Tables fix: The total row value of the bound table appears once more in another location.
  • SJS-32008: Charts fix: XY scatter plot in Excel becomes a composite plot after importing SpreadJS
  • SJS-32750: Charts fix: In the combo chart, the lineMarkersStacked100 and the lineStacked100 are plotted separately.
  • SJS-32770: TableSheet fix: Named Range Used in TableSheet Cell Button Configuration Removed During Export with includeUnusedNames=false
  • SJS-33112: Designer Component fix: Ribbon controls misalign at non-100% browser zoom / DPI scaling
  • SJS-33115: PivotTable fix: Hebrew Text Not Displayed in Pivot Table Filter Dropdown in SpreadJS Designer
  • SJS-33129: Tables fix: The Impact of Incremental Loading and Lazy Loading on dataTable
  • SJS-33286: Designer Component fix: [ReportSheet Designer] For format settings, the options of "No Color" and "Custom Color" are missing
  • SJS-33287: Designer Component fix: [Designer] In the condition format management rules dialog, the first rule cannot be selected
  • SJS-33288: Designer Component fix: [ReportSheet Designer] The dropdown menu for Find and Replace is incorrect.
  • SJS-33291: PivotTable fix: Questions about v19 new feature PivotTable Interaction in Protected Worksheet.
  • SJS-33298: Designer Component fix: [ReportSheet Designer] When the data is an empty array, the collapse button disappears when searching the data source.
  • SJS-33320: TableSheet fix: [TableSheet] IconSets Rule Can't work
  • SJS-33322: TableSheet fix: [TableSheet]Use pixel scrolling, drag scroll bar to scroll, the scrolling distance is wrong

  • SJS-31550: GanttSheet fix: Exported ganttsheet displayed different from spreadsheet.
  • SJS-31869: Calculation Engine fix: LINEST formula calculation error
  • SJS-32198: Workbook fix: Cannot search for the specified worksheet
  • SJS-32570: Charts fix: Chart displays only a single column instead of multiple columns
  • SJS-32708: Calculation Engine fix: Formula returns inconsistent result vs Excel when using a single-character value
  • SJS-32828: Calculation Engine fix: Spill error inconsistency between Spread and Excel
  • SJS-32839: DataRange fix: After the dataRange references the TableSheet, filter options appear in the column headers.
  • SJS-32840: GanttSheet fix: Setting a custom style in the GanttSheet prevents mouse operation of the taskbar.
  • SJS-32945: Excel IO fix: The Stop If True property lost after saving to sjs.
  • SJS-32978: Data Manager fix: [TableSheet] Group Header uses the Column Name and not the column caption
  • SJS-33086: Filter fix: Filter UI shows Date (Year) filter when using numeric values with mm formatter
  • SJS-33109: GanttSheet fix: Time Scale displays incorrectly when zooming the ganttsheet.
  • SJS-33114: Excel IO fix: After import/export excel including a external link, blank cell is converted to NaN.
  • SJS-33122: Worksheet fix: The program experienced severe lag after setting the font for the entire sheet.
  • SJS-33163: Security fix: Added stronger XSS protection to hyperlinks in workbook.