AutoFill / Copy Paste | Infragistics Forums

3555

AutoFill / Copy Paste

Patrick posted over 16 years ago

Is this possible and if so, can someone point me in the right direction.

I need to replicate the copy / paste functionality like in excel.

For example: If a user copies on cell value and then he selects multiple
cells and then paste it should paste the copied value to all of the cells.

Also, I need the abilty to copy to cells that are selected using the ctrl
key (a non contigious paste).

My grid also needs to be able to copy and paste from excel, but this should
not conflict with the above functionality.

THanks.

Parents

469350

Verified Answer
Offline Mike Saltzman posted over 16 years ago

Hi,
The AllowMultiCellOperation property on the Override turns on cut, copy, paste, and delete functionality in the grid. I'm not sure if it's exactly the same as Excel - it probably has some limitations that Excel doesn't have, since WinGrid is a data grid and not a spreadsheet. But there are also events that fire when you perform these operations, so you might be able to alter the behavior to your liking.
Cancel
Reply

Reject Answer

Cancel

Reply

3555

Patrick posted over 16 years ago in reply to Mike Saltzman

Mike,

I am getting the following error when I copy one cell and paste to multiple
cells throughout the grid (selected using the ctrl key)

Paste Error: Invalid Selection. The selection must be rectangular.

Can you let me know how would I go about implementing this custom paste
functionality? Which events should I utlize?

wrote in message news:10641@news.labs.infragistics.com...
> Hi,
>
> The AllowMultiCellOperation property on the Override turns on cut,
> copy, paste, and delete functionality in the grid. I'm not sure if it's
> exactly the same as Excel - it probably has some limitations that Excel
> doesn't have, since WinGrid is a data grid and not a spreadsheet. But
> there are also events that fire when you perform these operations, so you
> might be able to alter the behavior to your liking.
>
Cancel
Reply

Cancel

Children

37774

Matt Snyder posted over 16 years ago in reply to Russel

Russel,
You would be better off posting this in the WebGrid forum instead.
-Matt
Cancel
Reply

Cancel
40

Russel posted over 16 years ago in reply to Mike Saltzman

Hi,

How can I accomplish the same functionality in a UltraWebGrid ? Right Click copy paste . One way, is to set ReadOnly = Level2, but this breaks paging and grouping in the grid.

Thanks

Russel
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 16 years ago in reply to Patrick

Hi,
Umm... Maybe I was wrong about the "After" event, but the BeforeMultiCellOperation definately exists. I thought it was added along with the AllowMultiCellOperation property, but I suppose I could be wrong and maybe the event was added in a later release, but I don't think that's the case.
Cancel
Reply

Cancel
3555

Patrick posted over 16 years ago in reply to Mike Saltzman

I do not see the events Before/After MultiCellOperation anywhere...

I basically want the same thing as your sample webgrid Working With Excel
(Copy Paste and Export)

Located here..

http://samples.infragistics.com/2007.3/webfeaturebrowser/default.htm
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 16 years ago in reply to Patrick

Hi,
I beleive there are events like Before/After MultiCellOperation in which you can alter the data or the behavior.
Cancel
Reply

Cancel