Thursday, October 14, 2021

How to Fix Merged Columns in BI Publisher Excel Output in Oracle Fusion

So, you have created RTF template which has output in excel form. 

But in the output, some of the columns are shown merged. Please see below column G and H are merged under SDO header -

But the users don't want merged columns and you don't see this in RTF template at design time .. So how to fix this ?
Here are the steps -

- Navigate to BI Publisher Catalog 

- Go to Report Properties - > Formatting

- Look for the property 'Keep Values in same column'

- Set the value to True

- Save

- Run the report and you will see the columns are no more merged.