Page 1 of 1

Issue exporting report to excel

Posted: Tue Sep 19, 2017 10:45 am
by oogarlo
Hi all,
we're experiencing some problems with excel export of a report containing a simple table with a huge amount of columns (55).
The exported file contains some columns with merged cells also if the content doesn't really requires it.

Reading the forum we've already had a try setting the DivideBigCells to false or disabling the table autowidth property with no results.

We've already read the How to Create Report for Export? section too, but being a simple table with no particular formats or cell placements we've found no suggestions about it.

We're using 2017.1.4 java/JS release. Can you help us?

Thanks in advance.

Here it is in attach a sample of our report with datasource data sample.

Re: Issue exporting report to excel

Posted: Wed Sep 20, 2017 7:13 am
by oogarlo
here it is what we have exporting to excel:
Image
several collapsed columns having width like 0.1 (highlighted by arrows).
Once you expand one of these collapsed columns, you'll find merged cells

in attach the exported excel file

Re: Issue exporting report to excel

Posted: Wed Sep 20, 2017 1:50 pm
by Alex K.
Hello,

There are some gaps between cells in the Table component. For correct exporting, please try to use the DataBand component instead Table.

Thank you.

Re: Issue exporting report to excel

Posted: Thu Sep 21, 2017 7:56 am
by oogarlo
thanks for the hint Aleksey, we'll try with DataBand ;)

Re: Issue exporting report to excel

Posted: Thu Sep 21, 2017 1:56 pm
by oogarlo
DataBand works fine!

Thanks!

Re: Issue exporting report to excel

Posted: Thu Sep 21, 2017 5:07 pm
by Alex K.
Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.