paste row set value hidden column

[luckduck]

Hi,

Will the values be set only for visible columns when pasting?

I want to set the value in the hidden column of the line I added by paste in the tree grid.

[paramvir]

Values are pasted in hidden columns too.

[luckduck]

Thanks you very much for your reply.

I do not want to paste the data in the entire column, but I want to paste some column data and set the values in the remaining columns.

[paramvir]

Sorry I don't get your question. Could you please elaborate it.

What are the values in the clipboard?

Values are pasted on the destination columns depending upon the number of columns in the clipboard and number of selected columns. In your screenshot, only first column is selected, hence values are pasted in that column only.

[luckduck]

I copied and pasted only the item "ITEM" as shown in the screenshot, and I want to create the key "groupCd" item as a separate logic.

1. Copy ITEM items from Excel.
2. Paste it into the ITEM column of the grid.
3. Grid rows are added as much as the pasted ITEM.
4. The values of other columns in the pasted row are automatically set according to the value of "ITEM".

Can I use "paste" or "beforePaste" to set values in columns like "updateRow"?

[paramvir]

oh ok, got your question.

Dependencies between columns can be setup easily with js formulas.

Please check this demo:

https://paramquery.com/pro/demos/grid_formula

Values in formula columns are automatically updated, no need of beforePaste, paste events.

[luckduck]

I solved the problem thanks to you.