About: HTML Tags Not Exporting to Excel 2007+ (Doc ID 2230801.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

 

Example:

  1. On the Criteria tab, add the following field to the Selected Columns section:  "Requisition Status - Current"."Current Status"
  2. Drop-down on the right of the column and select Edit Formula
  3. Replace the existing formula with the following:   
  4. Select the OK button to accept changes
  5. Drop-down on the right of the column and select Column Properties
  6. Select the Data Format tab
  7. Check the box to Override Default Data Format
  8. Drop-down next to Treat Text As and select HTML
  9. Select the OK button to accept changes
  10. Select the Results tab and see that the column shows the Current Status on the first line with the Current Posting Status underneath it
  11. Select the Export this analysis button and choose Excel > Excel 2007+
  12. Notice the results show the Current Status <br> Posting Status

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms