Copying and Pasting Data to and from the Grid

Top  Previous  Next

 

Pasting. You can copy data into the grid by pasting it from the Windows Clipboard. To do this, simply hit the "Paste" button at the bottom the screen. This will clear the grid and copy any data from the clipboard into the grid.

 

The data to be pasted should be arranged in rows and columns like the grid. Each number can be separated with any non-numeric character like a comma or space. For compatibility with spreadsheets, you should use a tab character. Each row is separated a carriage return and line feed. If you are copying data from an Excel spreadsheet, the information will automatically be in the proper format.

 

Copying. You can copy data out of the grid using the Windows Clipboard. To do this, simply hit the "Copy" button at the bottom of the screen. All the cells in the grid will be copied to the Windows Clipboard. The data copied to the clipboard will be compatible with spreadsheets like Excel. That is, the each row of data will be on single line. Data items will be separated by tab characters. Rows will be separated by carriage return characters.