SpreadJS v11 Maintenance Releases

SpreadJS Maintenance Release 11.2.6 - September 27, 2018

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

Issues fixed in 11.2.6

264236: Fixed an issue where drag-swapping columns in a page causes a loss of data binding.
264538: Fixed a problem with the LOOKUP formula calculation.
264328: Fixed an issue with exported Excel files not following the Open XML specification.
263663: Fixed performance degradation issues with applying styles on cells from V 11.0.6 to V 11.2.4.
263964: Fixed a problem where backColor is null after importing.
263997: Fixed an issue where adding a chart crashes when selecting a column.
260624: Fixed a problem where the full DataRange area is not highlighted when selecting a Bubble chart.
261840: Fixed an issue where the FIXED formula calculates incorrectly.
264253: Fixed a problem where the “Fill No Color” conditional formatting option doesn’t work after saving.
264259: Fixed differences between Spread Designer and Excel style combination.
264411: Fixed a problem where an exception is thrown when opening an Excel file in SpreadJS.
264501: Fixed issues where the Date column in a data-bound table doesn’t export to Excel properly.
264553: Fixed a problem where an Excel file doesn’t load properly in Spread.

SpreadJS Maintenance Release 11.2.5 - September 13, 2018

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

Issues fixed in 11.2.5

261841: Fixed a bug with the “COUNTBLANK” formula.
262583: Fixed performance issues with the “SUMIFS” formula.
262253: Fixed performance of worksheet operations.
261559: Fixed an issue with importing a combination chart from Excel.
258595: Fixed a zooming issue.
262719: Fixed a problem with the “RANK” formula.
263024: Fixed an issue with the “COUNTIF” formula.
263441: Fixed a problem with Excel values changing when importing.
262888: Fixed Excel importing issues.
263870: Fixed issues preventing the sheet object initializing in the workbookInitialized event.

SpreadJS Maintenance Release 11.2.4 - August 29, 2018

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

Issues fixed in 11.2.4

261841: Fixed a bug with the “COUNTBLANK” formula.
262583: Fixed performance issues with the “SUMIFS” formula.
262253: Fixed performance of worksheet operations.
261559: Fixed an issue with importing a combination chart from Excel.
258595: Fixed a zooming issue.
262719: Fixed a problem with the “RANK” formula.
263024: Fixed an issue with the “COUNTIF” formula.
263441: Fixed a problem with Excel values changing when importing.
262888: Fixed Excel importing issues.
263870: Fixed issues preventing the sheet object initializing in the workbookInitialized event.

SpreadJS Maintenance Release 11.2.3 - August 9, 2018

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

Issues fixed in 11.2.3

261277: Fixed a bug where pressing the backspace key with a floating object selected makes the active cell editable.
261743: Fixed an issue where importing picture borders is different from Excel.
261672: Fixed a bug where the “Filter by Color” UI doesn’t show correctly with JP culture.
261784: Fixed an issue where clicking “Check all” or “Uncheck all” will cause the browser to stop responding.
261622: Fixed a bug that makes conditional formatting borders visible after exporting.
261559: Fixed an issue where SpreadJS is unable to import Combo Charts from Excel.
261560: Fixed a bug that makes Excel files unable to load when namespaces are defined in XML nodes.
261429: Fixed an issue where importing an Excel file looks different in SpreadJS.

SpreadJS Maintenance Release 11.1.4 - June 28, 2018

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

Issues fixed in 11.1.4

259287: Fixed an issue where the result of the “h:mm:ss” format is incorrect after a Chrome update.
259501: Fixed a problem where a cell can’t be selected when editing a cross-sheet formula when allowDragMerge is true.
259606: Fixed an issue where certain Excel files are exported without formulas and the date is not displayed correctly.
259515: Fixed a problem where the IRR function does not calculate correctly.
252262: Fixed an issue where the XIRR function results in #NUM!

SpreadJS Maintenance Release 11.1.3 - June 19, 2018

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

Issues fixed in 11.1.3

259297: Fixed a problem with table binding not working when the sheet is not active.
258254: Fixed an issue where word wrap does not work correctly after the cell padding is set.
259122: Fixed a problem where shared formulas don’t import correctly.
259268: Fixed an issue where cell spans have errors after inserting rows.
259469: Fixed a problem where the browser crashes when importing Excel file that contain the CDATA formula.

SpreadJS Maintenance Release 11.1.2 - June 5, 2018

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

