Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2017 Operating System: Windows 10
Hello. I would like to copy and paste the multiple selected data cells, separated in a column(not a contiguous group of cells), to another column.
First, I can select the data cells with 'Ctrl' key. And If I select two cells, then copy and paste to another column, a group of worksheet cells is pasted, including the cells between the two cells I selected. the 'Shift' key has the same function when copying and pasting.
I want to copy and paste only the cells I selected.. Please Help...
I am very sorry - copy-and-pasting only the incontiguous cells was not yet implemented in the current version. That behavioral improvement alongside the better handling of missing values would be available in the coming Origin 2019, which would be published in this fall. We are sorry for the inconvenience. Please keep tuned. For now, let me consider if there is a possible work-around for your case.
The following sample snippet by utilizing masking may work as a work-around. This only works when the column has no masked cells. I'm sure there are better ways.
//////////////////////////////////////////
//Manually select the cells by CTRL+Click
//////////////////////////////////////////
//Extract selected cells in a column
//(The column originally shouldn't have masked cells.)
range r1=col(1); //Input column
range r2=col(2); //Output column
menu -e 35536; //Mask selected cells
jj=0;
for(ii=1; ii<=r1.getsize(); ii++) { //Loop over rows
if(r1<ii>==1) { //Is masked?
jj++; //Increment output#
r1<ii>=0; //Reset mask
r2[jj]=r1[ii]; //Output the cell value
}
}
////////////////////////////////////////////////////
Copy and paste of multiple selected data cells
Posted - 06/27/2018 : 06:26:06 AM
