Paste Special

Paste Special

When you paste in data, DataGraph does its best to detect the format (comma separated, tab delimited, etc.). If your data is not pasting correctly with basic copy and paste, you can customize what is pasted in using Edit> Paste Special (Shift-Command-V). That will bring up the Paste Special interface.

Example with Decimal as Comma

Here is an example data set with three columns and the middle column is a number with the comma as the decimal, as is common in Europe.

If we used Edit > Copy this data would look like this, where all three columns as interpreted as text.

Use the gear menu or control-click on the header, to change the Value to a number column type.

The text will be red, indicating a data validation error, as DataGraph requires the use of a point for the decimal.

You could fix using Data > Find & Replace (Shift-Command-R) OR paste the data using Edit > Paste Special (Shift-Command-V).

Try with this example data set. Select the data and use Command-C to copy.

GroupValueCode
A1,4D
B2,5E
C3,6F

Then open a new DataGraph file and use Edit > Paste Special (or Shift-Command-V). This opens Paste Special.

For this case, check two buttons:

  • Check First row is the column name
  • Check the button to change commas to decimals

Paste Special gives you preview of the imported data.

Select Paste in the bottom right corner. The data is now imported into the data table.

Note that you can also use Paste Special after you have imported data. You could click a column header to select, then copy the clipboard.

Once in the clipboard, select Edit > Paste Special. Then you can parse the column (or columns) you copied, and the program will overnight the values in the data table, as long as you still have them selected.

Related Articles