My Oracle Support Banner

Oracle Taleo Enterprise Edition: <pre> HTML Tags in OBI Do Not Export to Excel as Line Breaks (Doc ID 2328802.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 19A and later
Information in this document applies to any platform.


Problem Description:

When overriding the default data type in Column Properties to use a Custom Text Format with <pre> tags, the Excel 2007+ export does not contain line breaks.


  1. In the report/analysis, drop-down on the right side of the text column (ex. Requisition Description) and select Column Properties
  2. In the Column Properties window, select the Data Format tab
  3. Check the box to Override Default Data Format
  4. Drop-down next to Treat Text As and select Custom Text Format
  5. Add the following to the Custom Text Format box:   

  6. Select the OK button to exit the Column Properties window

Run the report/analysis and select to export it to Excel 2007+.  In the export, any page breaks in the column text will be replaced with a space.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.