Excell formatting

Hi all,

I have a small problem when exporting my reports to Excell files. The columns are set at minimum width even if they appear fine on HTML export. I can't even read the columns'content in Excell without resizing them. Did anyone already encounter this behavior ?

Thanks,

Fabien

Find more posts tagged with

Comments

mwilliams

Hi Fabien,

Does this problem occur no matter how many columns you have in your report? Also, what version of BIRT are you using?

bhagyaa

I too have the same problem..when we try to export to excel independent of how many columns it has...the width in the excel is taken to me the minimum...

Please suggest a solution.

bhagyaa

we are using BIRT 3.2.15

USHA

when i view the report in Excel the output is starting from column "B" ... wat to do to start the output from column "A"

i am also using 3.2.15 version

can any one of u help on this

Thanks
Usha

mwilliams

Hi Usha,

The problem you're talking about was a problem in older versions of BIRT. It's now fixed in BIRT 2.3.

mwilliams

Fabian & bhagya, 
 
I see the issue you're talking about with the shrinking column widths. It seems that number and date type data columns are sized correctly, but string data columns are not. You can specify widths for certain columns, but "pages" seem to be pre-determined when exporting to Excel, so if you expand the columns to be larger than the pre-determined page size, you get an exception and the report fails. I found a workaround that would probably only work for you if you're only using the output formats of XLS and HTML. If you're using PDF output for these same reports as well, this probably won't work for you because of the page size manipulation. In the property editor for the master page in the general section, you can choose a page type of custom where you can define your own "page" size (height & width). If you make this large enough for your table to fit, you can size all your columns to the desired width in your design with no problems. Again, you'll probably only want to do this if you're only using these reports for XLS and HTML. 
 
If one of you could please file a bug for this at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>, that would be great. 
 
Hope this helps.

nerlijma

Hi, Is there any open issue for this bug? I also have to export in XLS format and that page limitation is killing me. thanks!

mwilliams

nerlijma,

At the link above, you can search the bugs to see if you find the bug. If you don't, please log one for the issue with screenshots and a good description of the problem. Also, you can post the bug information in this thread for tracking purposes after reporting it.