Using the Spreadsheet Editor

The properties of a group of similar objects can be edited using a spreadsheet editor.

Capture provides three spreadsheet editors for editing properties: the property editor, the browse spreadsheet editor, and the package properties spreadsheet editor.

The property editor

Use the property editor from the schematic page editor to edit properties for instances or occurrences of the following objects:

Parts (including hierarchical blocks)
Nets (including constituent nets within buses)
Pins
Title blocks
globals
Ports
Aliases

Roll the mouse wheel up and down to scroll through vertically in the Property Editor.

Hold down the CTRL key and roll the mouse wheel to zoom in and zoom out.

Hold down the SHIFT key and roll the mouse wheel up and down to scroll through horizontally in the Property Editor.

Click the mouse wheel button and drag the mouse wheel:

To the right or left in the Property Editor window to scroll horizontally.
Up or down in the Property Editor window to scroll vertically.

The Browse spreadsheet editor

You can display the Browse spreadsheet editor from the Edit menu of the project manager, schematic page editor, or the part editor.
You can edit the following properties using the Browse command from the Edit menu in the project manager:

Hierarchical ports
Off-page connectors
DRC markers
Bookmarks
Parts (including hierarchical blocks)
Net (including constituent nets within a bus) occurrences
Pin properties
Title block occurrences
Flat nets
In the schematic page editor, you can edit the following properties in the Browse spreadsheet by using the Properties command from the Edit menu:
Off-page connectors
DRC markers
Bookmarks
From the part editor (while in Part View), you can edit the following properties using the Browse spreadsheet:
Pin properties
The Browse spreadsheet editor browses the entire design for the objects you select, then displays their properties. Each property appears as a column heading in the spreadsheet. Each row is an object located by the editor.
It is important to note that, in the Browse spreadsheet editor you can edit only occurrences. The only exception being in the part editor, where you can only edit instances. To edit instance properties, you must use the property editor .

To create a new property in the Browse spreadsheet editor

In the first column of the Browse spreadsheet, select the object or occurrence for which you want to create the new property.
From the Edit menu, choose Properties. Capture displays the object in a new Browse spreadsheet window.
Click New. Capture displays the New Property dialog box.
Enter a name and value for the new property, then click OK. Capture adds the property to the object or occurrence and displays the property in the original Browse spreadsheet.

To copy a value from one property to another property in the Browse spreadsheet editor

In the first column of the Browse spreadsheet, select the object or occurrence that has the property with the value you want to copy.
From the Edit menu, choose Properties. Capture displays the object in a new Browse spreadsheet window.
Select the cell that contains the value you want to copy.
Click Copy.
Select the cell that you want to contain the copied value.
Click Paste. Capture pastes the value into the selected cell.

You can use the CTRL + C keys to copy a value from a cell and the CTRL + V keys to paste onto another cell in the Browse spreadsheet editor. Also, you can use the CTRL+ INSERT keys to copy a value from a cell in the Browse spreadsheet editor and paste it onto a cell in Microsoft Excel worksheet or use the SHIFT+ INSERT keys to paste values copied from Microsoft Excel onto a cell in the Browse spreadsheet editor.

To remove a user-defined property in the Browse spreadsheet editor

In the first column of the Browse spreadsheet, select the object or occurrence that has the property you want to remove.
Select the column heading for the property you want to remove.
Click Remove. Capture removes that property from the object.

Some properties cannot be removed as they are essential for creating a netlist. You can only remove user-defined properties.
If you remove a property from an occurrence for which there is a defined instance property, the occurrence property is not removed, but rather the instance property value "shines through" to the occurrence. To remove an instance property, you must use the property editor.

To replace property values

Select the objects whose properties you wish to edit. Note that the objects must be of the same type (for example, all pins or all hierarchical ports); otherwise, the Properties command is grayed out.
From the Edit menu, choose Properties. The Browse spreadsheet appears.
Double-click on a cell holding the value you wish to replace, then enter the new value.
Click the copy button.
Select the cells that are to receive the placement value.
Click the Paste button. The replacement value appears in the selected cells.
Click the OK button to close the Browse spreadsheet.

The Package Properties spreadsheet editor

Use the Package Properties spreadsheet editor to edit package properties of pins.
You can edit package properties using the Package Properties spreadsheet editor. The Package Properties spreadsheet editor is available in the part editor while in Package View. Use the Properties command on the Edit menu to display this spreadsheet. The spreadsheet displays all the package information on pins.
The Package Properties spreadsheet editor is similar to the Browse spreadsheet editor with the following differences:

The Package Properties spreadsheet editor doesn't have New or Remove buttons. You cannot add properties to a package, or remove existing properties.
The Package Properties spreadsheet has an Update button and a Validate button.
The Package Properties spreadsheet displays all of the pins in the package, regardless of what is selected in the part editor.
The package Properties spreadsheet displays two properties that do not show up in the Browse spreadsheet editor. These properties are PinGroup and Ignore.

Update

Use this to update the properties of all the pins in the package. This button is useful if you change a property on one pin, and need to change this property on the same pin in the other parts of the package. For example, say you have a four-part package. Each part in the package has a pin named IN. If you change this pin from a passive pin to an input pin in the A package part, you could use this button to update the type property for the IN pin in the B, C, and D package parts. The Update button updates all pins at once, without requiring that you click OK.

Validate

Use this button to check for duplicate pins. For example, suppose you have a pin 1, and then change another pin to pin 1. Using this button would detect the duplicate. This button checks for duplicate pin numbers, without requiring that you click OK.