In a report definition created through the Report Designer, copying and pasting can be different than in a regular workbook in Excel. This is because business rules are applied not only on the cell level, but also on the report, row, and column level. This section will explain the rules for copy and paste for various business rule levels.
The copy and paste rules in Report Designer are the same as for a regular workbook. By default, formulas and groupings are preserved.
The copy and paste rules in Report Designer are the same as for a regular workbook when working in a single worksheet. By default formulas and groupings are preserved.
NOTE: If rows/columns are pasted into a different tab than the original source, groupings will not be preserved.
NOTE: If you want to copy and paste an existing group, you must copy the whole row/column, not just the cells where the information is.
The copy and paste rules in Report Designer for an entirely new tab require you to use a special copy menu. By using this menu, all formulas, groupings, and parameters are preserved.
[icon name=”exclamation-triangle” class=”2x” unprefixed_class=””] Pasting the tab will overwrite all information on the tab that was selected when taking the third step. It is very important to create a blank worksheet so that no data are lost.