Row height not preserved when BIRT report is exported to excel

Hi,
I've set property "height" for some rows in the BIRT design file (.rptdesign file). The row height did change in the birt preview but is not preserved when report exported to excel. In excel, some cell contents cannot be viewed because the row height is not big enough.

How can i make the row height effect in the excel file also? I am using BIRT2.3.0.

Can anyone please shed some light on this?

Thanks in advance

Find more posts tagged with

Comments

mwilliams

Hi simontorca,

This works correctly in BIRT 2.5. I'm guessing it was a bug or a non-feature in the XLS emitter in 2.3.0 that has been fixed.

simontorca

Thanks, Michael.
I am new to BIRT. Is there anything we can do with XLS emitter without upgrade to 2.5? My understanding is that Export Report is embedded feature. As user, what can we do with XLS emitter and how to do it?

I have some additional issues with Export Report, in BIRT preview, I have something like 'page <pageNumber> of <totalNumber>", however, I could not see the same when export to word or excel:
1) export to word: the pageNumber and totalNumber are empty
2) export to excel: the pageNumber is always "1"

Any idea what's wrong?

Thanks again.

mwilliams

simontorca, 
 
The only thing I can think of besides changing the XLS emitter in the source code would be to give the Tribix XLS emitter a try. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/#description'>Tribix - Extended Emitters for BIRT - Designs & Code - BIRT Exchange</a> 
 
As for the page number always being 1 in XLS, I believe it's because there is not a concept of a page in the XLS output. The emitter lets Excel do its own pagination. For the page number in the DOC output, I haven't noticed this before. I don't have a copy of 2.3.0, but I have 2.3.1. I'll give it a look.

simontorca

Hi Michael,
I tried setting row height in BIRT 2.5, and it works. Thanks.

Regarding the XLS emitter, are there any ways to customize it or add a adapter to fit my own needs? If yes, how to do it?

Thanks.

mwilliams

simontorca,

If you dowloaded the source code for BIRT and had the know-how to change the emitter to do what you're wanting, you would be able to make the XLS output work as expected, I would imagine. Have you given the Tribix emitter a try? I don't have it installed, so I don't know if it takes into account row height in its 2.3.0 version.

simontorca

Hi Michael,
I did not try Tribix emitter. Will it work if we have mix emitters, say Tribix XLS emitter, but BIRT Word emitter?

Thanks,

mwilliams

simontorca,

Yes. The Tribix XLS emitter is just a plugin to replace the BIRT XLS emitter. The others remain the same.