asked on September 15, 2022
Hi Team,
Export image is not taking entire data from Pivot table, it is just taken what ever visible on screen.
Thanks,
Ravi
⋅ September 15, 2022
Hi, Ravi!
Thank you for your question.
Please note that this behavior is expected when exporting the grid to an image. This approach allows keeping the data on exported images readable if the table has a lot of rows or columns. We recommend using other export options, for example, "Print", "To HTML" and "To PDF" in order to export all the data with all the formatting applied.
Feel free to contact us if further questions arise.
Best Regards,
Maksym
⋅ September 16, 2022
Hi Maksym,
Thank you for Prompt response.
I tried to export "To PDF" but it does not look good. Able to print all data but it spilt into multiple tables and each table get 4 to 5 columns.. Print to HTML is looks good.
Find the attachment, all data should come in single table but it spilt into 2 tables
Thanks,
Ravi
⋅ September 16, 2022
Hi, Ravi!
Thank you for your feedback.
We are glad to hear that exporting to HTML worked for you.
The purpose of dividing the table with PDF export is to make the data readable if there are too many rows and columns. In some cases, you can avoid splitting the exported PDF table by switching the page orientation to "Landscape". In this case, the table will be exported horizontally, which allows fitting the entire width of the table. However, at some point, the "Landscape" PDF export table still will be split. Please see the attached PDFs to see the results of export with different page orientations.
Also, you can utilize the exportTo API call to avoid the page split by exporting to PDF by setting the params.pageFormat property as A1, A2, or A3, which would make the exported sheet bigger. Please see the example of its usage, where export to PDF is changed to print A2 page: https://jsfiddle.net/flexmonster/h2qmcr8u/.
You are welcome to write us if more questions arise.
Best Regards,
Maksym
⋅ September 19, 2022
Hi Maksym,
I tried with landscape mode but still it split into multiple tables.
I am getting attached error When I try to use pageFormat.
I am using flexmonster version as 2.9.27.
Do we need to upgrade to get exportTo API?
Thanks,
Ravi
⋅ September 20, 2022
Hello, Ravi,
Thank you for reporting this issue.
We are happy to inform you that the pageFormat property was added to the ExportOptions interface.
This is included in the 2.9.34 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-34/
You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix works fine for you.
Best regards,
Maksym
⋅ September 27, 2022
Hello, Ravi,
Hope you are doing well.
Our team is wondering if the fix worked for you. Did the pageFormat property help you to avoid splitting the exported table?
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ October 5, 2022
Hello, Ravi,
We would like to know if you have had time to check the fix of the pageFormat property.
If so, was it helpful for achieving your initial goal?
Best Regards,
Maksym
