angular.js:11358 RangeError: Maximum call stack size exceeded at kendo.all.min.js:78 at Object.a [as compile] (kendo.all.min.js:78) at e.support.browser.msie.e.support.browser.version.e.Observable.extend._compileFormula (kendo.all.min.js:77) at .<anonymous> (kendo.all.min.js:77) at e.support.browser.msie.e.support.browser.version.e.Observable.extend.batch (kendo.all.min.js:77) at e.support.browser.msie.e.support.browser.version.e.Observable.extend.fromJSON (kendo.all.min.js:77) at e.support.browser.msie.e.support.browser.version.e.Observable.extend.fromJSON (kendo.all.min.js:78) at new e.support.browser.msie.e.support.browser.version.e.Observable.extend.init (kendo.all.min.js:78) at new e.support.browser.msie.e.support.browser.version.e.ui.Widget.extend.init (kendo.all.min.js:85) at HTMLDivElement.<anonymous> (kendo.all.min.js:26)
I am trying to load about 29 thousand rows of data into the kendo spreadsheet and I get the above error. What I am doing is converting data from a ExcelPackage to a Telerik.Web.Spreadsheet workbook on the back-end. Then I convert the workbook via the ToJson method, send that data to the front-end, parse the received string data to a JSON and then load that JSON into the spreadsheet directly as a object or via the spreadsheet.fromJSON(data) method.
It works for less data, but doesn't for this. Also I can have hundreds of thousands of rows with no problems but with data it's another story. Can you tell me if there is some better way to do this, or how to work around this error.
Thank you in advance.
4 Answers, 1 is accepted
Can we have a look at a sample file that reproduces this issue? It might be not only the size, but also specific formulas that are breaking the import.
Also, have you tried loading the file directly on the client?
Regards,
T. Tsonev
Telerik
Rank 1
A1 + E2 + B3 +.... First I put it into the SUM function, but then the Workbook.Load from Excel package method placed the formula inside the value field as a string. I manually reverted it back to the formula field. If you have some input on that, it would be appreciated.
Regards
Rank 1
Just for the sake of helping someone else or you with this, here is an example of the formula that was the problem:
F21+F36+F46+F70+F253+F268+F284+F297+F480+F527+F569+F579+F638+F652+F674+F711+F765+F776+F790+F931+F1129+F1191+F1251+F1473+F1618+F1629+F1760+F1779+F1794+F1812+F1841+F1856+F1869+F1879+F1932+F1954+F1972+F1990+F2021+F2068+F2078+F2090+F2132+F2163+F2175+F2185+F2253+F2263+F2321+F2338+F2350+F2363+F2377+F2387+F2397+F2407+F2418+F2485+F2496+F2510+F2520+F2543+F2553+F2573+F2585+F2596+F2606+F2626+F2640+F2653+F2733+F2743+F2767+F2782+F2855+F2936+F2946+F2967+F2977+F2994+F3005+F3017+F3226+F3256+F3281+F3299+F3309+F3359+F3368+F3378+F3675+F3687+F3733+F3747+F3760+F3769+F3820+F3838+F3919+F3953+F3972+F3988+F3999+F4011+F4022+F4056+F4076+F4090+F4103+F4121+F4137+F4157+F4171+F4209+F4291+F4311+F4322+F4397+F4418+F4437+F4458+F4471+F4774+F4944+F5049+F5079+F5165+F5181+F5194+F5204+F5258+F5267+F5285+F5299+F5364+F5395+F5517+F5563+F5572+F5608+F5617+F5634+F5653+F5665+F5729+F5763+F5901+F5934+F5945+F5956+F6016+F6043+F6068+F6080+F6092+F6232+F6277+F6333+F6347+F6364+F6382+F6405+F6418+F6556+F6589+F6613+F6646+F6658+F6681+F6693+F6710+F6855+F6907+F6918+F6927+F6941+F6982+F6994+F7008+F7042+F7051+F7068+F7083+F7117+F7128+F7138+F7160+F7194+F7209+F7361+F7392+F7420+F7460+F7470+F7485+F7543+F7558+F7577+F7595+F7621+F7748+F7785+F7850+F7884+F7907+F7933+F7953+F7992+F8003+F8032+F8042+F8052+F8117+F8142+F8156+F8169+F8210+F8257+F8271+F8331+F8348+F8363+F8664+F8675+F8685+F8717+F8727+F8737+F8747+F8757+F8770+F8794+F8804+F8815+F8856+F8881+F8903+F8928+F8947+F9122+F9137+F9147+F9195+F9205+F9248+F9290+F9337+F9423+F9477+F9501+F9524+F9677+F9707+F9729+F9846+F9862+F9880+F9927+F9986+F10002+F10070+F10083+F10107+F10134+F10147+F10159+F10182+F10198+F10318+F10346+F10417+F10511+F10530+F10555+F10568+F10578+F10665+F10675+F10687+F10714+F10773+F10846+F10858+F10966+F10977+F10992+F11003+F11094+F11173+F11330+F11386+F11468+F11571+F11778+F11794+F11808+F11918+F11974+F12038+F12185+F12315+F12370+F12421+F12434+F12523+F12585+F12753+F12793+F12808+F12826+F12908+F12982+F13095+F13105+F13183+F13213+F13222+F13257+F13274+F13403+F13473+F13657+F13724+F13742+F13889+F13924+F14136+F14159+F14187+F14206+F14221+F14241+F14428+F14444+F14460+F14475+F14492+F14504+F14514+F14561+F14622+F14635+F14668+F14688+F14901+F15403+F15414+F17170+F18394+F18555+F18723+F18859+F18990+F19098+F19327+F19677+F19740+F19901+F20146+F20160+F21185+F21739+F21810+F21842+F21913+F21955+F22054+F22078+F22087+F22096+F22126+F22167+F22179+F22189+F22198+F22209+F22230+F22242+F22255+F22265+F22274+F22283+F22292+F22368+F22377+F22426+F22436+F22445+F22470
Thanks for the report! I've logged an internal ticket to track this issue. For now it's best to use SUM in such situations.
Regards,
Mihai
Telerik