BI publisher issue- RTF template with Excel output wrapping — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI publisher issue- RTF template with Excel output wrapping

Received Response
1020
Views
5
Comments

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.

image

thanks

kp

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    You are using RTF or EXCEL template?

  • kp2000
    kp2000 Rank 3 - Community Apprentice

    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

  • Pavan kumar.
    Pavan kumar. Rank 5 - Community Champion

    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

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    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?

  • kp2000
    kp2000 Rank 3 - Community Apprentice

    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