Export to excel and merge cell

[Paul]

When a report is exported to Excel, it generally works fine. However, here is one problem that I am encountering. In some textbox field, I have CanGrow set as True. Therefore, it the data is longer than the allowed field, it will print to next line which is fine. The problem comes when this is exported to Excel.  If the field is exported Excel, the textbox occupies more than one row(merged row) instead of the whole text should be in one row with longer field.  This prevent the user from sorting properly form Excel.

For example, if it should print, "Hello world, this is me", In textbox it will print as follow.
|Hello World|
|This is me  |

In Excel, it will print,
ROW A  |Hello World|
ROW B  |This is me  |

I would like it to print
ROW A  |Hello World|
              |This is me  |
ROW B

How can this be fixed?

[Chavdar]

Hello Paul,

This can only be achieved with the Table report item as it defines specific rules about how the items should behave when they grow or shrink. Give a try and let me know if you are experiencing any difficulties with this approach.

Regards,
Chavdar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Augusto Cosatti]

Hello.

I have a similar problem but with the height of the exported rows.

The report has a field (CanGrow=true) that displays fine in the viewer, the text is wrapped and displayed on the two lines (see Row_height_ReportViewer.jpg). When I export to Excel, the texte is rendered into 2 merged cells and the problem is that the height of the second row is too small and the text is not fully visible (see Row_height_Excel.jpg).

How can I do to have the same row height.

I have the reporting working fine and I don't want to rewrite it using what you call the Table items.

Thanks for you help
Augusto

[Paul]

I don't think you have any other options. You have to use Table. I modified all my reports to use table but, it is a bit harder to use.

[Steve]

Hi Augusto,

My colleague has already provided a solution for this - the table item, which has specific rules taking care of the height of inner items. This happens because some of the applications use different line spacing while drawing text lines, while we measure using the same line spacing for all formats. This is where the difference comes from - as we have no way of knowing what line spacing would a viewer software (Acrobat, Excel etc.) use. In other words, we've made it look correct for the image rendering (PDF) and excel in particular is drawing the text lines with different line spacing.

Once again, to address this peculiarity, use the Table item.

Kind regards,
Steve
the Telerik team