x

Exciting news! We are now MESCIUS USA, Inc. Read More!

We are now MESCIUS USA, Inc. Read More!

We are now MESCIUS USA!

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