PivotGrid timeout on xlsx export, too much data?

PivotGrid timeout on xlsx export, too much data?

Posted by: jcmata.dev on 5 December 2018, 5:15 pm EST

• 

  jcmata.dev

  • Post Options:
  • Link
    Copy

  Posted 5 December 2018, 5:15 pm EST - Updated 3 October 2022, 8:16 pm EST

  Hi,

  I’m creating a PoC for the company to see if we purchase a Wijmo Licence.

  I’m currently using wijmo-5.20183.550, now then, after populating the PivotGrid, while trying to export the data into a xlsx file, I get Chrome’s Aw, Snap! Something went wrong while displaying this webpage… funny thing is that while using wijmo-5.20183.500 I did manage to export the same data successfully.

  So a couple of questions here:

  • Is there is any limitation on the amount of data that Wijmo export feature can handle?
    
    NOTE: I have already tried JSZip 2.5 and 3.1.5 with no success.
  • Why do I get numeric values left-aligned if I’m using format n2?

  Please find attached both, the image with the formatting issue and the project itself.
  
  I tried to attach the Json with the data I display in the grid but it’s bigger than 5mb even after compression, so I would really appreciate if you guys could provide an email to send it you guys.

  ADAM.Reporting.Web.zip

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 7 December 2018, 2:41 am EST

  Hi,

  Sorry for the late response on this.

  We have created a case for this thread on our private support website and shared the required details there, please refer to the case here:
  
  http://supportone.componentone.com/casedetail/356691.

  Why do I get numeric values left-aligned if I’m using format n2?
  
  <<<<<<<<<<<<<<<
  
  The issue is arising because of the version of wijmo.css file referenced in the project. Stylesheet(wijmo.css) is of version 5.20182.500 whereas js files are of version 5.20183.550. Please update the css file to correct version.

  ~Sharad