Open topic with navigation

Copy and paste values in the Property Table View form

You can copy a selection of properties (cells) from the Property Table View form and paste them into a 3^rd party program, for example Microsoft Excel, to mass-edit multiple properties. You can then copy the updates from the 3^rd party program into the Property Table View form again, mass-updating the properties directly.

The Copy-Paste function copies a selection of cells to the clipboard and from the clipboard again when pasting.

You can select the column headers of the right pane of the form, but they will not be included in the clipboard contents unless you select the special Copy with headers option. The filter row contents will also not be included in the clipboard contents.

Pasting content into the Property Table View form

The paste function inserts the contents of the clipboard in the form, using the selected cell as the first position. The paste direction is downwards an to the right, inserting clipboard contents in the

You can only paste the same number or less of rows and columns from the clipboard as you have selected in the Property Table View form. Thus you can paste fewer rows and/or columns into the Property Table View form, but not more. If you have selected more columns or more rows than the table in the form contains, the paste function will fail.

You must select an anchor cell in the right pane of the Property Table View form when pasting the content of the clipboard. The anchor cell will function as the starting point of the paste function and the paste function will insert the contents of the clipboard from the anchor cell.

If you select the column headers in the table when pasting, a cell in the filter row will be selected by IGSS as the anchor cell. If you paste using the filter row cell as the anchor cell, a mismatch will occur because the paste function will try to insert content in to the filter cell, which is not possible.

Be careful when pasting content into the Property Table Viewform. It is easy to inadvertently insert incorrect content. Since the Property Table View form updates directly when the cells are exited, object and descriptorA descriptor is the graphical display of an object. IGSS includes many types of descriptors including: - Built-in standard symbols - Animated symbols (Symbol Factory library) - Graphics and animation - Drawing symbols - Windows controls - ActiveX controls An IGSS object can be represented with different descriptors on different diagrams. property values will be updated nearly automatically. If the paste function inserts many changes, then the undo buffer will most often be overfilled and you will not be able step your way through a series of undo functions to reinstate the property values in the case of an error.

Create a backup of the configuration prior to pasting or mass-updating property values in the Property Table View form. Another suggestion is to treat the mass-updating or pasting of content into the Property Table View form as one work flow and not do mix this with other work being done in the Definition module.

To copy a selection of properties

• For Diagrams: Right-click and select Property Table View... in the diagram or press CTRL+H to open the Property Table View form for the diagram.
• For Areas: Select Area > Property Table View... or press SHIFT+CTRL+H to open the Property Table View form for the diagram.

1. In the left pane of the Property Table View form, navigate to the menu item containing the cells you want to copy.
2. In the right pane, locate the property you want to copy by finding the object name in the rows and the object or descriptor property in the columns.
   
   You can also filter the columns to gain a better overview of the properties.
   
   
3. Select the cells to be copied and press CTRL+C to copy the selection to the clipboard.
   
   You can select entire columns by selecting the column headers.

To copy a selection of properties with column headers

• For Diagrams: Right-click and select Property Table View... in the diagram or press CTRL+H to open the Property Table View form for the diagram.
• For Areas: Select Area > Property Table View... or press SHIFT+CTRL+H to open the Property Table View form for the diagram.

1. In the left pane of the Property Table View form, navigate to the menu item containing the cells you want to copy.
2. In the right pane, locate the property you want to update by finding the object name in the rows and the object or descriptor property in the columns.
   
   You can also filter the columns to gain a better overview of the properties.
   
   
3. Select the cells to be copied and click Edit > Copy with headers to copy the selection to the clipboard.
   
   You can select entire columns by selecting the column headers.

To paste a selection of properties into the Property Table View form

1. In the 3rd party program, select the columns and rows you want to paste into the Property Table View form. Make sure the selection contains the same number or less of rows and/or columns that you want to paste.
2. In the right pane of the Property Table View form, select the cell you want to use as the anchor cell.
3. Press CTRL+V or click Edit > Paste to insert the clipboard contents.

See Also

The Find and Replace form

Searching the Property Table View form

Filter the Property Table View form

Update cells in the Property Table View form

Export Property Table View content

Open topic with navigation