I have a fairly basic tabular report. If I export the report to excel and then try to sort it I get an error that it can't sort because the merged cells are not all sized the same. I don't need or want merged cells in the excel file. How can I get the excel export to not merge cells?
6 Answers, 1 is accepted
0
rh
Top achievements
Rank 1
Rank 1
answered on 07 Nov 2008, 06:04 PM
Telerik, any input on this? It is a really big issue for us. I would have opened a support ticket for this but that appears to be broken so I had to go the forums route. Hopefully I can get a fix soon.
0
Hello rh,
Please excuse us for the delay in our reply. The support system is back up and running, so you can use it for posting there if necessary.
Your current inquiry can be best handled by a table item, which we still lack. So for the time being you can simulate table layout by docking all of your report items to the left. In this way they will stick to the left leaving no empty space between them. They will also stick to the top and bottom edges of the section. Make sure they all have the same height and are properly aligned (here is where the alignment toolbar (shown at the very bottom) comes handy).
Sincerely yours,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Please excuse us for the delay in our reply. The support system is back up and running, so you can use it for posting there if necessary.
Your current inquiry can be best handled by a table item, which we still lack. So for the time being you can simulate table layout by docking all of your report items to the left. In this way they will stick to the left leaving no empty space between them. They will also stick to the top and bottom edges of the section. Make sure they all have the same height and are properly aligned (here is where the alignment toolbar (shown at the very bottom) comes handy).
Sincerely yours,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
rh
Top achievements
Rank 1
Rank 1
answered on 08 Dec 2008, 06:57 PM
I'm not sure I understand your reply. In my report I basically have one row of column headers in the page header and one row of detail fields in the detail section. If I set the dock property of the field in the third column in the detail section then it moves that field all the way to the left essentially making it the first column. So, I can only set the dock to left on one column.
I guess what I need is a way to tell it to dock to the item to the left not dock to the report border on the left.
I guess what I need is a way to tell it to dock to the item to the left not dock to the report border on the left.
0
rh
Top achievements
Rank 1
Rank 1
answered on 08 Dec 2008, 11:30 PM
I played around with the alignment menu a little and did the following:
1) Use the make same size option to make sure each field in the row is the same size
2) Align top to align the tops of all fields in a row
3) Horizontal -> Remove Space to remove all the horizontal spacing between the fields in a row
This seemed to work pretty well except for one lasting issue. If the text in a field is long enough to word wrap then it creates a new row in excel instead of wrapping in the same cell.
1) Use the make same size option to make sure each field in the row is the same size
2) Align top to align the tops of all fields in a row
3) Horizontal -> Remove Space to remove all the horizontal spacing between the fields in a row
This seemed to work pretty well except for one lasting issue. If the text in a field is long enough to word wrap then it creates a new row in excel instead of wrapping in the same cell.
0
Hi rh,
By default docking left would ensure that the textbox item has fully occupied the parent and therefore all other items would automatically dock to the previous one - I've just verified this is still the case in the latest official version.
Also I was not able to reproduce the last problem you describe. When TextWrap=true (default), then it would wrap in the same cell in excel (screenshot is attached).
Greetings,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
By default docking left would ensure that the textbox item has fully occupied the parent and therefore all other items would automatically dock to the previous one - I've just verified this is still the case in the latest official version.
Also I was not able to reproduce the last problem you describe. When TextWrap=true (default), then it would wrap in the same cell in excel (screenshot is attached).
Greetings,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Gersh
Top achievements
Rank 2
Rank 2
answered on 02 Jun 2011, 04:53 PM
Thank you this helped/