This is a migrated thread and some comments may be shown as answers.

Export to EXCEL extra BLANK rows

4 Answers 420 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 17 Feb 2009, 07:32 PM
I followed the wizzard and made no changes to the report layout besides what the wizzard did and when I export to Excel there are two extra blank rows between every row of data.  What is causing this?

The report has a labels group header and detail...

4 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 18 Feb 2009, 03:32 PM
Hello Mike,

We leave some space on top and on bottom of the items by design. You can easily remove it by zooming and making sure all items "fit" exactly to the details' section top and then squeeze its bottom to the items' bottoms.
As you know we are currently working on crosstab/table item and once it is ready, we would modify the report wizard to use table directly to avoid such inconsistencies.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Mark
Top achievements
Rank 1
answered on 07 Oct 2014, 11:20 PM
I have zoomed in to 400% and have tightened up my fields in the Details section to where it looks as tight as it can be and I'm still getting extra rows in Excel when I export. Is there another trick involved?
0
Mark
Top achievements
Rank 1
answered on 07 Oct 2014, 11:31 PM
Also, there are many, many columns separating the data fields.  How do I eliminate those?
0
Stef
Telerik team
answered on 09 Oct 2014, 08:16 AM
Hello Mark,

Please check the suggestion in the Design Considerations for Excel Rendering article under Merging Cells.


If yuo need further help, feel free to open a support ticket and send us details about the used Telerik Reporting versions, the report code files, including test data to run them.

Regards,
Stef
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
Mike
Top achievements
Rank 1
Answers by
Steve
Telerik team
Mark
Top achievements
Rank 1
Stef
Telerik team
Share this question
or