Issues fixed in 11.1.2

258806: Fixed an issue with exporting to PDF resulting in incorrect code on macOS in some cases.
258595: Fixed a problem with zooming.
258593: Fixed an issue with some spread options not working when initializing.
258360: Fixed a problem with the qualityFactor causing print layout to be incorrect.
258499: Fixed an issue where copying numbers does not work correctly for some imported Excel files.
258357: Fixed some problem with calculating formulas.
2'61426': Fixed an issue with the AVERAGEIF function when the sum range includes a blank cell.

SpreadJS Maintenance Release 11.1.1 - May 17, 2018

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

Issues fixed in 11.1.1

256943: Fixed calculation precision issues.
254207: Fixed a problem with the SUM function calculation.
256249: Fixed an issue with ranges not open format cells dialog in the designer when clicked.
256290: Fixed a problem with the formula bar not working correctly when focused using tab.
258080: Fixed an issue with exporting to PDF.
251322: Fixed a formula calculation problem.
257630: Fixed an issue where certain calculation engine results were not consistent with Excel.
257491: Fixed a problem with the canvas.arc position being incorrect when exported to PDF.
257471: Fixed an issue with specific input not being correctly converted to scientific notation.
257169: Fixed a problem with formulas where the ZA column would change to AA.
254409: Fixed an issue where deleting a row does not work properly after filtering.

SpreadJS Maintenance Release 11.0.5 - March 15, 2018

Available today in the SpreadJS DevChannel: Maintenance Release 11.0.5.

Issues fixed in 11.0.5:

254754: Fixed copy/paste performance issues.
254912: Fixed an issue where the line width is different when copying from SpreadJS and pasting into Excel.
254783: Fixed a problem after importing SSJSON where deleting rows/columns causes SpreadJS crashes.
254960: Fixed an issue with DateTime formatting not importing correctly.
255202: Fixed a problem where the DEL keypress doesn't work in the Edge browser.
253512: Fixed an issue where the DATEDIF function result is different from Excel.

The Spread DevChannel is a great way to get Maintenance Releasees and preview new features. To gain access to the DevChannel, register or login to your GrapeCity.com account.

SpreadJS Maintenance Release 11.0.4 - February 16, 2018

Available today in the SpreadJS DevChannel: Maintenance Release 11.0.4.

Issues fixed in 11.0.4:

253918: Fixed an issue where floating objects that are set in the first column and row in the sheet are positioned incorrectly.
254327: Fixed a problem where the destroy method causes an error in the Spread JavaScript file.
253866: Fixed an issue where floating objects could not be deleted on Mac computers.
254403: Fixed a problem where vertical scroll does not work after importing an Excel file.
252486: Fixed an issue where function results for LENB, LEFTB, and RIGHTB were different from Excel.
252401: Fixed a problem where pasting a copied wrapped cell sometimes behaves differently from Excel.

The Spread DevChannel is a great way to get Maintenance Releasees and preview new features. To gain access to the DevChannel, register or login to your GrapeCity.com account.

SpreadJS Maintenance Release 11.0.3 - January 21, 2018

The Spread DevChannel is a great way to get Maintenance Releasees and preview new features. We've just released several previews. To gain access to the DevChannel, register or login to your GrapeCity.com account.

Issues fixed in 11.0.3:

253226: Fixed an issue where importing an Excel file crashes with specific formulas in cells.
252779: Fixed a problem where the formula "=VALUE("-1")" returns "#VALUE".
253125: Fixed a problem with formulas using Chinese input method.
253128: Fixed an issue with formula input.
253359: Fixed an issue where cross sheet references make pages blank in Firefox.
253452: Fixed a problem where the touch toolbar or gripper isn't showing when cells are touched in Microsoft Edge.
252933: Fixed a problem where the cursor wouldn't move using the left/right arrow keys in an editable combobox.
253427: Fixed an issue where some formatting result is different from V9.
252414: Fixed a problem where the LOOKUP function result is different from Excel.
252461: Fixed an issue where the LOOKUP function does not work well for the text field.
229410: Fixed an issue with the TEXT function.
253423: Fixed a problem where the paste result is sometimes wrong when allowCopyPasteExcelStyle is false.
253383: Fixed an issue where setting data and copying content causes allowExtendPasteRange to not work.
253022: Fixed a problem where autosize doesn't calculate correctly for certain characters.