Copy Columns - selected rows

hogi — Thu, 04 Jan 2024 15:04:21 GMT

Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table.

There is a hidden feature:
When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column.

So, when you select all rows before copying a column it's a very convenient way to .

On the other hand, if only a few rows are selected, the functionality leads to surprising results:

The first N rows of the new column get populated with the N selected values (!).

For formula columns, the command doesn't have an effect.

So, after copying a column and pasting it into a JSL script, generally my next task is: delete the Set Values(...)[together with the Set Selected ]. Or better: undo the first "paste" - deselect the rows - copy the column again and paste it without the Set Values() command.

On the third hand, I guess there is a cool use case for this functionality - but I have not found it yet ...

Any ideas?

(view in My Videos)

topic Copy Columns - selected rows in Discussions

Copy Columns - selected rows