Modify Copied Column From pqgrid Before Paste

[Punit]

Hi Paramquery team,

We want to implement excel tagging functionality in which we try to copy multiple columns from the bind excel pqgrid and want to modify or skip some copied columns from the copied columns before the paste event and then paste on the second grid. Is there any way to achieve this? We tried to add some manually copy and paste event lister but it messes with some pqgrid functionality.

Thank you!

[paramvir]

Hi Punit

Skipping columns while copy or skipping column while paste are explained in this example: https://paramquery.com/pro/demos/copy_paste

[Punit]

hi
We want to skip copied column text before paste not want to skip column while pasting.

EX. If I copy 1 2 3 from grid1 then I want to skip 2  and paste only 1 3 in grid2 column.

[paramvir]

Ok, then may I know the reason for including column 2 in copied data when you have the option to skip column 2 while copying data?

[Punit]

Hi Paramquery team,
Is it possible to skip a column while copying conditionally? or it is skipping only hidden columns?

[paramvir]

yes it's possible to skip columns while copying conditionally in run time. Skipping hidden columns is just an example.

[Punit]

How to get all copied column lists or the number of copied columns while copying from grid1. WE get one by one copied text not all copied text at the same time.

[paramvir]

Sorry there is no way to get the copied data while copying currently.

[Punit]

Hi,
I am trying to skip the second column by the counter. If Counter == skipCoumnValue (which is 1) then it not skipping the value. Can you please tell me what we doing wrong below code?


 columnTemplate: {
                    get [index == 0 ? 'copy' : 'paste']() {
                   
                        if (counter == skipCoumn) {
                            counter = (parseInt(counter) + 1);
                            return ;
                        }
                        else
                            counter = (parseInt(counter) + 1);
                    }
                }

[paramvir]

How did you get the value of counter? Please debug your code to find out its value.

And copy getter should return false to skip the column while copying.

[Punit]

Hi,
Is there any way or event that executes after a complete copy event?. I want to reset the counter after columnTemplate event.

[paramvir]

There is no copy related event. May I know what you are trying to do.

[Punit]

We are developing excel mapping functionality in which users are able to skip some columns from a financial excel sheet. So I am skipping columns conditionally by increment counter. I want to Reset this counter after the complete copy event.

[paramvir]

What is the condition for skipping columns from end user perspective.

[paramvir]

Often there are multiple ways to solve the same problem.

So what I'm asking is what is the end user requirement you are trying to solve so that we find an alternative solution.