Excel Copy and Paste Guidelines

  • In data forms, after copying a cell, only a single paste is allowed. Pasting into subsequent cells is not supported.

    Workaround: After pasting the cell once, you must copy the cell again in order to paste it into another cell.

  • In forms or ad hoc grids with hidden columns, you will have unexpected results if you attempt to copy two or more consecutive cells from a range containing visible and hidden cells and paste them into a range of visible and hidden cells. The copied cells will be pasted to both the visible and hidden cells. This is Excel behavior.

    For example, suppose you are working with the following Year hierarchy on a form:

    Year
       Quarter
          Month

    On the form, the Quarter members are collapsed, so that the only visible members are Year and Month. Copy the values from one of the rows under the four Quarter cells, and paste them onto another row in another grid or form under Quarter, where the Quarter members are also collapsed.

    You may expect to see each of the four Quarter values pasted into the same position as on the previous sheet, but this is not the case. The cells will paste into the first visible cell and into the next three hidden cells (for example, Jan, Feb, Mar).

    Consider also that some Planning forms may also have spreading enabled, which can affect how the values are updated in the cells.