Cutting, Copying, and Pasting Data in Grids

After selecting data, you can cut, copy, and paste it in various ways, depending on the Touchstone grids you are working with. Click here for information about selecting items in Touchstone grids.

Click any of the following links for information about the grids that are enabled and about how cut, copy, and paste works in the grids.

Enabled Grids


Exposure Grids	Results Grids
Exposure Grids	Geospatial Results	Hazard Results
Contract List Locations List Location Terms Location Reinsurance Layers List Layer Sublimits Layer Reinsurance Step Functions Trigger by Percentage Step Functions Trigger by Amount	Zone Accumulation Results Overview Location-Based Ring Results Overview Hazard Boundaries Event Accumulation Results Custom Event Footprints Custom Boundaries Spatial Damage Ranges Contributing Contracts Contributing Layers Contributing Locations	Hazard Results Intensity Hazard Results Table

Exposure Grids

You can copy and paste any data visible in the grid. However, you can cut data only from individual fields that you can manually edit in the exposure management grids, and you cannot cut multiple cells or rows. For example, you can cut-and-paste data from the Insured Name field in the Contract List, but you cannot cut data from the Perils field (the Cut command is not available on the shortcut menu).

You can paste data that has been cut or copied from either the grid or a spreadsheet into a spreadsheet or other external application. You can also paste exposure data from an exposure grid or from a spreadsheet into a grid without overwriting existing data.

Note:

If you copy contracts, you must edit the contract ID because the contract ID must be unique. Touchstone's Validation program will warn you about any data that you must correct after pasting it into a grid.

Results Grids

You can copy, but not cut, data from a results grid, and you can paste the data into a spreadsheet or other external application, but not into a Touchstone grid.

Exposure and Results Grids

You can copy with or without headers. Use "Copy with headers" to paste the data into a spreadsheet when you want to include the column headers.

You can select single cells and rows, multiple contiguous cells, and multiple non-contiguous cells for copying and pasting.

Procedures for Each Grid Type

The following table summarizes the cut, copy, and paste procedures for exposure and results grids.


Operation	Exposure Grids	Results Grids
Cut You can cut data only from single, editable cells.	Select the editable data to copy. Right-click the data and the select Cut.	Not applicable.
Copy	Select the data to copy. Right-click the data and then select Copy.	Select the data to copy. Right-click the data and then select Copy.
Copy with Headers Useful for pasting into a spreadsheet with column headers.	Select the data to copy. Right-click and then select Copy with Headers.	Select the data to copy. Right-click and then select Copy with Headers.
Paste a single cell of cut or copied data into a grid	Click the receiving cell, and then right-click and select Paste.	Not applicable.
Paste a row or rows into the grid	Right-click the leftmost cell of the row below where you want to insert the copied data and select Insert Copied Cells.	Not applicable.
Paste data from a spreadsheet into a grid	Right-click the leftmost cell of the row below where you want to insert the copied data and select Insert Copied Cells.	N/A
Paste grid data to a spreadsheet	In the open spreadsheet, paste the copied data. If you have selected Copy with Headers, Touchstone pastes the data with the column headers.	In the open spreadsheet, paste the copied data. If you have selected Copy with Headers, Touchstone pastes the data with the column headers.

Examples

Click in an Insured Name cell in a Contract List grid. The in the first cell of the selected row changes to an Edit icon (pencil) and the data in the selected cell is highlighted in blue, ready for you to edit, cut, copy, or paste the data.
Select a few rows in the Locations grid. Right-click and then select Copy. Right-click the row above which you want to insert the copied rows and then select Insert Copied Cells. The copied rows are inserted above the row with the icon. (Selecting Paste will overwrite data.)
Select a few non-contiguous rows in the Locations grid. Right-click and then select Copy with Headers. Open a spreadsheet application and paste the copied data into it. Touchstone copies only the headers of the selected rows into the spreadsheet.
Copy selected data from a spreadsheet application. Select a row in a Locations grid in Touchstone and then select Insert Copied Cells. The copied data is inserted immediately above the selected row (with the icon), starting from the Location ID cell.