JavaScript Spreadsheet v18 Hotfix Release Information

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

Issues fixed in 18.0.2 - Jan 16, 2025

26221: Export Fix: Style was inconsistent after exporting to Excel
27438: Table Fix: Setting column formulas in a table was slow
27775: Fix: Tooltips were not displayed when hovering over a merged cell in a row header
27781: Accessibility Fix: Expand and Collapse buttons needed more contrast
27811: Fix: Moving a parent heirarchy up and down caused issues
27926: Table Fix: Table header pastes were inconsistent if there was a duplicate column name
27931: Fix: There was an issue with percentage data
27932: Export Fix: Some conditional formatting could be rendered in SpreadJS but would not show in Excel
27940: Fix: Content copied from WPS and pasted into SpreadJS was not correct
27984: Fix: Drag filling a block did not trigger the print line change
27987: Fix: The copy and cut methods of the TouchToolStrip can now be overriden via commands
27990: Fix: Copying content from DingTalk documents to SpreadJS causes a table area to turn white
27991: Chart Fix: Zero-distance display of data labels in a column stacked chart caused issues
27992: Export Fix: A combo box bound to a data source did not correctly display the text when exported to Excel
27997: Fix: In preview mode, clicking print when there is a data-bound combo box would incorrectly show the data as empty

Issues fixed in 18.0.1 - Jan 2, 2025

24597: Calculation Fix: After modifying a value, a formula would not calculate
26238: Calculation Fix: The result of a formula was not displayed correctly
26935: Shape Fix: A picture shape of frozen rows was visible when hiding rows
26946: Shape Fix: A camera shape was having an issue with QR codes
27072: ExcelIO Fix: A cell's foreColor was changing in a Pivot Table after exporitng
27323: Fix: A header image was not correctly displaying in WPS
27364: Chart Fix: A chart position was incorrect when rows were hidden while events were suspended
27439: Fix: Scaling the worksheet size incorrectly altered the text layout in an area camera shape
27491: Chart Fix: A chart's percentage label was not displayed correctly
27509: File Fix: A specific SJS file could not be opened
27536: ExcelIO Fix: The autoFitColumn feature did not work after importing an Excel file
27626: Chart Fix: A pie chart was incorrectly converted to a bar chart
27653: Calculation Fix: Formula results were inconsistent
27674: Chart Fix: A char was not displayed correctly after importing an Excel file
27686: Calculation Fix: A formula was not automatically calculated after importing a file
27706: Fix: Formulas could not be copied using the copyTo method
27727: ExcelIO Fix: An error occured when exporting to XLSX
27734: Calculation Fix: The WORKDAY formula was giving a different result compared to Excel
27745: Calculation Fix: The VLOOKUP formula with a Wildcard Character was giving a different result compared to Excel
27746: Fix: An issue was happening with the DataSource table column visible property
27748: Fix: ReportSheet image formats were not working correctly
27764: Fix: After filtering, data that was pasted into other sheets was incorrectly changed
27778: Performance Fix: Copying and pasting was slow with hidden rows
27779: Fix: Pixel based scrolling would cause display issues
27784: Table Fix: Table resizing was not working
27787: PDF IO Fix: The font in the area snapshot of an exported PDF was changed
27793: Designer Fix: A data source field was incorrect
27807: ExcelIO Fix: Rendering of an imported chart was incorrect
27814: PivotTable Fix: An ampersand was not correctly displayed when re-opening a workbook with a PivotTable
27859: Fix: The CalcArray.toArray result was not correct in certain circumstances
27876: Fix: The toggleCollapseState API was not working correctly
27890: Fix: Setting incrementalLoading when using fromJSON threw an error

SpreadJS v18 Hotfixes