SpreadJS v15 Hotfixes

The latest updates and information on the SpreadJS JavaScript Library.

Please tell us what you think in the SpreadJS forums.

Download the latest release

  • 14767: Picture Enhancement: Trimming functionality has been added
  • 14929: Vue Fix: The rangeSelector would fail when two spread instances are loaded on a page
  • 15034: Designer Fix: The data field of a table was empty in a certain circumstance
  • 15087: Fix: The “Insert Copied Cells” function would throw an exception
  • 15146: Fix: Pasting would fail when using allowExtendPasteRange
  • 15154: Fix: A formula would change the value of a cell when the RowChanging event occurred
  • 15187: Calculation Fix: The SECOND function would return a different value than Excel
  • 15194: Fix: Deleting a sheet would cause a CalcError
  • 15198: Export Fix: Code of a cross workbook formula would appear garbled in an exported Excel file
  • 15213: React Demo Fix: The “AutoSync and Batch Updates” demo did not work properly
  • 15292: Chart Fix: Series name for a chart could not be set to a string
  • 15315: Fix: Merged cells would revert to single cells after pasting to another workbook
  • 15329: Fix: Inserting the last row in a table would fail after using setRowCount
  • 15360: Calculation Fix: A formula would move when canceling a delete row action
  • 15393: Fix: Pasting from Google Sheets would remove strikethrough and underline
  • 15399: Fix: The first item is selected when clicking F2/Shift/Ctrl and Enter/Tab in an editable combo box
  • 15421: Fix: The getDependents function would slow down performance
  • 15441: Fix: The locked status of a cell could not be changed if the cell was a list
  • 15453: Fix: The position of data validation would move after adding rows to a table above the cell
  • 15427: Calculation Fix: When a cross-sheet formula is entered, the Enter key would change to a new line in the cell
  • 15504: Fix: An issue was being cause by a content security policy

  • 5416: Shape Enhancement – An enhancement has been made to shape resizing
  • 13849: Fix – A row header could not be selected when the row height was too small
  • 14343: PivotTable Fix – Grouping would not work properly
  • 14395: Designer Fix – Gaps and connect data point options were not showing correctly when the chart type was set to lineMarkersStacked
  • 14425: Fix - Conditional format could not be set with specific characters
  • 14574: Language – The Japanese language release for v15 Service Pack 2 has been added
  • 14603: Designer Fix – Formulas would be lost when switching sheets in certain circumstances
  • 14731: Fix – addPictureShape would return a CORS policy error
  • 14930: Import Fix – An error would happen when importing a specific SSJSON file
  • 14931: Export Fix – An Excel file would not export correctly
  • 14945: Designer Fix – Dialogs would not open in the correct places
  • 14946: Calculation Fix – The LAMBDA function using recursion would not work correctly
  • 14951: TableSheet Fix – Grouping would not be printed
  • 14958: Fix – Text in a cell was inconsistent with Excel
  • 14962: Calculation Fix – A specific formula result was not correct
  • 15001: Fix – Grid lines would disappear when numbersFitMode was set to overflow
  • 15002: React Fix – A warning would show with React 18
  • 15003: Fix – The RichText editor would incorrectly show “
    ”
  • 15006: Designer Fix – A filter dialog popping up would cause the Designer to move
  • 15013: React Fix – A memory leak was happening with React
  • 15014: Table Fix – The style would change after copying and pasting an empty cell
  • 15016: Chart Fix – A chart would not change when table data was filtered
  • 15018: Calculation Fix – Formulas with SUMIF would not calculate correctly
  • 15023: Designer Fix – Import CSV encoding settings did not work correctly
  • 15024: Calculation Fix – Filling formulas would take too long
  • 15031: Export Fix – Exporting an Excel file would show a warning
  • 15035: Import Fix – An invalid formula exception was thrown after importing an Excel file
  • 15108: Performance Fix – Show Outline would cause the page to freeze
  • 15110 and 15111: Fix – Displayed text in a cell was not correct
  • 15129: Export Fix – Exporting a PivotTable in an Excel file would corrupt the file in certain circumstances
  • 15136: Designer Fix – The TEXTSPLIT function would not display in the dropdown list
  • 15152: Fix – The RangeChanged event would not fire correctly when copying a whole row and then inserting the copied cells with the context menu

  • 10718: Chart Fix – Series overlap would not work in stacked charts with a secondary axis
  • 11167: Chart Fix – The major units of a vertical axis would change when importing
  • 12959: Chart Fix – The trendline formula would not display correctly after importing the workbook
  • 13941: Chart Fix – A chart with unbound data would not import correctly from Excel
  • 14360: ExcelIO Fix – The style of an exported Excel file would change
  • 14372: Calculation Fix – COUNTIF would not work correctly if the range contains “#N/A”
  • 14403: Fix – A CSS leak would occur in certain circumstances
  • 14524: Language Fix – The time selector button would show “OK” using Chinese resources
  • 14554: Chart Fix – The formula in a chart was inconsistent with Excel
  • 14555: Fix – An exception would be thrown when setting a duplicate value in a conditional rule
  • 14563: Calculation Fix – The COUNTIF formula result was incorrect
  • 14573: Language Release – The Korean language release for v15 Service Pack 2 was included
  • 14590: Designer Fix – Ctrl+F would search slowly in the Designer when there was a large amount of data
  • 14637: Fix – Text rotated 90 degrees would display differently from Excel
  • 14662: Performance Fix – Performance was different between the SpreadJS runtime and the Designer Component
  • 14663: Calculation Fix – Setting 0.5 in the LCM function would cause SpreadJS to freeze
  • 14666: Shapes Fix – Shapes would not be imported correctly from Excel in specific circumstances
  • 14671: PDF Fix – Page numbering on exported PDF files would restart from 1 on the third page in certain circumstances
  • 14676: Designer Fix – The default style was lost when clicking a specific button
  • 14679: ExcelIO Fix – The account format was different between SpreadJS and Excel
  • 14715: Fix – Freezing the top row would prevent multiple columns from being hidden at the same time
  • 14716: ExcelIO Fix – Formulas would change after importing an Excel file
  • 14724: Fix – Updating data dynamically would cause issues with a formatter
  • 14739: Fix – Copying data from SpreadJS to Excel would cause strange behavior
  • 14740: ExcelIO – Excel would throw an error when importing a specific file that was exported from SpreadJS
  • 14743: Calculation Fix – The REDUCE function would not support returning an array
  • 14773: Fix – The style of a button would conflict with bootstrap
  • 14776: ExcelIO – A certain Excel file would not be imported
  • 14778: ExcelIO – A cell pattern color would be different after importing an Excel file
  • 14781: Fix – Unfreezing a row/column would not undo correctly
  • 14785: Fix – Repeating page transitions quickly would cause issues
  • 14799: Designer Fix – General cells would display incorrectly in some circumstances
  • 14818: Fix – Hyperlinks would break when cutting and inserting cut cells
  • 14863: Fix – repeatColumnStart and repeatRowStart would not work correctly
  • 14872: Designer Fix – Setting a specific format would not work correctly
  • 14890: Fix – Selection range background would darken when dragging
  • 14908: PDF Fix – Picture display was inconsistent when exported to PDF
  • 14916: Printing Fix – Using fitPage would cause shapes to be incorrectly printed
  • 14921: Designer Fix – The Designer would freeze with 75% zoom and a 1920x1080 display resolution
  • 14929: Vue Fix – The rangeSelector would fail when two SpreadJS instance were loaded on a page

  • 14328: PivotTable Fix – Refresh would not work after using fromJSON
  • 14365: Fix – Values would change to scientific notation after importing a file in some cases
  • 14490: Designer Fix – Tags could not be deleted in certain circumstances
  • 14499: Fix – An Android mobile terminal could not listen to the input of a @ value
  • 14506: Designer Fix – Pasting a value was incorrect in some circumstances
  • 14518: PivotTable Fix – Excel-like labels were not supporting under the Value field settings
  • 14532: Fix – The left border of the first row in a worksheet could not display correctly
  • 14540: PivotTable Fix – Icon positions were not properly aligned after filtering fields
  • 14584: Fix – Importing an Excel file exporting from SpreadJS would throw errors with reading certain properties
  • 14604: Designer Fix – Clear format would not clear the outside border of a cell

  • 11544: Fix – Values could not be entered directly after inserting a row
  • 12772: Fix – Entering a value into a newly inserted row would not work correctly in Windows
  • 13080: React – SpreadJS now supports React 18
  • 13293: Angular – SpreadJS now supports Angular 14
  • 13306: PivotTable Fix – Importing an Excel file with a PivotTable would not show correctly
  • 13412: Fix – The scrollbar would automatically scroll when clicking the viewport in some situations
  • 13510: PivotTable Fix – When importing an SSJSON with two PivotTable, values were overridden
  • 13550: Calculation Fix – Formula cells in a filter function range were not automatically calculated
  • 13561: Export Fix – An exported Excel file could not be opened correctly in Excel
  • 13601: Designer Fix – The color picker would open at the wrong position
  • 13625: Fix – Clicking the filter button would cause the page to hang
  • 13644: Designer Fix – The line height style would display incorrectly after modifying the font
  • 13718: Designer Fix – The formula dropdown caused issues with some options not being displayed
  • 13719: Fix – Some hyperlinks in formulas would not work correctly
  • 13736: Fix – Text with a 90-degree rotation and word wrap would overflow to adjacent cells
  • 13744: Designer Fix – An incorrect message would be displayed when using the replaceAll feature on a protected sheet
  • 13750: Fix – The OK/Cancel named style would show buttons at incorrect times
  • 13753: Fix – A cell range could not be pasted after undoing a paste
  • 13758: Fix – The size and position of an exported picture were inconsistent in Spread JS
  • 13786: Designer Fix – Exporting a CSV would cause errors in some cases
  • 13787: Fix – The behavior of the Ctrl + X operation on locked cells in a protected sheet was incorrect
  • 13807: Fix – Setting the background color of a subtotal row would not work in certain situations
  • 13810: PivotTable Fix – A PivotTable had some accuracy issues with the data
  • 13814: Fix – Using the context menu’s delete option would incorrectly delete filtered rows
  • 13816: Designer Fix – An error would be thrown with Vue3 integration
  • 13836: Designer Fix – An error would be thrown with Vue2 integration
  • 13848: Fix – The “Open in a New Window” button would not work correctly
  • 13914: Designer Fix – The Designer would not work correctly with IE 11
  • 13958: Designer Fix – The header style would not be applied to the column header of a TableSheet when it doesn’t have a FreeHeaderArea
  • 13992: Fix – Filtered items would be missing after exporting JSON

  • 12044: Chart Fix – XY Scatter Lines charts were not imported correctly from Excel
  • 12957: PivotTable Fix – Pivot panel didn’t display immediately when selecting a PivotTable
  • 13549: Shape Fix – Comments would not resize correctly when the zoom is not 100%
  • 13564: Slicer Fix – disableResizingAndMoving did not work correctly
  • 13584: PivotTable Fix – Clicking on a specific PivotTable would throw an exception
  • 13636: Designer Fix – Integrating with Vue3 would stop the page from being repainted if using fromJSON
  • 13034: Calculation Fix – Using the maximum row count of Excel would cause formula reference issues in SpreadJS
  • 13064: Fix – Changing the style of valueField would cause issues
  • 13150: Fix – The table binding path button would incorrectly appear on a field template when opening the field list
  • 13385: Calculation Fix – Dynamic array functions would convert dynamic data to values when using Sheet.recalcAll()
  • 13502: Fix – Exporting data bar conditional formatting rules would cause issues
  • 13524: Fix – An image would not be shown inside of a camera shape
  • 13537: Fix – The RangeChanged event would not get fired for dependent cells when undo operations were performed twice
  • 13575: Fix – Getting HTML content using toHtml wouldn’t work correctly
  • 13603: Fix – Copy and paste would not work correctly when ‘border-collapse’ and ‘table-layout’ were assigned in CSS
  • 13606: Fix – Issues would arise with using conditional formatting rules
  • 13633: Fix – A specific worksheet would be blank after importing
  • 13637: Calculation Fix – Formula calculation would be incorrect if the sheet name was using Chinese characters
  • 13713: Fix – Formatters would not work when using table binding
  • 13730: Designer Fix – Translating numbers to Korean with the Format Cells dialog would stop the "Settings" popup from working

  • 13077: Performance Fix – There were performance issues with editing certain cells
  • 13078: Performance Fix – There were performance issues with editing certain formulas
  • 13085: Fix – The rangeChanged event would not fire when entering certain formulas in cells
  • 13393: Fix – DOM elements and events would not be destroyed after calling destroy in the Designer and the SpreadJS runtime
  • 13418: Chart Fix – Changing chart type or style was broken if the sheet name contained spaces or special characters
  • 13082: Language Release – Korean Language support for v15 Service Pack 1 was added
  • 13152: Fix – The table filter button visibility could not be controlled by the Table Design section of the Designer
  • 13212: Fix – Copying/pasting a slicer in SpreadJS would prevent the file from opening up in Excel
  • 13213: Fix – Deleting table rows did not work as expected in some cases
  • 13315: Fix – The undo behavior of Format Painter was inconsistent with Excel
  • 13322: Fix – Focus would not move from SpreadJS with a defined shortcut key if a ComboBox was set at the first and last cells in a sheet
  • 13352: Fix – A floating object would not be correctly removed or added if done within a suspendPaint/resumePaint block
  • 13363: Fix – Inserting a column in a bound table would not move the style with the column
  • 13366: Formula Fix – The QUERY function did not have a description
  • 13374: Formula Fix – The WebService function with LAMBDA would not correctly calculate with a custom name
  • 13380: Fix – LocalNumberFormat would cause issues in some cases
  • 13395: Designer Fix – The rowHeight could not be correctly returned if it was 0
  • 13412: Fix – Clicking within the viewport would scroll the scrollbar automatically in some cases
  • 13429: PivotTable Fix – The Pivot panel would become cluttered if the PivotTable fields were too long

  • 13008: Chart Fix – The dataRange of a chart could not be fetched correctly after deserialization
  • 13031: Chart Fix – The secondary axis of a combo chart was last after deserialization
  • 13035: Fix – An image would disappear after setting the row height to 0 and resizing again
  • 13040: Fix – Data validation would be shifted when adding columns to a table
  • 13041: Fix – Resizing a floating object would not work correctly
  • 13042: Sparkline Fix – A barcode would show a #VALUE! error when the codeset was auto
  • 13045: Performance Fix – Copying large columns on Mac would cause performance issues
  • 13064: Fix – Changing the style of a valueField would not work correctly
  • 13081: Feature – CN Language Release for v15.1
  • 13108: Fix – An HTML input element used inside of a floating object could not be entered
  • 13132: Fix – The moveToPreviousCellThenControl command would not work correctly when there was a combo box
  • 13138: Calculation Fix – The SUM function in the Designer would not calculate in a mobile browser
  • 13140: Designer Fix – The filter button in the ribbon would not correctly add a filter button in a table
  • 13146: Fix – Validation behavior was inconsistent with Excel
  • 13155: Fix – A file exported from SpreadJS would not open in Excel
  • 13156: Fix – A file could not be exported from SpreadJS and displays an incorrect file format error
  • 13162: Fix – Exporting a SpreadJS file to Excel would show an Excel promotion message box in Excel 2016 or Excel 2013
  • 13172: Fix – Calling setDataValidator would clear the validation of a different cell
  • 13205: Chart Fix – Sunbusrt charts had issues with colors in the legend
  • 13218: Fix – Deleting columns from the columnHeader would affect a table data validation formula
  • 13220: Fix – Importing JSON data would throw a console error

  • 8685: Fix – Cells covered by the cell edit box while editing formulas couldn’t be selected
  • 9397: Performance Fix – A large file caused out of memory errors in the browser
  • 10614: Chart Fix – The Browser would crash when importing charts that had different vertical axes
  • 12121: Fix – Cell values couldn’t be edited normally in specific circumstances
  • 12326: Fix – Importing Excel files with filters would not work with grouping
  • 12331: Fix – A STATUS_BREAKPOINT error was thrown in specific circumstances
  • 12501: Fix – The trendline of a chart was incorrect after exporting a JSON from SpreadJS
  • 12502: Fix – Opening a file would move the workbook out of view
  • 12509: Fix – Checkboxes would only work in Edit Mode when named styles were applied
  • 12531: Designer Fix – Vertical scroll bars would disappear after changing with width of the horizontal scrollbar
  • 12546: Calculation Fix – T.Dist formulas would show #NUM errors
  • 12552: Fix – Binding data to a table would remove data validation
  • 12553: Fix – Cells would disappear after setting watermark text to a cell whose foreColor was null
  • 12556: Calculation Fix – The COUNTIF function would return incorrect results
  • 12559: Calculation Fix – The Binom.DIST function would return incorrect results
  • 12560: Calculation Fix – The Binom.INV function would return incorrect results
  • 12561: Calculation Fix – The F.DIST.RT function would return incorrect results
  • 12562: Fix – Cmd+y did not prevent default actions in Mac OS
  • 12617: Fix – Setting MultipleStyleName on a single cell would not work properly
  • 12620: Fix – The percentage formatter would not work correctly using an AZERTY keyboard
  • 12637: Fix – The page would get stuck after using setArray
  • 12645: Fix – Print preview would show extra borders
  • 12654: Fix – Saving a specific Excel file would throw an error
  • 12661: Fix – The input message could not be displayed after setting data validation on cells
  • 12665: Fix – Row outlines were not displayed properly after turning on scrollByPixel

  • 11763: Fix – Rendering issues would happen when drop down items were in cells near the last row in a sheet
  • 11821: Fix – Importing an Excel file would throw an out of memory error
  • 11919: Fix – Auto fit row height would not work properly
  • 12330: Fix – Overflowed cells copied from Excel would paste as merged in SpreadJS
  • 12370: PivotTable Fix – The customTableStyle in the PivotTableStyleDialog did not work
  • 12378: Chart Fix – Data labels would not scale properly when the Value Axis display units were changed
  • 12453: Fix – Collapsing/expanding row outlines would be slow and unresponsive in some cases
  • 12454: Fix – Drag-filling a table by double-clicking would add an extra row
  • 12491: Fix – Setting specific formulas would cause the page the freeze and CPU usage to go up
  • 12493: Fix – Text could not be edited in a shape after inputting text that started with ‘=’
  • 12494: Fix – A shape on a row would not be properly removed when that row was removed

  • 11737: Resource Update – Updated Japanese language resources
  • 11738: Resource Update – Updated Korean language resources
  • 12057: Fix – An Uncaught TypeError would occur on RowFilters when search for text that doesn’t exist
  • 12088: Fix – A TypeError was thrown when multiple RowFilters were displayed on screen at the same time
  • 12127: Designer Fix – A filter button was disable in certain circumstances
  • 12138: Fix – A subtotal function would only get calculated when the Range Group was in its expanded state
  • 12141: Designer Fix – A filter button would not disappear after unchecking the filter button in a filter dialog
  • 12169: Fix – Text could not be correctly pasted into a shape
  • 12171: Fix – Deleting table columns after adding a custom name would not trigger the TableColumnsChanged event
  • 12187: Fix – Inserting a column in a table would sometimes cause an error to be thrown
  • 12222: Designer Fix – The webpage would hang after importing a specific JSON file
  • 12253: Fix – Pasting text in shapes would erase all the previous text
  • 12254: PivotTable Fix – The style for a view would be missing after using fromJSON/toJSON
  • 12255: PivotTable Fix – Some values would show incorrectly after using fromJSON/toJSON
  • 12270: Designer Fix – Some font names would not display correctly
  • 12280: TableSheet Fix – Rows would not get refreshed when adding a new row if the table was referenced somewhere else
  • 12284: PivotTable – The Date To Date Filter would not work properly when Japanese resources were applied to SpreadJS
  • 12286: PivotTable Fix – The addCalcField method would throw an error in some circumstances
  • 12290: Designer Fix – An incorrect file format error would be shown when opening certain files generated from Google Sheets
  • 12293: Fix – The isPrintLineVisible method would not work correctly
  • 12301: Fix – A certain chart of a copied sheet could not be deleted
  • 12306: Designer Fix – Removing an underline for a column would not work properly
  • 12320: Fix – The “Error value as” property would not work correctly for subtotals

  • 11741: Chart Fix: Some chart details were missing when importing from Excel to SpreadJS
  • 11903: Fix: The resumeCalcService method would not calculate some formulas
  • 11906: Fix: An incorrect date value was inserted when clicking on the space between dates in the dateTimePicker
  • 11915: Fix: The duration function result was incorrect
  • 11922: Fix: A ComboBox selection would be incorrect
  • 11980: Designer Fix: The Designer would become unresponsive when importing an Excel file
  • 12022: Designer Fix: The Fill options did not ignore filtered out cells
  • 12027: Fix: Values in specific cells were not shown after upgrading the version of SpreadJS
  • 12056: Angular Fix: There was a build problem with Angular v13.2.0
  • 12074: Fix: The background color of cells was inconsistent
  • 12106: Designer Fix: The “Zoom to Selection” button had to be clicked twice to work
  • 12115: Fix: Certain SSJSON files could not be imported
  • 12124: TableSheet Fix: The comparisonOperator of NumberValidatorOptions was undefined
  • 12128: Fix: The fraction format (?/?) did not work properly

  • 8976: Chart Fix: The color for doughnut charts in a legend would show as the default color
  • 10672: Fix: Hidden rows would be visible after importing from Excel
  • 10971: Fix: Spanned cells would be filtered improperly when exported to Excel
  • 11794: Performance Fix: Volatile functions would degrade performance when opening workbooks
  • 11799: Fix: Ctrl + / shortcuts would not work as expected
  • 11816: Fix: Specific formulas would evaluate different compared to Excel
  • 11822: Designer Fix: Updating the ribbon would cause some performance issues
  • 11824: Fix: The doNotRecalculateAfterLoad option would not take effect after importing an Excel file in the Designer
  • 11840: Fix: Moving a VLOOKUP formula to a different cell range would cause unintended changes to cell display
  • 11842: Fix: Auto merging results were incorrect in some cases
  • 11881: PivotTable Fix: Some slicers would disappear when refreshing a PivotTable
  • 11917: PivotTable Fix: Custom themes would be lost in the Designer

  • 11776: Fix: Search input for the Filter context menu had an issue
  • 11743: PivotTable Fix: A user was unable to refresh the PivotTable if the source is a column reference
  • 11736: Feature: Released CN language support
  • 11370: Fix: SpreadJS would get stuck when editing cells in IE11

Return to SpreadJS Releases

v15 Hotfixes

Related Links

v15 Release Blogs

SpreadJS Blogs

Demos

Documentation