Receiving Error Message When Exporting Participant Overview Section To Excel (Doc ID 2822529.1)

Last updated on NOVEMBER 18, 2021

Applies to:

Symptoms

From Participant Snapshot > Participant Overview, any export to Excel with a date fields are not formatted correctly.
When opening the Excel, get message :
          Repaired Records: Format from /xl/styles.xml part (Styles)

User has to manually format the date columns to display correctly in Excel.

STEPS
1. Participant Snapshot > Select Participant > Participant Overview
   
2. From the Participant Dashboard, under Participant Detail, click on Export > Excel 2007+
    Note: Get message that the Excel download successfully
3. Open Excel, get message:
    Repaired Records: Format from /xl/styles.xml part (Styles)
4. Excel data columns ( E - Start Date , F - End Date ) are showing the number equivalent.
    If change the column format to date, it displays correctly.
   

Cause

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