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

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

lala — Fri, 09 Jun 2023 17:00:23 GMT

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.

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

lala — Wed, 01 Jun 2022 07:54:41 GMT

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

Thanks!

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

HadleyMyers — Wed, 01 Jun 2022 07:57:10 GMT

Hi,

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

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

lala — Wed, 01 Jun 2022 08:03:07 GMT

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)

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

jthi — Wed, 01 Jun 2022 08:57:44 GMT

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);

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

lala — Wed, 01 Jun 2022 09:08:12 GMT

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]];