OBIEE 11g - Excel Export Creates Additional Blank Columns For Some Sections Of Pivot Table

Scenario:

We have a report in Pivot table view where we are displaying the data in different sections. When i check the report on the dashboard it looks good but while exporting the same report in to Excel 2003 or 2007+ it creates some additional  blank columns for few or all sections. This issue exists in 11.1.1.7 + versions.

Root Cause:

 The difference in width of the columns used in the report are causing the issue.

Solution:

This issue is registered as bug in Oracle Support. The possible work around is, Identify the columns where you 

are getting the additional blank columns and change the size of the field in Columns, in the Criteria-->

Column Properties-->'Additional Formatting Options' to 200 (it is depending on the data size  in that column),

for instance, and then go to Results tab and export it, the .xlsx file does NOT contain any blank gap cell.