IBM Support

Columns are merged in Excel 2007 output

Troubleshooting


Problem

When setting Size and Overflow on a column, Excel 2007 output can merge cells. This is not the case in Excel 2002 output.

Resolving The Problem

To avoid this behavior you can add an advanced setting in Cognos.

Steps:
- in IBM Cognos Administration portal click on Status tab then click System on left menu
- Click on blue arrow next to System (in Scorecard part) and choose set Properties
- Click on Settings tab
- on Advanced settings click Edit…

Then add this parameter:
Parameter column :
RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL
Value column:
TRUE

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1;10.2.1.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21612835