This is a migrated thread and some comments may be shown as answers.

Spreadsheet problem with loading large JSON

4 Answers 177 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Dominik
Top achievements
Rank 1
Dominik asked on 18 Mar 2016, 03:44 PM
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

Sort by
0
T. Tsonev
Telerik team
answered on 22 Mar 2016, 01:38 PM
Hi,

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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Dominik
Top achievements
Rank 1
answered on 22 Mar 2016, 01:48 PM
I am happy to say that we resolved the problem. There was a problem with a formula that was too long, the formula was like:
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
0
Dominik
Top achievements
Rank 1
answered on 22 Mar 2016, 02:58 PM

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

0
Mihai
Telerik team
answered on 23 Mar 2016, 08:00 AM
Hi Dominik,

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
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Spreadsheet
Asked by
Dominik
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Dominik
Top achievements
Rank 1
Mihai
Telerik team
Share this question
or