BI publisher issue- RTF template with Excel output wrapping

Question

Summary

Content

Hello

I have a scenario where i am printing comments column. When i do that, the column is not displayed in 1 single cell of the excel. It is going beyond 1 single cell.

For example, if i have a comments text of more than 350 characters then it opens up next cell and print the text there. Is there a way i can make all to come in 1 single excel cell.

Is there any limitation of no of characters on that?

You can see that the last column consumes row no 46 and 47. But all other columns consumes only one row.(46). How to make comments column to be fit in 1 single column.

I tried wrap text and fit to text. Nothing helped. appreciate any advise.

thanks

kp

kp2000 · Answer

HI

Thanks for the reply. I am able to fix it by replacing blank spaces, new lines chr(10),chr(13) etc.,

My text source is from pl-sql. When i return the text for the notes, i use regexp and replace to take care of  blank spaces, new lines etc.

So i am able to get long texts in a single cell.

thanks

kp

Brajesh Shukla-95078 · Answer

Hi ,

I don't think in case of long output BI Publisher will use two excel cell to print, I believe there may be some hidden table layout causing the issue.

Could you please upload your rtf?

Brajesh Shukla-95078 · Answer

You are using RTF or EXCEL template?