MR 12.2.5 - September 12, 2019

SpreadJS Build 12.2.5 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.2.5

  • 763: Chart labels no longer disappear after moving the chart’s data range and then undoing
  • 1117: Can now handle undo operation for adding/deleting row/column correctly
  • 1249: Formulas now calculated correctly after using the “doNotRecalculateAfterLoad” flag
  • 1452: Fonts no longer change abnormally when setting conditional formatting
  • 1510: The value of “oldSelections” of the “SelectionChanged” event is now correct after drag-fill operation
  • 1527: The value of “rowList” of the “RowHeightChanged” event is now correct when resizing the header row when multiple rows are selected
  • 1558: Date format is exported correctly when applied at the column level
  • 1564: Shape borders are no longer missing when exporting to PDF
  • 1576: The “refersTo” property of a custom name using the name manager can now be edited
  • 1577: Cells no longer freeze when entering an invalid expression into the cells using the setFormula() function
  • 1620: The style no longer results in an error after exporting to Excel when using the headerStyle property in Angular
  • 1631: FORMULATEXT formula now works for cross-sheet references

MR 12.2.4 - August 29, 2019

SpreadJS Build 12.2.4 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.2.4

  • 1463: goToRange not defined
  • 1453: Cell reference with absolute references now displays correctly
  • 1440: Formula updates incorrectly when inserting a table row
  • 1437: Can’t properly serialize the “conditionRuleBase” type
  • 1429: SpreadJS Online Designer unable to set font for a region
  • 1408: Loading the same template twice fails to copy
  • 1378: SSJSON missing after exporting to Excel
  • 1296: changeformulareference is now working correctly
  • 1272: Copying cells causes cell span
  • 1261: Error when calculating SUM formula
  • 1230: Incorrect range update in formulas after cut/paste
  • 1227: Exporting to Excel with Firefox generates zip file
  • 1217: Inconsistent behavior when deleting filtered rows using context menu
  • 1181: Performance issues with workbook.destroy()

MR 12.1.3 - June 17, 2019

SpreadJS Maintenance Release 12.1.3. is now available for download in the DevChannel and on the download page.

Issues fixed in 12.1.3:

  • 272972: Sheet tab strip not visible in imported Excel file
  • 271936: Modifying the name of a worksheet causes the page to freeze
  • 262780: Table formulas don’t work correctly when bound

MR 12.1.2 - May 31, 2019

SpreadJS Maintenance Release 12.1.2 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.1.2:

  • 272672: Inconsistent cell formatting after importing from Excel into SpreadJS
  • 272822: Filter dialog showed an invalid license error for evaluation keys
  • 272848: Filter dialog gave the wrong formatting to outline lists for the number data type
  • 272895: Performance issues with the CellRange font API
  • 272041: Conditional formatting rule’s priority issues
  • 272898: Header dialog won’t open
  • 272671: Data is dumped into the project via command line

We've also added a new property to the Workbook class in SpreadJS called calcOnDemand. This property allows the developer to choose when to calculate formulas (when required).

MR 12.1.1 - May 20, 2019

SpreadJS Maintenance Release 12.1.1 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.1.1:

  • 271758: Fixed a formula updating issue with named ranges
  • 267105: Fixed a right border issue
  • 272143: Corrected shape position and picture size issues
  • 265969: Fixed Excel compatibility issue with Stock charts
  • 271591: Corrected a cell formatting issue that caused exceptions
  • 272389: Corrected an issue that prevent the ActiveSheetChanged event from firing
  • 272109: Fixed an issue with invalid data in the table filter list
  • 271556: Fixed an issue with getting the cell backColor
  • 271513: Corrected an issue with hiding sheets
  • 271480: Fixed a chart export issue
  • 271896: Corrected a axis title transparency issue
  • 272038: Fixed an exporting PDF exception
  • 272455: Fixed a DataRange dragging issue
  • 271993: Corrected an issue with axis labels and set axis units
  • 271995: Fixed a chart position issue
  • 272118: Fixed an animated chart export issue
  • 270994: Corrected an inconsistency in the CellChanged event
  • 271140: Corrected an issue with inserting columns in a table
  • 271544: Corrected a conditional format formula issue
  • 271170: Fixed an issue with NumberFormat.numberGroupSizes
  • 271318: Fixed an issue with PDF exporting and SVG images
  • 272101: Corrected a browser tab crash issue when exporting to PDF
  • 272105: Fixed a custom format string issue
  • 272119: Corrected a memory/RAM issue with successive Excel imports
  • 271224: Added support for runtime-only build of Vue

MR 12.0.10 - March 29, 2019

