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.

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