Smart Grid Paste (PCB)

This dialog has two variations: the Smart Grid Insert version (back) and the Smart Grid Paste version (front).

Summary

The Smart Grid Paste dialog allows you to alter the value of existing objects from pasted tabular data. When data is copied from a spreadsheet (Such as Microsoft Excel or Google Sheets) before opening the dialog, the top half of the Smart Grid Paste dialog will contain the table information from the clipboard. Use the included options to control what of that information is then transferred into the List panel(s). Select the PCB List panel or PCBLIB List panel content you would like to update before opening the dialog. The selected tables from the List panel fill the bottom half of the dialog.

The Smart Grid Insert variation of the dialog allows you to insert new rows into the List panels.

Access

To access the Smart Grid Paste version of this dialog, from the PCB List and PCBLIB List panels (in Edit Mode), right-click then select Smart Grid Paste from the context menu or use the Shift+Ctrl+V shortcut keys.

To access the Smart Grid Insert version of this dialog, from the PCB List and PCBLIB List panels (in Edit Mode), right-click then select Smart Grid Insert from the context menu or use the Ctrl+Ins shortcut keys.

Options/Controls

Clipboard Table View

When the Smart Grid Paste dialog is opened, this section is filled with information from the clipboard. Using the dialog, data can be easily copied into the List panels in table format from Microsoft Excel or Google Sheets.

• Header Row - If a header row is included in the information copied to the clipboard, enable this option. The header information will be used to form a header row of columns.
• No Header Row - If no header row is included in the information copied to the clipboard, enable this option. If a header row is included in the copied information and this option is enabled, the header information will be included in the main table area instead of being placed into column headers.

PCB List View/PCB Library List View

When the Smart Grid Paste version of the dialog is opened, this section displays selected information from the List panel. Use the following controls to copy information from the Clipboard Table View into the PCB List View. Information moved into this section will be saved into the List panel after clicking OK to exit the dialog.

When the Smart Grid Insert version of the dialog is opened, this section of the dialog is populated with information to be added to the PCB List or PCBLIB List panel. Information in this section will be added into the List panel after clicking OK to exit the dialog. In the Smart Grid Insert incarnation of the dialog, rows marked for addition are marked by a green plus and columns which have had changes affected are bolded and display the icon.

• Paste Column to Attribute - Select a column in both sections of the dialog and click this button to copy the information from the Clipboard Table View and paste it into the PCB List View.
• Undo Paste to Attribute - Undo the last performed instance of the Paste to Attribute command (using the Paste Column to Attribute or Automatically Determine Paste buttons).
• Automatically Determine Paste - Use this button to allow the software to automatically determine where in the PCB List View the clipboard information belongs.
• Reset All - Reset the entire dialog. The Clipboard Table View is refreshed. If new information is in the Clipboard, the top panel of the dialog will contain the new information. The PCB List View will revert any changes that have not been saved, including which columns are visible.
• Choose Visible Columns - Click to open the Choose Visible Columns dialog then select which columns to display in the PCB List View section of the Smart Grid Paste dialog. Enable/Disable options to Show/Hide columns.