Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » excel emitter
excel emitter [message #480904] Tue, 18 August 2009 19:49 Go to next message
Kris Chappell is currently offline Kris ChappellFriend
Messages: 6
Registered: July 2009
Junior Member
I need to output an excel spreadsheet where the columns do not
automatically wrap. I don't want to resize the report and set the column
width to the widest it needs to be to accommodate a particular field. Is
there any way that I can use onRender (or any other scripting opportunity)
to tell the excel emitter not to wrap the text within a column. Or
perhaps grab the excel object and set the worksheet to nowrap?

Thank you.
Re: excel emitter [message #481109 is a reply to message #480904] Wed, 19 August 2009 16:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kris,

Have you tried using the text block properties on a style?
Try the no wrapping under the whitespace category.

Jason

Kris Chappell wrote:
> I need to output an excel spreadsheet where the columns do not
> automatically wrap. I don't want to resize the report and set the column
> width to the widest it needs to be to accommodate a particular field. Is
> there any way that I can use onRender (or any other scripting
> opportunity) to tell the excel emitter not to wrap the text within a
> column. Or perhaps grab the excel object and set the worksheet to nowrap?
>
> Thank you.
>
Re: excel emitter [message #481334 is a reply to message #481109] Thu, 20 August 2009 14:10 Go to previous messageGo to next message
Kris Chappell is currently offline Kris ChappellFriend
Messages: 6
Registered: July 2009
Junior Member
Yes, thank you. I've tried this. It works for HTML and PDF, but not xls.
That is why I though if during the rendering phase I could do something.
Can I change the attribute at the time it is actually rendered? Maybe
that will work. I'm open to suggestions.

Thanks again,
Kris
Re: excel emitter [message #481339 is a reply to message #481334] Thu, 20 August 2009 14:38 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Kris,

Are you using the Tribix emitter or the built in excel emitter? Can you
post a small report that shows the problem?

Jason

Kris Chappell wrote:
> Yes, thank you. I've tried this. It works for HTML and PDF, but not
> xls. That is why I though if during the rendering phase I could do
> something. Can I change the attribute at the time it is actually
> rendered? Maybe that will work. I'm open to suggestions.
>
> Thanks again,
> Kris
>
Previous Topic:PPT download from server - error
Next Topic:Change Font for Report Print-friendly Version
Goto Forum:
  


Current Time: Fri Apr 26 08:11:54 GMT 2024

Powered by FUDForum. Page generated in 0.03140 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top