SpreadJS Maintenance Release 12.0.10 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.10:

  • 270846: Fixed importing certain cell formatting.
  • 270527: Fixed line shape position.
  • 270478: Fixed an issue with “SUMIFS” formula being changed during export.
  • 270386: Fixed RichText importing issue.
  • 270289: Fixed formatting of certain function text.
  • 270431: Fixed pie chart category rendering.
  • 270365: Fixed PrintInfo’s firstPageNumber() method.
  • 270439: Fixed font issue when importing Excel document in SpreadJS
  • 270153: Fixed custom separator issue.
  • 270447: Fixed font color importing issue.
  • 270483: Fixed conditional formatting border problem.
  • 270506: Fixed chart freezing with undo issue.
  • 270000: Fixed picture size export issue.
  • 270514: Fixed worksheet name saving issue.
  • 269888: Fixed pie chart transparency issue.
  • 270612: Fixed conditional formatting font issue.
  • 269829: Fixed chart animation export/import issue.
  • 270796: Fixed a problem with a chart axis moving when importing.
  • 269745: Fixed an issue with 100% Stacked charts.
  • 270890: Fixed the result of the AVERAGEA function.
  • 269174: Fixed an issue with pictures changing size and location.
  • 270927: Fixed performance issue with setting format for 1000 cells.
  • 270996: Fixed Pie chart data label import issue.
  • 268671: Fixed exporting issue with style.
  • 271004: Fixed a formula issue after importing.
  • 263729: Fixed a floating object issue.
  • 259452: Fixed a format pasting issue.
  • 270445: Fixed a SpreadJS Designer Licensing bug.
  • 270174: Fixed a DataValidation copy issue.
  • 269513: Fixed the fitPagesTall export setting.
  • 270131: Fixed designer search results.
  • 270086: Fixed a PrintToPDF issue.
  • 270191: Fixed a problem with the AVERAGEIF formula.
  • 270195: Fixed a problem with the RangeFiltering and RangeFiltered events.
  • 270237: Fixed a problem with columneHeaderAsFrozenRows.
  • 270542: Fixed an issue with decimal increase/decrease.
  • 270601: Fixed a chart issue with switching rows/columns.
  • 271069: Fixed an error with concatenating formulas.
  • 264215: Fixed an issue with Combo charts not importing properly.
  • 270811: Fixed an issue with the setColumnDataFormula method.

MR 12.0.9 - March 5, 2019

SpreadJS Maintenance Release 12.0.9 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.9:

  • 270060: Fixed an issue with cross-worksheet formulas not updating correctly during the undo process.
  • 270055: Fixed a problem with cross-worksheet formulas not updating correctly when drag-dropping.
  • 269354: Fixed a compatibility issue preventing Excel files generated from Spread.Sheets from being opened in another spreadsheet-like product.

MR 12.0.7 - January 31, 2019

SpreadJS Maintenance Release 12.0.7 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.7:

  • 269192: Fixed an issue with the PDF417 barcode that prevents specific data from being scanned correctly.
  • 269201: Corrected a formatter display issue.
  • 269185: Fixed a VLOOKUP issue where the result was different from Excel.
  • 268811: Fixed a problem with single quotes in a worksheet’s name.
  • 269501: Fixed an issue that prevents Excel files with custom formatting from being opened.
  • 269535: Fixed a problem that prevents exporting to Excel after importing SSJSON files into SpreadJS.

MR 12.0.6 - January 18, 2019

SpreadJS Maintenance Release 12.0.6 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.6:

  • 268403: Fixed an issue that caused the DataValidation List to not work on mobile platforms.
  • 268963: Fixed an exporting exception that is thrown when importing a special Excel file.
  • 267207: Fixed a problem with the cell boundary line not being drawn when the height or width of the sheet is in the vicinity.
  • 268989: Fixed an issue with setting a style option in the formatting dialog.
  • 268967: Fixed a problem that causes a string to be added to the series name in combo charts.
  • 268906: Corrected a problem with charts not displaying correctly after loading to a sheet.
  • 268624: Fixed performance issues when applying multi-validation to the sheet.

MR 12.0.5 - January 3, 2019

