SpreadJS v12 Maintenance Releases

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.