Skip to main content Skip to footer

SpreadJS v17 Hotfixes

The latest updates and information on the SpreadJS JavaScript Library.

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

  • 23448: Excel IO Fix: Hiding the row and column headers after importing would cause lines to appear in a table
  • 23568: Excel IO Fix: Importing and exporting files with Sunburst or Treemap charts with text data sources would result in an error
  • 23877: Excel IO Fix: Importing files that were loaded incrementally would mean data in an Excel file would sometimes need to be refreshed to display properly
  • 24030: Excel IO Fix: An error would occur after importing a specific Excel file
  • 24125: Calculation Fix: A #Value error would be displayed after copying and pasting a formula in another cell due to a list separator
  • 24130: Fix: The Date Time Picker would not show the correct end date in some circumstances
  • 24146: Chart Fix: Scrolling in a chart area on mobile would not work in certain circumstances
  • 24152: Chart Fix: Combination chart insertion methods were inconsistent in certain circumstances
  • 24174: Excel IO: Importing and then exporting a file to Excel would cause style loss in certain circumstances
  • 24203: Calculation Fix: In certain circumstances a calculation would need to be done twice
  • 24205: Calculation Fix: A protected sheet would incorrectly have AutoSum disabled
  • 24284: Excel Compatibility Fix: A tree diagram in SpreadJS was different from Excel
  • 24286: Fix: Cell prefix single quotes would incorrectly be replaced
  • 24326: Excel IO Fix: Importing an protected Excel file with a password would result in an exception in certain circumstances
  • 24327: Fix: Create a tree diagram would throw errors when right-clicked in certain circumstances
  • 24329: Calculation Fix: SUMIFS formula results would display incorrectly
  • 24348: ReportSheet Fix: Calculation results were inconsistent
  • 24355: Fix: Copying multiple cells in a column would result in extra \r\n characters at the end of the string
  • 24415: Fix: A locked attribute was true after filling some cells
  • 24451: Fix: A worksheet was frozen when there was an invalid formula in a table column

  • 21982: Fix: A conditional format was inconsistent with Excel
  • 23421: Excel IO Fix: Importing a specific Excel file would fail
  • 23801: ReportSheet Fix: The right-click menu for the row and column headers was invalid
  • 23844: Performance Fix: Setting isPrintLineVisible to true caused cell editing operations to lag
  • 23870: Calculation Fix: A formula result after replacing a value was inconsistent
  • 23879: Fix: The SpreadJS instance would freeze after inserting a line and entering data
  • 23895: Table Fix: The column header dropdown of a table would overlap an autofitted column title
  • 23956: ReportSheet Fix: Changing a dropdown value would not submit changes
  • 23957: Fix: A range selector value would be cleared when changing sheets
  • 23958: Fix: There was an issue setting "100%" as a default value
  • 23960: Fix: A column would display incorrectly when using Ref and binding to a data source in a Vue3 project
  • 23962: Fix: There were not unique IDs for two different context menus
  • 23984: Fix: An error occurred when opening a filter dialog if listFilterArea and useTouchLayout were used
  • 23991: Calculation Fix: Calculation results were inconsistent
  • 23995: ReportSheet Fix: Data entry would be enabled even if the settings were empty
  • 23998: Designer Fix: The Designer.sheetSettings command would not correctly fire
  • 24012: Fix: When pixel scrolling was enabled, some offsets would show when showRow and showColumn were used
  • 24013: Fix: The context menu could not be used to shift cells down to allow more overflow space to resolve a SPILL
  • 24014: Fix: Pasting over a dynamic array via right-click would not work
  • 24015: Fix: If a dynamic array formula referred to an array of cells on a different sheet, inserting rows to resolve the SPILL did not work
  • 24019: Calculation Fix: The result of an XMATCH function was incorrect when the find array length was 1
  • 24022: Calculation Fix: The IFERROR function would incorrectly processing null as 0
  • 24038: Excel IO Fix: An error would be thrown when exporting a specific Excel file
  • 24042: Fix: A sheet would become blank after a slicer was inserted
  • 24053: Excel IO Fix: An invalid outline would appear after exporting a file from SpreadJS and importing in Excel
  • 24124: PivotTable Fix: A pivot slider panel was blank in certain circumstances
  • 24126: Fix: A sort result was different between Firefox and Chrome
  • 24127: Fix: A clipboardPaste setting with "Paste only format" was invalid
  • 24131: PivotTable Fix: SpreadJS and Excel had different behaviors for Pivot Panels
  • 24138: Fix: The RepeatColumn setting would conflict with FitPageWide
  • 24142: Excel IO Fix: The forecolor of a hyperlink would change after importing

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