Export to Excel and Export to CSV Format Produces a Different Column Order (Doc ID 1353652.1)

The following is observed with one particular analysis / report where the results are displayed in a Table view ...

1. In Answers, view the results of the analysis in the Results tab ... the columns appear in a particular order. 

For example, the columns and order may be like the following in the Results tab:
Year, Region, Brand, Revenue, Discount Rate

2. Click on the "Export this analysis" button > Choose "Excel 2003+" ... the columns in the Excel file are in the same order as per the Results.

For example, the columns and order may be like the following in the Excel file:
Year, Region, Brand, Revenue, Discount Rate

3. Click on the "Export this analysis" button > Choose "Data" > Choose "CSV Format" ... the columns in the CSV file are NOT in the same order as per the Results.

For example, the columns and order may be like the following in the CSV file::
Year, Brand, Revenue, Region, Discount Rate

The issue is that the data columns appear in one order when the users export the data to CSV Format, and the data columns appear in a different order when the users export the same data to Excel 2003+.

Cause

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