SpreadJS v17 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

  • 12046: Chart Fix: Charts were rendered incorrectly
  • 15380: Performance Fix: Adding spans on a large number of cells would cause performance issues
  • 22073: Calculation Fix: A formula result was incorrect when enabling calcOnDemand
  • 23479: Fix: Using the autoFitColumn method caused some number cells to be replaced with the "#" symbol
  • 23612: Table Fix: A page would be unresponsive when binding a table
  • 23622: Designer Fix: Setting a tooltip for drop down items would not work correctly
  • 23627: Excel IO Fix: Setting includeEmptyRegionCells to false would prevent data from showing in an exported Excel file
  • 23656: Table Fix: A table would not be created after dragging a table with the same name from the Field List
  • 23668: Fix: An issue happened when a item in a dropdown list was marked with a % sign
  • 23677: Excel IO Fix: A chart series in a Combo Chart was incorrect after importing an Excel file
  • 23711: Calculation Fix: The result of the RANDBETWEEN function was not correct
  • 23712: Fix: Pasting to modify a cell value while in the cell editing state would incorrectly not fire the EditChange event
  • 23764: Calculation Fix: The result of the NETWORKDAYS function was not correct
  • 23768: Fix: The Range Select box would incorrectly be cleared when setting a style
  • 23776: Chart Fix: Data from hidden cells would not be displayed
  • 23778: ReportSheet Fix: Different results were displayed compared to previous reports
  • 23780: Calculation Fix: Turning off iterative calculation would result in different formula results
  • 23782: IO Fix: Importing a CSV file would still have a previous file's comments on it
  • 23783: Fix: The footer and sheet incorrectly overlapped when setting fitPagesWide
  • 23794: Calculation Fix: The IMAGE function would not display correctly
  • 23841: Fix: Data would not be set correctly in the sheet

  • 23689: Calculation Fix: The arrow keys could not be used to reference a cell in a formula

  • 21231: Calculation Fix: Circular references would get stuck in large files
  • 22394: Calculation Fix: The "COUNTA(UNIQUE())" formula behaved differently from Excel
  • 23101: Excel IO Fix: The text of a textbox was incorrect after importing an Excel file
  • 23215: Angular Fix: The Angular version of the demo samples has been updated
  • 23386: Calculation Fix: A drag and drop fill result was incorrect after enabling manual calculation
  • 22389: Excel IO Fix: Importing an SJS file would throw an error
  • 23438: ReportSheet Fix: Exporting an Excel file with a ReportSheet in it would be slow
  • 23467: Excel IO Fix: Some images would be missing after importing an Excel file
  • 23570: Calculation Fix: A formula result was changed after upgrading to a newer version
  • 23581: Calculation Fix: Some calculation results were inconsistent
  • 23592: Fix: An issue was happening with a default value being set in a cell
  • 23597: Calculation FIx: A formula result was inconsistent with Excel
  • 23599: Table Fix: Some data could not be displayed with table binding
  • 23601: PivotTable: The merge label cells options did not take effect in a PivotTable
  • 23604: Shape Fix: The Shape field type was incorrect when exported to SSJSON
  • 23626: Excel IO Fix: The CSV file export was updated
  • 23635: Fix: The button form control click effect would not work after importing a JSON file
  • 23636: Table Fix: Column formulas would become misaligned after inserting rows into a table that only had headers

  • 16446: Fix: The EditEnded event would fire when a cross sheet reference was made
  • 19665: Chart Fix: The order of charts in a combo chart would not stay the same when using JSON
  • 21711: Accessibility Fix: A VoiceOver screen reader was encountering issues in MacOS 14 and 15
  • 22072: Fix: The culture isn't considered when validating a number
  • 22126: Fix: The priority was not correct when pasting pictures
  • 22382: Fix: Data label font options were not available
  • 22535: Chart Fix: Restricting the number of series in a chart was not working correctly
  • 22612: Excel IO Fix: Extra rows and columns would incorrectly appear after importing an Excel file
  • 22787: Excel Compatibility: Cell spanning after dragging and filling was inconsistent
  • 22834: Fix: Data was not showing correctly after collapsing and expanding
  • 22847: Fix: Data validation would not display correctly
  • 22851: Chart Fix: Horizontal axis units were inconsistent
  • 22858: TableSheet Fix: TableSheet was incorrectly displayed in a panel when inserting a GanttSheet
  • 22862: ReportSheet Fix: Support renaming bound columns of a data source
  • 22863: ReportSheet Fix: Data entry settings could not filter out columns
  • 22865: ReportSheet Fix: The "Show Collapse" button did not work correctly in certain circumstances
  • 22868: Fix: Inputting "-$100" would have different results in certain circumstances
  • 22896: Calculation Fix: The ISREF and INDIRECT functions would have different formula results
  • 22969: Fix: Deleting rows would cause a loss of data validation in some circumstances
  • 22975: PivotTable Fix: Modifying the cells of a PivotTable after setting borders would make the borders disappear
  • 22983: Fix: After closing the Find dialog after using a shortcut, it couldn't be opened with the shortcut again
  • 23011: Performance Fix: Clearing formula values would cause some performance issues
  • 23026: Calculation Fix: A specific formula was incorrect
  • 23037: ReportSheet Fix: An exception was thrown if the DirtyStyle was null
  • 23038: Excel Compatibility: Hyperlink cells were inconsistent with Excel
  • 23042: Fix: Some borders didn't display correctly in the column header
  • 23045: Fix: The sorting status was lost after sorting by cell color and opening the sorting dialog
  • 23050: Excel IO Fix: An exported SJS file was prompted to be repaired in Excel
  • 23051: Excel IO Fix: An invalid format error would occur when opening a specific SJS file
  • 23060: Table Fix: Deleting a filtered row in a table would cause unexpected behavior
  • 23066: Excel IO Fix: Exporting a PDF would remove information from a slicer
  • 23071: Fix: The isUndo property output of a custom command in the RowChanged event was incorrect
  • 23073: Fix: Setting the style of a font would be invalid in some iOS environments
  • 23099: Print Fix: A sheet was missing in a printing preview
  • 23100: Touch Fix: Setting the mask on a cell did work with touch devices
  • 23103: Fix: A shared formula with a free header area was displaying incorrectly
  • 23124: ReportSheet Fix: Formula results were incorrect when adding a record in a ReportSheet
  • 23126: Excel Compatibility: The "Ctrl + A" shortcut behaved different than Excel
  • 23127: Calculation Fix: The formula editor would show as undefined for the listSeparator when the culture was changed
  • 23128: Fix: A slicer was not updated properly when the data source of a sheet was changed
  • 23135: Excel IO Fix: An exported Excel file would crash when sorting in MS 2016
  • 23146: Excel IO Fix: A cell position would be incorrect after moving with the keyboard after exporting to Excel
  • 23149: Excel IO Fix: "GetSpans" would return incorrect results
  • 23171: Fix: When dragging and dropping a data source onto a template,  the error message was not consistent
  • 23176: Demo Fix: The FormatDialog sample displayed an error
  • 23213: Calculation Fix: A custom function would not show in a sheet
  • 23218: Fix: A custom name would overflow text in an auto complete container element
  • 23219: TableSheet Fix: The data would change when a row was deleted from a sorted column
  • 23220: Fix: The dataManager would not notify after loading was completed
  • 23221: TableSheet Fix: There was a delay with clicking and cell selection in the Free Header Area
  • 23222: Designer Resource Fix: Some resources were confusing in certain cultures
  • 23224: Table Fix: The TableColumnsChanged event was not triggered after adding a column to a data source
  • 23229: Fix: Clicking on a cell would cause the whole sheet to be incorrectly repainted
  • 23280: Excel IO Fix: A pivot slicer was lost after exporting to Excel
  • 23296: ReportSheet Fix: The report wizard would throw an error when adding a report
  • 23313: Excel IO Fix: Conditional formatting would not take effect after exporting to Excel
  • 23322: Fix: Deleting records would incorrect influence Circle Invalid Data
  • 23384: Excel IO Fix: A slicer's content was incorrectly changed after exporting to Excel
  • 23385: Excel IO Fix: The style of subtotals in a PivotTable would change after exporting to Excel
  • 23387: Excel IO Fix: A slicer's display content was changed after exporting to Excel
  • 23390: Fix: The defaultDatePattern property was not public
  • 23394: TableSheet Fix: The behavior of TableSheet in Design Mode was not correct
  • 23401: Fix: Selection ranges were incorrect in some circumstances
  • 23402: Fix: After setting pasteSkipInvisibleRange to true, pasting did not work as expected
  • 23403: Documentation Fix: The openPasteSpecialDialog command API was changed
  • 23426: Fix: Data could not be recovered after a slicer filter was cleared
  • 23427: Table Fix: Copying and pasting could incorrectly lead to the expansion of columns in a table in certain circumstances

  • 17838: GanttSheet Fix: GanntSheet tabs did not have a context menu
  • 21649: Framework Support: Next.js 14 is now supported
  • 21695: Framework Support: Angular 17 is now supported
  • 21897: Filter Fix: The filter function worked differently from Excel
  • 22083: Mobile Fix: The Sheet bar couldn't be dragged properly
  • 22085: ExcelIO FIx: Exporting a SJS file to Excel throws an error
  • 22321: Fix: The distribute option didn't work properly using JA-JP culture
  • 22336: Fix: Items could not be selected in an editable comboBox cell
  • 22393: Calculation Fix: The VALUE formula did not work correctly in some circumstances
  • 22409: Chart Fix: The language of an imported chart series could not be changed correctly
  • 22548: Calculation Fix: The GetPivotData formula did not display correctly after exporting to Excel
  • 22575: ExcelIO Fix: Exporting PivotTables when counting multiple column value caused a formatting error
  • 22579: Fix: Copying content from an external source into SpreadJS removed line breaks
  • 22589: ExcelIO Fix: Certain Excel files could not be imported in SpreadJS in some circumstances
  • 22591: Data Binding Fix: Some data binding would cause data validation information to shift downard
  • 22598: ReportSheet Fix: Request failures were not handled correctly when submitting a report
  • 22610: PivotTable Fix: A white screen would show when a PivotTable was refreshed
  • 22617: Mac Fix: Using Chinese input on a Mac would cause the first character to be ignored
  • 22624: Printing Fix: The actual number of printed pages did not match the number of pages in the paging preview
  • 22625: Import Fix: A cell format would change when importing a JSON file and saving as SJS
  • 22631: Fix: Setting a cell status on a range of cells would prevent them from being deleted successfully
  • 22638: UI Fix: The label for creating a new workbook had a typo
  • 22685: Translation Fix: Some Designer resources were not translated properly
  • 22689: Fix: Inserting a new row would cause the row's conditional formatting to be lost
  • 22716: PivotTable Fix: Using a custom PivotTable style would prevent the text from being bold
  • 22717: Table Fix: Setting a table column with a FormulaListValidator in the Designer would fail
  • 22729: Sample Fix: The AngularJSSample would freeze when resizing columns
  • 22732: Fix: The column header did not show correctly in some circumstances
  • 22737: Calculation Fix: A specific formula calculation result was different from Excel
  • 22751: Table Fix: Deleting rows from one table would result in formulas being removed in another table
  • 22780: PivotTable Fix: The PivotTable would become blank when rows were removed fro mthe row field
  • 22794: Fix: Dragging the hiehg of the first row to 0px could only be seen after scrolling up
  • 22844: Documentation Fix: A specific API was not marked as deprecated
  • 22887: ReportSheet Fix: Context menu cellTypes would not work after setting the cellType or CellButton

  • 17704: Chart Fix: The order of a combo chart series was inconsistent with Excel
  • 21991: Language Release: Korean Language release for v17
  • 22070: Chart Fix: Updating a table used by a chart would throw an error
  • 22124: Fix: A hyperlink's tooltip would not correctly display in certain circumstances
  • 22286: Name Fix: The name manager would incorrectly show custom names after a sheet was deleted
  • 22321: Fix: The distribute option didn't work properly with the ja-jp culture set
  • 22327: Performance Fix: Clicking on a slicer would cause the page to freeze or crash in some circumstances
  • 22340: Fix: Hiding a row would incorrectly change the border style of specific rows
  • 22356: Excel IO Fix: After importing and exporting XLSX files, column width would gradually become narrower
  • 22400: Fix: Protecting a worksheet would work differently in runtime versus the Designer
  • 22431: Printing Fix: Slicers and shapes would not scale correctly when printing
  • 22432: PivotTable Fix: Deleting a PivotTable slicer would cause a white box to appear on the page
  • 22544: Licensing Fix: GanttSheet license strings were not working correctly in the JP version
  • 22547: Calculation Fix: Setting the ExcelCompatibleCalcMode to true resulted in some inconsistencies
  • 22549: Fix: Frozen rows would obsure unfrozen rows
  • 22576: Scrolling Fix: A ghosting issue would occur in specific circumstances
  • 22580: Calculation Fix: The SUBSTITUte function did not calculate correctly
  • 22590: Table Fix: A table format could not be set correctly

  • 18195: Chart Fix: Chart content did not change with data
  • 19522: Fix: A timeline is not displayed after importing
  • 20127: Chart Fix: A chart series did not display correctly
  • 20708: Chart Fix: A chart did not refresh with data changes in a table
  • 21710: Chart Fix: The position of a chart legend would change after exporting
  • 21733: Fix: A radio button could not be selected
  • 21901: Chart Fix: The curve chart auto functionality did not work correctly
  • 21931: Export Fix: An exported file did not display correctly
  • 21948: Export Fix: An exported file could not be loaded in GcExcel
  • 21969: Fix: Setting styles on a large range would incorrectly create a large undo stack
  • 21990: Language Release: V17 CN Language Release
  • 22122: Chart Fix: Setting the data source for a table does not refresh the chart
  • 22155: ReportSheet Fix: Adding a record in a new cell without submitting would make the report layout incorrect
  • 22157: Designer Fix: The calculation options button icon did not display correctly
  • 22240: Export Fix: An error was thrown when exporting to XLSX
  • 22253: Fix: The dropdown menu month selector incorrectly sorted the years in reverse order
  • 22267: Export Fix: Certain exported XLSX files could not be opened by Excel or GcExcel
  • 22268: Import Fix: The active sheet was switched twice after loading a specific file
  • 22281: Designer Fix: The total row did not work correctly
  • 22353: GanttSheet Fix: The demo had an uncaught error
  • 22355: Designer Fix: The configuration settings of multiple designers on the same page overwrote each other
  • 22377: Fix: The type definition of the IFilteredArgs interface for the "columns" property was incorrect
  • 22389: Exporting Fix: There was an issue with exporting using the SpreadJS IO functionality

  • 2154: Calculation Fix: A formula was automatically changed incorrectly
  • 12910: Chart Fix: A chart would not display correctly after importing
  • 15436: Designer Fix: Creating a chart was slow in some circumstances
  • 16591: Calculation Fix: A formula was not updated with the RemoveRow RowAction
  • 18662: PivotTable Fix: Setting a style was slow in some circumstances
  • 18748: Calculation Fix: Certain formulas had incorrect results
  • 20299: Excel IO Fix: Some cell values would not display correctly after exporting to Excel
  • 20581: Excel IO Fix: Some Excel files were displayed incorrectly after importing
  • 20710: Calculation Fix: Some formulas would not calculate correctly after using resumeCalcService
  • 20724: Calculation Fix: The lambda formula would not calculate correctly
  • 21375: Chart Fix: A data area would not expand automatically
  • 21652: Chart Fix: Series would display incorrectly after a chart is inserted
  • 21654: Chart Fix: Switching the data axis would fail if the coordinate axis was not a date type
  • 21813: Printing Fix: The cutting action would incorrectly change the printing area
  • 21814: Fix: Filter items would not show in a dialogue
  • 21817: Fix: Undoing a filter will incorrectly cause content to be hidden
  • 21869: Designer Fix: Data validation was inconsistent
  • 21879: Fix: AutoFitRow would not work correctly
  • 21882: Fix: The status bar had some errors with sum
  • 21887: Fix: Inserting cut cells caused the page to crash with a large number of rows and columns
  • 21900: Excel IO Fix: Some chart content was missing after importing an Excel file
  • 21902: Fix: Copying and inserting rows caused some errors
  • 21904: Chart Fix: The value axis setting of a radar chart was invalid
  • 21917: Fix: Inserting a sparkline was inconsistent with Excel
  • 21926: Calculation Fix: Deleting a row that contained bound data would prevent a referenced formula from being recalculated
  • 21928: Excel IO Fix: A #VALUE! error was thrown after loading a SSJSON file in the Designer with the it-IT culture
  • 21929: Excel IO Fix: Filter options were lost after exporting and then importing
  • 21932: Mobile Fix: A sheet would be blank after creating a lot of sheets in iOS.
  • 21934: Font Enhancement: The Windgdings 2 font was added to fontFamilies
  • 21940: Fix: The option button controls were not shown correctly
  • 21950: Excel IO Fix: An XLSX file could not be loaded
  • 21951: Calculation Fix: The COUNTIF formula did not calculate correctly
  • 21962: Fix: Setting a row height would take different times in the runtime and the Designer
  • 21981: Fix: Sorting results were inconstent with Excel
  • 21987: Table Fix: Tables in a Data Source Sheet would not update correctly if added by code
  • 22016: Calculation Fix: There was a delay in calculating specific formulas
  • 22067: Excel IO Fix: Cell references were changed incorrectly after importing/exporting a SSJSON file
  • 22086: Fix: The icon set for conditional formatting was displayed incorrectly
  • 22087: Fix: Opening up a data validation drop-down did not automatically scroll to the selected item
  • 22091: Excel IO Fix: Gridline colors were not exported properly
  • 22092: Table Fix: Table Column Data Formulas did not work properly
  • 22096: TableSheet Fix: A certain format would not apply correctly
  • 22102: Fix: Sorting a single cell would show an incorrect error message
  • 22106: Fix: The state of an Option Button was incorrect
  • 22125: Excel IO Fix: A file would not import correctly.

Return to SpreadJS Release

v17 Hotfixes

Related Links

v17 Release Blogs

SpreadJS Blogs

Demos

Documentation