Categories
- All Categories
- 14 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI publisher issue- RTF template with Excel output wrapping

Summary
BI publisher issue- RTF template with Excel output wrapping
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
Answers
-
You are using RTF or EXCEL template?
0 -
Hi pavankdatti
I have applied cell and Table to follow the same==> Wrap and Fit Text. Both check boxes are ticked. But still I see this.
Hi shukla
I am using RTF template and getting Excel Output.
Thanks
kp
0 -
Hi,
If you are using RTF template then please set the properties of columns and apply the same for complete table and columns would make output. There is an option to fit text and wrap text for an cell/column.
Usually, MS Excel is having the capability of auto adjustment but not adobe.
Regards
Pavan kumar
0 -
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?
0 -
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
0