cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lala
Level VIII

Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

Hello!

Is JMP possible to select cells with the cursor and copy the contents of cells to the paste board?

 

 

  • Select cell[3,1],  then "JANE" copy to paste board.

2022-06-01_13-54-17.png

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

You could try using Row State Handler. Quick example without proper error handling:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

f = Function({a}, 
	If(N Items(dt << get selected columns) < 1,
		return();
	);
	Main Menu("Edit:Copy", dt << Get Name);
	
);
rs = dt << make row state handler(f);
-Jarmo

View solution in original post

5 REPLIES 5
lala
Level VIII

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

This time the web page cannot be translated automatically.The post was over 2 hours.

Thanks!

2022-06-01_15-48-17.png

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

Hi,

Does right-clicking on the cell and selecting "Copy" or, alternatively, Ctrl-C do what you want? 

lala
Level VIII

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

Thank you very much!

It is my ideal, VBA has cell click event code can be implemented.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
jthi
Super User

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

You could try using Row State Handler. Quick example without proper error handling:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

f = Function({a}, 
	If(N Items(dt << get selected columns) < 1,
		return();
	);
	Main Menu("Edit:Copy", dt << Get Name);
	
);
rs = dt << make row state handler(f);
-Jarmo
lala
Level VIII

Re: Is it possible to select cells with the cursor and copy the contents of cells to the paste board?

d3 = Current Data Table();
c = (d3 << get selected columns)[1];
r = (d3 << get selected rows)[1];
gm = Column( d3, (d3 << get selected columns)[1] )[(d3 << get selected rows)[1]];