Very wide rows/columns when downloading dashboard to excel (OBIEE 12c)

Very wide rows/columns when downloading dashboard to excel
(OBIEE 12c)

         The problem was when you export whole dashboard or answer to excel, columns and rows goes to big (more than they have characters in it). Many of customers want to have identical data/visualization in excel file like they have in OBIEE portal are unhappy about it. Solution to resolve this problem is realy simple. Open file "xdo.cfg" (location: $OMW_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/xdo.cfg) and change parameter named 

<property name="xlsx-keep-values-in-same-column">true</property>

to 

<property name="xlsx-keep-values-in-same-column">false</property> 

After that, restart all BI services and try to export excel file. You'll see that everything in excel is same like you see in OBIEE portal.

Cheers!