Hi,
I am working with Cognos 8.3, trying to export to Excel 2002
Please your help with this, I have 2 questions about a report that I am trying to export to excel.
1) The column width of a crosstab column is not the same when I open the report with Excel 2002 and Excel 2007.
Although the white space is no wrap, the text in Excel 2007 is not wrapped, but in Excel 2002 it is wrapped.
I want the text wrapped.
2) The borders of a crosstab are not painted in Excel 2002, Is it any way to paint the borders.
Thanks for your help
I attach a picture for better understanding.
Hi Chris,
I found this when searching for my own purposes for similar questions. Hopefully you've found a fix, but this might help someone else down the line!
The edges of the crosstab can be given borders as follows:
1) Click on a cell in the crosstab
2) Use the 'ancestors' arrow in the properties pane to select the actual crosstab, rather than selecting all the cells in it (I did this many times before finding the trick)
3) Now you can apply borders using the standard item in the menu bar