IBM Support

Excel 2007 outputs do not reflect Size and Overflow settings but HTML outputs do

Troubleshooting


Problem

In a Report Studio report, the report's author has set the Size and Overflow property of various objects to customize their widths and heights. The desired column and row sizes and text wrapping are seen in HTML output but not when the report is exported to the Excel 2007 format.

Symptom

By default the table cell width and height specification support is disabled in outputs to this format, however there is an advanced property which enables control of these attributes.

Check Defect COGCQ00796698 for more details

Cause

.

Resolving The Problem

Set the advanced server property RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL to TRUE for both BatchReportService and ReportService services.

Restart Cognos services to ensure that the settings are appropriately applied.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.1.1;10.2;10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21674298