Disable Wrap Text in the excel output generated using RTF template

Sukanya Mukherjee

Hi,

I am creating a RTF based report using BI publisher, and the default output is Excel. But the output in excel is generating with wrap text. How can i disable the wrap text feature.

Please note, the table properties already used the text wrapping as None.

Mallikarjuna Kuppauru-Oracle

Hi @Sukanya Mukherjee

  By default, if the text within a table cell will not fit within the cell, the text will be wrapped. To truncate the text instead, use the table properties dialog.

1. Place your cursor in the cell in which you want the text truncated.
2. Right-click your mouse and select Table Properties... from the menu, or navigate to Table > Table Properties...
3. From the Table Properties dialog, select the Cell tab, then select Options...
4. Deselect the Wrap Text check box.

If above is won't work check for Report formatting tab options -

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-85D87FB9-736E-4503-9259-47DC38B52DEA.htm

Regards,

Arjun