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.

Note:  This procedure does not work for blocks of cells. If you attempt to copy and paste blocks of cells, the system attempts to write the contents of all source cells to a single cell in the destination grid.

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.