Pasting the Contents of a Single Cell from a Spreadsheet

You can paste the contents of selected records that you have worked on in a spreadsheet into a grid.

This might be useful, for instance, when you have copied a set of records from the system into a spreadsheet for editing, made minor changes in a few records, and now want to copy those changes back to the grid without having to copy and paste the entire collection.

The type of contents in the source cell must match the expected type for the contents of the grid cell.

For example, if the grid is expecting an alphanumeric character string, the cell in the spreadsheet must contain alphanumeric character content. If the grid cell expects a numeral input, the source cell must contain only numeric content.

Furthermore, if the grid can accept only certain values, (for instance, Active, Disabled, or Locked), then the source cell can contain only those values. Otherwise, the paste operation will fail.

To paste the contents of a single cell from a spreadsheet into a grid cell:

1. Open the form where you want to paste the content.
2. In the spreadsheet, select the cell you want and then press CTRL+C to copy the content to the system clipboard.

   To avoid problems when copying content from Microsoft Excel spreadsheets, select (but do not copy) the cell, and then copy only the cell contents in the formula bar field. If you select the entire cell, certain hidden formatting content gets copied that can cause problems in the grid.

3. In the grid, click inside the field where you want to copy the data.
4. Press CTRL+V, or select Edit > Paste.

This action overwrites any content that was previously in the field.

Related Topics

Copying Data To/From a Spreadsheet

Copying Entire Collections to a Spreadsheet

Copying Selected Cells to a Spreadsheet

Copying Selected Columns to a Spreadsheet

Copying Selected Records to a Spreadsheet

Pasting Entire Collections into a Grid from a Spreadsheet

Pasting Selected Records (Rows) from a Spreadsheet