Disable Wrapp Text in Excel.

Hi,

I'm using Birt Designer version 2.5.1 to build a report design to be used to generate a XLS document using Tribix extended xls emitter.

My problem is that all data inserted when opening the generated report in microsoft office (2003 or 2007) is being "wrapped".

Because of that my data is being hide when it shouldn't! If I turn the wrapper option off in the excel, it solves the problem.

I would like to know how can I turn it off using the birt designer if possible.
Can anyone help me?

Thanks in advance,
Pedro Lemos

Find more posts tagged with

Comments

mwilliams

Hi Pedro,

I don't think there's a way to set Excel's setting to no wrap from BIRT. Have you tried setting the widths of columns to be sure that the text fits and doesn't need to wrap?

pm-lemos

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Pedro, 
 
I don't think there's a way to set Excel's setting to no wrap from BIRT. Have you tried setting the widths of columns to be sure that the text fits and doesn't need to wrap?</blockquote>
 
Actually I only need to disable the option to wrap text and 'excel' shows all the text from that cell. 
 
But thanks anyway mwilliams

Any other suggestion? 
 
Pedro Lemos

mwilliams

Pedro,

I just meant that it might render with the specified width so the text won't wrap and you won't have to go through and disable the wrap text option. The only other thing I can think of is that you might be able to modify the emitter to set the excel property for you so you don't have to manually do it. Not sure if that's possible though.