Save to Excel (data only) inserting empty columns

Stimulsoft Reports.WPF discussion
Post Reply
sandynith
Posts: 64
Joined: Thu Dec 12, 2013 4:03 am

Save to Excel (data only) inserting empty columns

Post by sandynith »

If I try to save a report to 'Microsoft Excel' with 'Export Data only' option then the saved report has empty or blank columns in it.

Steps to reproduce:
+ Open the 'Simple List' report from the 'Demo for WPF' reports.
+ Click Save - Microsoft Excel file - Under settings select 'Export Data only' option - click ok and open the saved report.
+ You will notice that the saved report has two empty columns.

I have seen this problem in our reports as well. When we save to excel we just export the data only.

We haven't seen this problem in 2013 releases (or in early 2014 release). Please have a look and advice me on this.

Thanks,
Sandeep
Attachments
How to save to Excel with Export data only option
How to save to Excel with Export data only option
Save to Excel settings.JPG (193.49 KiB) Viewed 2696 times
Screen shot showing empty columns
Screen shot showing empty columns
Empty columns in saved report.JPG (156.1 KiB) Viewed 2696 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Save to Excel (data only) inserting empty columns

Post by HighAley »

Hello.

The same issue was in previous versions.
The columns are made for the while report. Unfortunately, it's impossible to remove them if you use Data Only option.

Thank you.
sandynith
Posts: 64
Joined: Thu Dec 12, 2013 4:03 am

Re: Save to Excel (data only) inserting empty columns

Post by sandynith »

Thanks Aleksey for your reply.

>> The columns are made for the while report.
Could you please explain what do you mean here?

>> Unfortunately, it's impossible to remove them if you use Data Only option.
Do you know any workaround for this problem (other than deleting empty columns manually :-) )
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Save to Excel (data only) inserting empty columns

Post by HighAley »

Hello.
sandynith wrote:>> The columns are made for the while report.
Could you please explain what do you mean here?
Sorry, I meant that the columns in Excel file are created for the whole report. Like if you don't select Data Only option.
sandynith wrote:>> Unfortunately, it's impossible to remove them if you use Data Only option.
Do you know any workaround for this problem (other than deleting empty columns manually :-) )
You could follow the suggestions from How to Create Report for Export? article.

Thank you.
Post Reply