IBM Support

CDM Excel object, Page layout: two columns

Technote (troubleshooting)


Unable to successfully setup Excel objects to fully and correctly use the Two Columns page layout when generating to Word.


User has a Page Setup configured with Two (2) Columns. When generating the Entire Report or Selected Sections, the 2nd column of Excel objects rendered is cut-off and the rest of the object is generated on a 2nd page.


This is due the "Excel Page Break" feature in CDM 10.2.0. This makes the printable range to be split at the point where page breaks are present in Excel.


CDM 10.2.0 only

Resolving the problem

Adjust the page breaks in Excel in a way that the entire printable range is contained on one page:

1. select the worksheet that contains the printable range
2. open the Page Break Preview (from View tab)
3. using the mouse adjust the breaks to include the entire ##RS/##RE range

Document information

More support for: Cognos Disclosure Management
Cognos Disclosure Management

Software version: 10.2

Operating system(s): Windows

Reference #: 1634747

Modified date: 18 April 2013