Spreadsheet problem with loading large JSON

5 posts, 0 answers
  1. Dominik
    Dominik avatar
    4 posts
    Member since:
    Mar 2016

    Posted 18 Mar Link to this post

    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.

  2. T. Tsonev
    Admin
    T. Tsonev avatar
    2772 posts

    Posted 22 Mar Link to this post

    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!
     
  3. Kendo UI is VS 2017 Ready
  4. Dominik
    Dominik avatar
    4 posts
    Member since:
    Mar 2016

    Posted 22 Mar in reply to T. Tsonev Link to this post

    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
  5. Dominik
    Dominik avatar
    4 posts
    Member since:
    Mar 2016

    Posted 22 Mar Link to this post

    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

  6. Mihai
    Admin
    Mihai avatar
    153 posts

    Posted 23 Mar Link to this post

    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!
     
Back to Top
Kendo UI is VS 2017 Ready