Forum Discussion

kmd's avatar
kmd
Contributor
6 days ago

Version 8 formatting issue with Books/Cube Views produced in Excel?

Just checking to see if anyone else has been experiencing the following issue with Version 8.
We are currently testing the upgrade from 7.x to version 8 and have run into a huge formatting issue with our books that are produced to Excel and sent out to management via postal service.

The source cube views for a batch use the same column template.

We have Excel column width formatting set up for each of the columns (but consistently on each column).

When the cube views are run and exported to Excel, the column width is not being recognized in most of the columns.

I have tried direct formatting, I have tried with a literal parameter and getting the same results no matter what.  I don't see where I can attach the workbook itself but am attaching a screen capture sample.  In this case text wrap is set to False and column widths are set to 100.  Note the results.  Oddly, in like the first book, some of the sheets ARE recognizing the column width.

I'm just wondering if anyone has experienced this and has found a workaround or determined why this is happening.  

No RepliesBe the first to reply