Forums Home / Spread / SpreadJS
Posted by: sgandham on 12 May 2020, 7:34 am EST
sgandham
Posted 12 May 2020, 7:34 am EST
Hi,
After we clear the sheets using ```
spread.clearSheets();
we are unable to copy the cells.
The following textarea node which is added during initialisation is removed and not added back.
a.prototype.ska = function(a) {
//this.tc is null?
n(this.tc) ? this.KM.innerHTML = a : this.qka.value = a
}
[img]https://gccontent.blob.core.windows.net/forum-uploads/file-2d8769fe-d66a-40b6-80b6-54b5f92f31b4.png[/img]
sharad.tomer
Posted 14 May 2020, 1:28 am EST
Hi,
We are sorry but we are unable to replicate the issue at our end. Please have a look at the following sample and let us know if we are missing something in order to replicate the issue: https://codesandbox.io/s/long-http-hgi8z?file=/src/index.js
You may share a sample that replicates the issue for us to investigate.
Regards
sgandham
Posted 14 May 2020, 2:43 am EST
Hi, Thanks for the demo setup.
We are using 12.2.3, and there seems to be a difference in the following function.
If you can confirm if this is a bug in the version we are using, we will go ahead and make necessary changes.
In current version
a.prototype.no = function(b) {
var c, d, f, g = this;
g.Js !== !0 && (e.En.Sn(g),
g.isEditing && g.isEditing() && g.Yoa(),
a.ao(g, "dispose", {
clearCache: b,
isSpreadDestroy: !0
}),
c = g.Xs,
c && (d = c.parentNode,
d && d.removeChild(c),
g.Xs = I),
g.$s(),
g.ITa && g.ITa.no(b),
b !== !1 && (g.Js = !0,
f = g.at,
f && f.no(),
g.parent = I,
g.ITa = I,
g.ss && (g.ss.no(),
g.ss = I),
g.bt && (g.bt.no(),
g.bt = I),
e.Vl.Wl(g) && e.Vl.Zl(I, !0),
g.uu && (g.uu = I),
g.Wr = I,
g.Zr = I))
}
In 12.2.3
a.prototype.no = function(b) {
var c, d, f, g = this;
g.Js !== !0 && (e.En.Sn(g),
g.isEditing && g.isEditing() && g.Yoa(),
a.ao(g, "dispose", b),
c = g.Xs,
c && (d = c.parentNode,
d && d.removeChild(c),
g.Xs = E),
g.$s(),
b !== !1 && (g.Js = !0,
f = g.at,
f && f.no(),
g.parent = E,
g.ITa = E,
g.ss = E,
g.bt && (g.bt.no(),
g.bt = E),
e.Vl.Wl(g) && e.Vl.Zl(E, !0),
g.uu && (g.uu.no(),
g.uu = E)))
}
Thank you
sgandham
Posted 14 May 2020, 2:44 am EST
Check the last three lines. ```
g.uu.no()
sharad.tomer
Posted 15 May 2020, 3:55 am EST
We are further investigating this issue and will provide you an update soon. (Internal tracking id: SJS-4377)
sharad.tomer
Posted 18 May 2020, 2:43 am EST
Hi,
We are able to reproduce the issue using the 12.2.3 build but it is fixed in 12.2.4 build. So we would recommend you to update to the latest version of V12 which is 12.2.5, Please update to the latest version and let us know if you face any issues.
Regards
sgandham
Posted 18 May 2020, 2:59 am EST
Thank you 
sgandham
Posted 19 May 2020, 12:44 am EST
Can you please share the change-log from 12.2.3 to 12.2.5
sharad.tomer
Posted 19 May 2020, 3:44 am EST
We have forwarded your request to the concerned team(Internal tracking id: SJS-4390). We will let you know as we get an update from the team.
sgandham
Posted 19 May 2020, 7:25 am EST
Can we use the key from 12.2.3 in 12.2.5.
If no, will the code change we did in 12.2.3 work.
sharad.tomer
Posted 20 May 2020, 2:49 am EST
Yes, the distribution key for version 12.2.3 would work for version 12.2.5 too.
sgandham
Posted 20 May 2020, 3:07 am EST
Thank you.
Any update on the change-log?
sharad.tomer
Posted 21 May 2020, 12:52 am EST
We are sorry but we do not have an update regarding the changelog yet, I’ll notify you as soon as I get an update
sgandham
Posted 21 May 2020, 4:05 am EST
Is there an alternate method for spread.clearSheets(); with similar functionality.
sharad.tomer
Posted 22 May 2020, 7:50 am EST
We are sorry but we couldn’t find any workarounds. Since the issue is already fixed in the next build, we would still recommend you to update to 12.2.5. Please let us know if there is any particular reason why you need to stick to v12.2.3?
Also, regarding the changelog, please refer to the following list:
12.2.4:
1463: goToRange not defined
1453: Cell reference with absolute referenced not displayed 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 does not work 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()
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
