I have some cells selected ... how do I set the values of those cells?

galactus3000 — Fri, 16 Nov 2018 15:52:10 GMT

I have a script which has already selected a set of cells.

Now I want to set those cells to have a certain value, say 6.3201

why doesn't the following work?

set selected cells(6.3201);

I know how to select the cells and don't need help with that

I need help with how to take a group of selected cells and simple want to place a value in them

thanks

Re: I have some cells selected ... how do I set the values of those cells?

txnelson — Fri, 16 Nov 2018 16:00:34 GMT

Assuming the selected cells are all in the same column, and let's say the column is named "X", you would set the values
X[ dt<<get selected rows ] = 6.3201;

I am also assuming that you have specified prior to the above:
dt = current data table();

topic Re: I have some cells selected ... how do I set the values of those cells? in Discussions

I have some cells selected ... how do I set the values of those cells?

Re: I have some cells selected ... how do I set the values of those cells?