Table in Report

[Eric Schuler]

Hi,

I have 2 issues when I am using Telerik Report and export to Excel.
(Everything is good in Report viewer, but after it's exported to excel, there are some problems.)

1, After the report is exported to Excel, there is no grid lines in excel, the whole back ground is white, I did not set any border in report, how can I turn on the default grid line in Excel, not make them be white background. (Our report is not full of table, so I did not set any border in my report, it will looks strange in exported Excel, parts of the report has grid line, and others don't. So I think the default Excel grid line will solve my problem, how can I get it?)

2, In the cell of table, I set it to CanGrow=True, CanShrink=False, Multiline=True, TextWrap=True, it works fine in Report Viewer, The long text string will be turned into another line. But after export to excel, the row height is not enough, it will make half of text be cut off in second line, the user have to manually adjust the hight of row to see the whole text. I do see some of threads discussed this issue, it's caused by line spacing in Excel, I want to know is there any alternative solution I can use to solve this problem, because it looks really not good.

I appreciated any help from you.
Thank you very much.

[Chavdar]

Hi Eric Schuler,

Currently there is no way to make the Excel rendering extension show the gridlines for the rendered reports. We have logged your request and will implement a solution for the next release (a service pack or an internal build).

As for your second issue - it is hard to achieve the desired effect. Microsoft Excel does not allow explicitly setting of the line spacing so we cannot reduce its value and the auto fit function of the rows works only when there are no merged rows and the height of the row is not explicitly set. This does not give us any chances except to change the measuring of the TextBoxes only for Excel rendering which however, will lead to a different report layout than designed (see Design Considerations for Excel Rendering) and may cause undesired effects.

Kind regards,
Chavdar
the Telerik team

[Chris Mitchell]

Much as I love Telerik's controls, I just wanted to chime in with an "OUCH" here on the first issue. I am doing report exports for a client and with Excel having no gridlines displayed, the output looks very strange.

There is probably some kind of workaround by directly manipulating the Excel file but still, this is something that was very unexpected. I'm not looking forward to explaining this to my client (particularly when a previous vendor's component had no such issue)..

[Chavdar]

Hello Chris Mitchell,

As of Q1 2011 SP1 (version 5.0.11.510) you can control the visibility of the Excel gridlines with a device information setting. Please check the Configuring Telerik Reporting and Excel Device Information Settings help articles in order to see how to configure it.

Hope this helps.

Kind regards,
Chavdar
the Telerik team

[Chris Mitchell]

[EDIT #2]

Sorry to keep spamming you with forum edits. I figured out my problem (wrong extension name) and now have the global Device Information Setting working in web.config

One last question. This seems to work for every cell EXCEPT those populated by my report. Is there a corresponding setting that I need to make to the Report itself?

[Steve]

Hi Chris,

This can happen if you have BackGroundColor applied to the report or respective sections. Resetting this property should result in the view you expect.

Kind regards,
Steve
the Telerik team

[Narayana]

Steve/Chavdar,

Do you have sample file with excel device setting in config file. It will be good if you share that sample for user community.

[Steve]

Hi Narayana,

Such information is already available in the Extensions Element help article, where at the end there is a sample markup for the PDF rendering extension, but you can make the necessary changes and apply device settings for the Excel rendering extension as per the Excel Device Information Settings help article.

All the best,
Steve
the Telerik team

[Roland]

Hi Steve

I would like to ask about the second issue Eric mentioned, namely that row heights are not adjusted when text it wrapped on multiple lines.

Any progress/workaround for this one?

Roland

[Steve]

Hi Roland,

As my colleague Chavdar explained in his post from 18-Mar-2011, there is little we can do, as we cannot set custom line spacing for the Excel file. Still we have not given up on researching for a feasible way to address this issue.
For the time being there are a few workarounds available that you can use depending on your setup and goals. One of them is to select all the affected lines in the already exported document (or the whole document using Ctrl+A) and auto adjust their height. The other workaround is to design your textboxes in a manner so that they do not grow at runtime.

Kind regards,
Steve
the Telerik team

[Sandhya]

Is the second issue get resolved.

The long text string will be turned into another line. But after export to excel, the row height is not enough, it will make half of text be cut off in second line, the user have to manually adjust the hight of row to see the whole text.

Please help us

[Stef]

Hello Sandhya,

Excel AutoFit is applied on the cells content and the size of cells is not configured by the reporting engine.
Please check the Design Considerations for Excel Rendering help article (Report Item Layout, Report Items and Excel Limitations sections).


Regards,
Stef
Telerik