Hello, I have a report that I am exporting to Excel, and everything looks great except for one thing. When the text in a cell is somewhat lengthy, the last line or two get cut off because the cell is not big enough to fit it all. The report looks fine when rendered and when exporting to PDF, but for some reason Excel is not fitting the text to the cells correctly. Is there something I can do to make the text fit? I am using 2009 Q2 SP1.
7 Answers, 1 is accepted
0
Hello Jason,
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.
Kind regards,
Steve
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.
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.
Kind regards,
Steve
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.
0
Mattias
Top achievements
Rank 1
Rank 1
answered on 29 Jan 2010, 10:07 AM
It looks like the report is generating with the same behaviour even in Q3! :(
Is this something you can't fix, ever?
Do you really need to set a height for the columns in the excel?
Will it just be one line heigh if you don't set the height or why do you set it?
/Mattias
Is this something you can't fix, ever?
Do you really need to set a height for the columns in the excel?
Will it just be one line heigh if you don't set the height or why do you set it?
/Mattias
0
John
Top achievements
Rank 1
Rank 1
answered on 19 Jun 2012, 12:41 PM
Have there been any updates to this issue, or workarounds to help format the excel file when you have cells containing a sufficient amount of text?
In particular, I have a report that contains a single table of textboxes whose rows are sometimes cutting off the last line of text.
Thanks.
In particular, I have a report that contains a single table of textboxes whose rows are sometimes cutting off the last line of text.
Thanks.
0
mandeep bhullar
Top achievements
Rank 1
Rank 1
answered on 15 Apr 2013, 05:09 PM
It is more than 3.5 years since the problem is reported but the problem is not fixed yet with Q2 2013 version. So exporting to excel with multi-line text is not useful. Is there a way you can fix this or will Telerik let it be a "known issue" forever?
0
Hi Mandeep,
As stated in the previous post by my colleague the issue is due the fact that the different media viewers have a slightly different line spacing. While we internally use GDI+ for measuring and rendering the different media viewers have algorithms that slightly differ and those algorithms are not public so we are not able to use them. Instead we are using some heuristic methods for measuring and rendering so that the content fits in all media.
As a conclusion we can say that currently this known issue cannot be fixed since we still do not know how to achieve that task. However you can rest assured that we do our best in order to provide you with an acceptable solution and if one is available it will be implemented as soon as possible.
That being said there exists a workaround that might be applicable in your case and that is to add a new line at the end of each textbox.
All the best,
IvanY
the Telerik team
As stated in the previous post by my colleague the issue is due the fact that the different media viewers have a slightly different line spacing. While we internally use GDI+ for measuring and rendering the different media viewers have algorithms that slightly differ and those algorithms are not public so we are not able to use them. Instead we are using some heuristic methods for measuring and rendering so that the content fits in all media.
As a conclusion we can say that currently this known issue cannot be fixed since we still do not know how to achieve that task. However you can rest assured that we do our best in order to provide you with an acceptable solution and if one is available it will be implemented as soon as possible.
That being said there exists a workaround that might be applicable in your case and that is to add a new line at the end of each textbox.
All the best,
IvanY
the Telerik team
Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.
0
Sandhya
Top achievements
Rank 1
Rank 1
answered on 04 Jan 2016, 11:49 AM
Team,
Is this issue is resolved now. Still after exporting to excel if data size is large then data is splitting and moving to next cell. Please help me ASAP.
0
Hello ,
Please check my post in the Table in Report forum thread.
We will appreciate it if we continue the discussion in one of the threads.
Thank you for your understanding.
Regards,
Stef
Telerik
Please check my post in the Table in Report forum thread.
We will appreciate it if we continue the discussion in one of the threads.
Thank you for your understanding.
Regards,
Stef
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
Jola
commented on 14 Apr 2022, 05:39 AM
Top achievements
Rank 1
Rank 1
When will you finally fix this problem? Up to now we have exports:
1. PDF (correct)
Excel export (buttom cut)
Greetings,
Jola Krawczyk
1. PDF (correct)
Excel export (buttom cut)
Greetings,
Jola Krawczyk
Neli
commented on 18 Apr 2022, 03:02 PM
Telerik team
Hi Jola,
Microsoft Excel does not allow explicitly setting of the line spacing so we cannot reduce its value and the autofit 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 chance 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.
You can find more details in the Table in Report forum thread.