COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Eag. E on 22 Feb 2017 08:39:12 PM

Title: Export in different Excel format with style issue
Post by: Eag. E on 22 Feb 2017 08:39:12 PM
Hi All,

I have got a problem, testing with latest FP in 10.2.2 (10.2.2.5), my colleague also confirmed issue exist in other versions

* Using IBM Sample Data can reproduced the problem as well.

I create a single List with only one col, and I define the col as 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' manually. Then run the report and save as:
1. Excel 2007 format
2. Excel 2002

You could see different style, it seems in 2002, the cell wrapped whereas in 2007 can not (attachment).

P.S. I have set parameters:
RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL=TRUE
RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL=TRUE