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.
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
Thank you for reaching out to us.
We did not manage to reproduce this issue on our side.
Please provide us with additional details:
customizeCellhandler if it is used in your case.
We are looking forward to hearing from you.
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.
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?
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:
expandAllDatais 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).
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.