Show TOC

EPMCopyRangeLocate this document in the navigation structure

This function enables you to add and repeat the content of a range of cells until the bottom (columns) or the right side (rows) of a report is reached. The range is added to the data grid and in the shift zones (if there are any), starting after the row axis and below the column axis.

  • The following content of the specified source range is added to the report cells that do not contain any data: all the format settings; formulas, data, fixed text and data validation settings.
  • By default, the following content of the specified source range is added to the report cells that contain data: all the format settings and formulas. If you want to add the following content to the report cells that contain data, enter TRUE in the copyAllOnCopyRange parameter: all the format settings; formulas, data, fixed text and data validation settings. Only empty cells will not be added to data cells.
  • If the source range that you want to add is smaller than the report range, the following content of the source range is duplicated as long as the report range has not been reached: all the format settings; formulas, fixed text and data validation settings, in the report cells that do not contain any data.
  • If the source range is added to a blank zone (shift) of the report, and if the source range is larger than the blank zone, the beginning of the source range is added to the blank zone and the rest of the source range is duplicated in the data grid.
You can add the range to one or more reports, using the reportID parameter. For example: "000;001", where 000 corresponds to the first report of the sheet (also called the default report) and 001 corresponds to the second report of the sheet.
Note Use the ; character to separate the reports.
Parameter Description
reportID ID of one or several reports
Rows Specify where the range will be added. Enter TRUE to add the cells in rows, FALSE to add the cells in columns.
SourceRange Specify the cell range containing the content that will be added to the rows or columns.
copyAllOnReportData Specify if all content types are added to the report data. Enter TRUE to copy all content types. Otherwise, enter FALSE.
Note When several reports share an axis, here is how the EPMCopyRange function behaves: if the axis that is specified in the EPMCopyRange function (using the Rows parameter) is not the master axis, the EPMCopyRange function is simply ignored.