SpreadJS v19 Hotfixes

The latest updates and information on the SpreadJS JavaScript Library.

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

Download the latest release

  • SJS-32792: Formula Textbox fix: The presence of square brackets [] in the caption of a tableSheet will cause formula errors
  • SJS-32844: Calculation Engine fix: The formula calculation speed is exceptionally slow.
  • SJS-33285: Designer Component fix: [ReportSheet Designer] The scroll bar on the right side list is not displaying completely
  • SJS-33377: Charts fix: Stock charts do not render when data rows are less than number of columns
  • SJS-33528: Calculation Engine fix: #VALUE! Error Occurs on XLOOKUP Formula After Excel Import
  • SJS-33757: Calculation Engine fix: The asynchronous calculation interface (evaluateExpressionAsync) supports the "convertNullToZero" configuration
  • SJS-33762: PivotTable fix: [Pivot Table] crash following a sequence of odd UI interactions
  • SJS-33802: PivotTable fix: PivotTable Filter Context Menu Creates Empty Space and Shifts Sheet Up in Constrained Height Container
  • SJS-33826: Report Sheet fix: ReportSheet UI Crash When Removing All Rows or Columns Containing a Template Range Detail
  • SJS-33839: Documentation fix: Usage of DOLLAR function.
  • SJS-33854: Formatter fix: Dropdown Selection Displays Date Instead of Selected Text After Importing Excel File
  • SJS-33858: Designer Component fix: TableSheet state is not preserved on adding calculated fields through TableSheet side panel
  • SJS-33860: Documentation fix: sample code is not recognized as JavaScript
  • SJS-33864: Documentation fix: Extra page is added when orientation is set portrait in printInfo.
  • SJS-33921: Documentation fix: Need to update React contents in help document.
  • SJS-33933: Designer Component fix: [CheckBox] In Toggle mode, the alignment is set to inside, but after changing the mode to checkbox, the alignment is incorrect
  • SJS-33997: Calculation Engine fix: [Forguncy] The result of formula ="2026-02-28T17:07:59" + 0 is #VALUE!
  • SJS-34000: Formula Editor fix: When use Gemini for an AI model, the formula from the AI is returned enclosed in quotation marks.
  • SJS-34005: TableSheet fix: Two TypeScript Type Definition Errors in TableSheet API
  • SJS-34007: Calculation Engine fix: Issue when setting formula for a range with webworker calculation
  • SJS-34008: Report Sheet fix: ReportSheet Chart demo does not work properly.
  • SJS-34037: Designer Component fix: In designer of V19 JP version, sort dialog need to be modified.

  • SJS-27760: Charts fix: The chart series formatting is inconsistent before and after import and export.
  • SJS-31531: Charts fix: Extra Axis Label Added When Deleting a Row in Chart
  • SJS-33403: Designer Component fix: Formula List Separator Changes from Semicolon to Comma When Cancelling Edit in Custom Culture
  • SJS-33445: Designer Component fix: Style lost after importing Excel and exporting to ssjson on the sheet unit.
  • SJS-33501: PDF fix: File Read/Write Exception When Exporting Imported Excel File to PDF
  • SJS-33616: TableSheet fix: Data Table works unexpectedly for Columns Containing Dots in Column Names
  • SJS-33703: Data Manager fix: Trigger Formula Not Applied After Data Source Is Bound to TableSheet
  • SJS-33798: Collaboration fix: Add proper Meta Title and description to Collaboration Server demo

  • SJS-32819: Charts fix: Stock chart creation fails when category values are interpreted as strings instead of dates
  • SJS-33046: ConditionalFormatting fix: The conditional formatting colors are inconsistent with Excel.
  • SJS-33381: Formula Textbox fix: Intellisense for TableSheet column names is case sensitive.
  • SJS-33398: Tables fix: SpreadJS Excel import fails with “Incorrect file format” when Include Styles is enabled
  • SJS-33423: Designer Component fix: Hyperlink in empty cell are not clickable

  • 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.

Return to SpreadJS Release

v19 Hotfixes

 

Release Blogs

Additional Resources