Archibus Smart Client

Copying and Pasting Grid Data

You can copy:

• a single cell and paste it to another cell or to a column.
• a single row and paste it to one or more rows.

You must have edit permissions for the field to which you are copying data.

Note: The Replace Column command is a powerful way to replace an entire column with the same value or an SQL expression. See Replacing Column Values.

The copy command copies any grid selection (text, cells, columns, or records)  to the Clipboard. You can paste text derived from Archibus grids or text selected from other applications, such as word processing or spreadsheet programs.

You can use this command to copy selected items to another place without affecting the existing selection. You can even copy selected items to other spreadsheet or word processing applications. When Archibus copies a series of field values, it uses tabs to separate the values.

You access the copy and paste commands using the keyboard:

• Copy by pressing CTRL + C.
• Paste by pressing CTRL + V.

How to Copy and Paste a Row of Data to One or More Rows

To copy and paste a row of data to multiple rows:

1. Select the single row to be copied. You can copy cells from only one row.
2. Press CTRL + C.
3. Select the rows to which you want to paste the copied data. You can select multiple rows to copy to.
4. Press CTRL + V to paste the data.

   A message asks you to confirm that you want to paste to multiple rows as this action cannot be undone.

5. To proceed, click OK.

   The single row of source data is copied to each destination row that is selected.

If an error is encountered (for example, because some data cannot be validated), a message informs you of the save error and the paste action stops at the row that has the error.

For example, if you paste a floor 17 onto a Room record hq-18-101 to change its floor, and that room already exists, you will get a message that there is a duplicate record, and the command will stop. You can correct the value, and begin the copy and paste operation again using the updated data.

How to Copy and Paste a Single Cell Value

To copy and paste a single cell value

1. Select the value you wish to copy.
2. Invoke the Copy command by pressing CTRL + C.
3. Select the cell or cells that you want to update with the copied value.
4. Invoke the paste command by pressing CTRL + V.

   If you are pasting into cells for more than one row, a message asks you to confirm that you want to paste into multiple rows as this action cannot be undone.

5. To proceed, click OK.