topic How to copy/paste value color settings from one JMP table to another in Discussions

How to copy/paste value color settings from one JMP table to another

Fiona_Baines — Sat, 10 Jun 2023 23:16:14 GMT

It is possible to copy/paste value order settings from one JMP table to another.

Is it also possible to copy value color settings from one JMP table to another using point and click? There is the option to right click and select "copy" but I can't see how to paste color settings into the new table in order to avoid having to repeat setting the value colors again.

Re: How to copy/paste value color settings from one JMP table to another

martindemel — Fri, 17 Jul 2020 10:00:34 GMT

If you talk about value color settings, this can be done by point and click: Right click into the column -> Copy Column Properties. Go to the second table, right click on the column -> Paste Column Properties. Take care that all column properties will be copied and pasted.

In the (i believe) unlikely case of just single cells:

If you have only certain cells colored and want the same cell colored in another table. The only way I know you can do this interactively is

right click, copy column, in new table right click paste column, you will get a new column with just the colored cell, then copy the column entries of interest and paste them into the new column with the colored cell. You may want to delete the old column.

You may want to think about JSL scripting to do this as it will be less error prone.

Re: How to copy/paste value color settings from one JMP table to another

Fiona_Baines — Mon, 20 Jul 2020 10:49:19 GMT

Many thanks for the tip Martin. This is a great time saving when you have multiple tables that have common columns which need to have the same column properties.