🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Export issue in EXCEL

Answered
Ravi asked on April 15, 2021

Hey guys,
             We are facing one issue while we export as EXCEL when we have huge data around 4LAKHS.
We are getting “All” instead of some string values. Please refer to the screenshot.
 
Reproduce steps:
 1. Load huge data around 4LAKHS.
 2. Make sure the last rows are collapsed by default.
 3. Do Export as EXCEL
 
Note: Currently we are using the 2.8.28 version.
 
Thanks and regards
Ravi A

Attachments:
flexmonsterv1.png

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 16, 2021

Hello,
 
Thank you for reaching out to us.
 
We did not manage to reproduce this issue on our side.
Please provide us with additional details:

  1. The used report with all expands specified.
  2. The used dataset (dummy data can be used if needed).
  3. The customizeCell handler if it is used in your case.

 
We are looking forward to hearing from you.
 
Regards,
Illia

Public
Ravi May 14, 2021

Hi Illia Yatsyshyn,
We are not able to reproduce the issue because we have lost the data set we used. We have created a similar data set that has this kind of issue. Please open the jsfiddle link below.
https://jsfiddle.net/roopeshkottala/bn5v6kof/7/
 
1> Why we are getting ” Dataset is too large. Some fields cannot be expanded. Please narrow down the dataset” Popup. We have loaded only 124543 records, Some time we load 1 million records and we do not get this kind of popup.
 
2> Is there any event that we can listen to when this popup opens.
 
3> There is an unresponsive page issue if you open this in a low ram machine(<8GB). But we do not face this unresponsive issue for other data set in the low ram machine.
 
4> If we scroll down in the flex monster we will see some rows have empty columns. If this is a bug can you please fix it?
 
Thanks!
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 14, 2021

Hello,
 
Thank you for your feedback.
 
Still, we did not manage to reproduce the issue with unexpected content in the exported Excel file using the provided JSFiddle.
 
Concerning the rest of the questions:

  1. The mentioned alert appears when the client’s machine is unable to perform all the expands defined in the report. This error depends on the number of expands rather than the size of the dataset. This is why larger data sets may not produce this error.
  2. Currently, it is not possible to track when the alert is displayed.
  3. Please note that expandAllData is a heavy recursive operation that takes a lot of memory and processing power. It is likely to freeze the majority of average computers when expanding datasets of this size (hundreds of thousands of records).
    We suggest leaving the members collapsed by default and providing the user with a possibility to expand only the required ones.
  4. These empty columns are simply collapsed members that were not expanded because of the “Dataset is too large” error. You can expand them manually by clicking on the corresponding icon placed in the cell.

 
Our current recommendation would be to remove the "expandAll": true property from the report and not trying to use the expandAllData API call when a dataset is that large.
 
Please let us know if it helps.

Please login or Register to Submit Answer