Hello,
I am using Telerik Reporting and have a report that exports perfectly to PDF. However, when exporting to Excel, the formatting is incorrect, and some data appears to be missing (for exmaple POI which is location name under each time).
I would truly appreciate any guidance on how to resolve this.
1 Answer, 1 is accepted
Hi Alice,
The Excel rendering has certain limitations listed in the article Design Considerations for the Excel Rendering.
There are also known problems logged to our public feedback portal, for example, Nested Tables with Groups with PageBreak may cause incorrect number and content of the generated Excel worksheets.
I noticed you use Arabic and Latin symbols. We have met issues due to their interactions as well.
Which fonts do you use?
Does the issue occur on .NET or .NET Framework environment? Do you render with the GDI graphics engine or with Skia?
We need to reproduce the issue to investigate it. If you need further assistance, please consider sending a runnable report, including sample data for local testing.
Regards,
Todor
Progress Telerik
Enjoyed our products? Share your experience on G2 and receive a $25 Amazon gift card for a limited time!
Rank 1
Hello Todor,
Thank you for your detailed response and for looking into this issue.
We are using Farsi as the language, and the font in use is Microsoft Sans Serif. The environment is .NET Core, but I am unsure about the graphics engine being used, it might be GDI graphics engine.
Interestingly, the report was working correctly before, but after adding a new column, the issue started appearing.
I appreciate your help and any guidance you can provide on this matter.
Best regards,
Hello Alice,
Thank you for the clarification.
Which Reporting version do you use? Do you use .NET Core 3.1 or an older one?
Do you render the reports on Windows or Linux? In the former case, you most probably use the GDI engine, which is the default for Windows.
Can you send us a sample runnable report replicating the problem for local investigation?