CDM Excel object, Page layout: two columns
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