Hello Everyone,
I am using Telerik Standalone Report designer.
I have following issues regarding export to excel.
1. Padding is not working in Excel.
2. Text color set through HTMLBox is not working in excel.
3. Page layout is not working as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page )
in attached Excel screenshot you can see the Padding issue in right and Left side and also text color issue.
PDF screenshot is perfect.
Please reply if you have any Solutions related this issues.
I am using Telerik Standalone Report designer.
I have following issues regarding export to excel.
1. Padding is not working in Excel.
2. Text color set through HTMLBox is not working in excel.
3. Page layout is not working as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page )
in attached Excel screenshot you can see the Padding issue in right and Left side and also text color issue.
PDF screenshot is perfect.
Please reply if you have any Solutions related this issues.
1 Answer, 1 is accepted
0
Hi Bharat,
The Excel Rendering Extensions tries to reproduce as much of the original report as possible regarding layout and styling. However, there are some limitations.
1. Padding is not working in Excel.
This is correct, the export to Excel does not support padding of the items. You may use TextAlign property instead.
2. Text color set through HTMLBox is not working in excel.
Note that the HtmlTextBox is rendered as plain text with no formatting.
3. Page layout is not working as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page)
The entire report is rendered into a single Excel worksheet and there is no paging when exporting to Excel.
If it is possible you can send us the report, so we can test it locally to see if there is something wrong.
For more information, please, refer to Design Considerations for Excel Rendering article.
Regards,
Neli
Progress Telerik
The Excel Rendering Extensions tries to reproduce as much of the original report as possible regarding layout and styling. However, there are some limitations.
1. Padding is not working in Excel.
This is correct, the export to Excel does not support padding of the items. You may use TextAlign property instead.
2. Text color set through HTMLBox is not working in excel.
Note that the HtmlTextBox is rendered as plain text with no formatting.
3. Page layout is not working as PDF.(I can print report from PDF in one Landscape page but from excel it will expand columns so it will not fit in one Landscape page)
The entire report is rendered into a single Excel worksheet and there is no paging when exporting to Excel.
If it is possible you can send us the report, so we can test it locally to see if there is something wrong.
For more information, please, refer to Design Considerations for Excel Rendering article.
Regards,
Neli
Progress Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items