SpreadJS Maintenance Release 12.0.5 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.5

  • 268755: Fixed an issue that prevents cell comments from being imported from an Excel file if the application is built in production mode.
  • 268601: Fixed a problem that makes the font color in the Designer Rich Text Dialog in correct.
  • 268649: Fixed a problem that caused the Designer rich text feature to add “\r\n” at the end of the text.
  • 268700: Fixed an issue where a point can’t be plotted with X and Y values in a scatter chart.
  • 268562: Fixed a Designer SSJSON export error.
  • 268474: Fixed a problem with using the TRANSPOSE formula cross-sheet.
  • 268536: Fixed an issue that prevents input data from being stored in a data source.
  • 268490: Fixed a fromJSON error that is thrown with special json data.
  • 268576: Fixed a problem with setting a LOOKUP formula.
  • 268591: Fixed an issue the prevents an exported Excel file from SpreadJS from being opened in Excel.
  • 268724: Fixed a problem that prevents the same color option in the Designer’s rich text dialog from working.
  • 268679: Fixed an issue where a picture’s width/height ratio is changed after importing.
  • 268557: Fixed an issue that causes the primary value axis in a min/max range to be inconsistent based on data.
  • 268585: Fixed an error that shows when using the SUMIF formula.

MR 12.0.4 - January 2, 2019

SpreadJS Maintenance Release 12.0.4 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.4

  • 268204: Fixed an issue that makes grayAreaColor transparent.
  • 268132: Fixed a problem that causes data validation to not work after importing an Excel file.
  • 268182: Fixed a Designer issue where the “\n” character is lost when editing a multi-line rich text cell.
  • 268263: Fixed an issue that removes font color after exporting to Excel.
  • 268212: Fixed a problem where the EmptyString of a cell’s value in the toJSON function isn’t the same as a null cell.
  • 267259: Fixed an issue where the sum function doesn’t adjust the range when delete cells and shifting up.
  • 268443: Fixed a problem where the formula cell is displayed as #NAME after exporting to Excel.
  • 268108: Fixed an issue with importing an Excel file that contains an empty chart.
  • 268228: Fixed a problem that stops a cell’s font in the designer from being changed.
  • 268264: Fixed an issue where conditional formatting “stop if true” does not work.
  • 268150: Fixed an issue where the rich text dialog doesn’t open when a cell contains special rich text.
  • 268183: Fixed a problem where the designer rich text editor throws an error.
  • 268093: Fixed an issue where importing then exporting an Excel file doesn’t keep the worksheet password.

MR 12.0.3 - December 6, 2018

SpreadJS Maintenance Release 12.0.3 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.3

  • 267766: Fixed an issue that makes the positioning of context menu sub items incorrect.
  • 268025: Fixed a calculation issue with the QUARTILE.EXC function.
  • 267785: Fixed a problem where 100% Stacked charts don’t render correctly when some series are plotted on the secondary axis.
  • 267933: Fixed an issue with data filters shifting down when adding rows.
  • 267662: Fixed a display issue with floating objects.
  • 267663: Fixed a problem where negative numbers do not display the negative sign when the number is set to [=0]””;General.
  • 267149: Fixed an issue that causes empty cells to show no border.
  • 267035: Fixed an export issue where the %formatter is lost when exporting to Excel.
  • 267454: Fixed a problem that does not allow tables to be pasted in the same place.

MR 12.0.2 - November 27, 2018

SpreadJS Maintenance Release 12.0.2 is now available for download in the DevChannel and on the download page.

Issues fixed in 12.0.2

  • 266104: Fixed a problem where the TopRowChanged event isn’t triggered every time on iPad devices.
  • 266825: Fixed an issue with the time validator in Excel not working in SJS.
  • 267401: Fixed a problem that caused the AVERAGE DIV/0 result to be different from Excel.
  • 267455: Fixed a zoom ratio issue in regards to rows/columns.
  • 266254: Fixed a memory leak problem with the combo box celltype.
  • 265694: Fixed a performance issue with the filter dialog opening.
  • 264987: Fixed incorrect RangeChanged event action names.
  • 266100: Fixed an export issue that caused Excel 2013 to crash after importing a file created from SJS with a filter.
  • 266258: Fixed a performance issue with the copyTo and clipboardPaste commands.
  • 266325: Fixed a problem with the scrollbar position not syncing correctly when switching from outline sheet to normal sheet.
  • 266402: Fixed an issue where the dynamicSize of shape is invalid when switching sheets.
  • 266481: Fixed a formatting problem that results in the formatting of “0.000000000000000%” being different than it is in Excel.
  • 266539: Fixed a problem that causes the outline expand status to be incorrect after exporting to Excel.
  • 266568: Fixed an issue where fromJSON can not load old version JSON data.
  • 267048: Fixed a problem that causes the secondary axis of charts to not show when exported to Excel.
  • 267140: Fixed a cell padding issue with the conditional formatting icon.
  • 267369: Fixed a problem where the super/subscript positioning with rich text is not the same as Excel.
  • 267047: Fixed an issue where the data range is still highlighted when deselecting the chart bound to that range.
  • 267387: Fixed a problem that causes a chart to be deleted when changing all the axis groups of the series of that chart.