Copy / Multi paste and Control+Enter . .

[Adam K.]

Okay . . i am continuing to have this issue and its becoming a serious issue for my application in both cases i am setting the same value into multiple cell, case 1 via the Clipboard paste event and case two during the CurrentCellKeydown event. I have reported this before and i can reproduce this in the example file from: http://www.syncfusion.com/Support/user/uploads/VirtualGrid_49952bec.zip I have taken the sample and added my code to show you how i am doing the Control+Enter (attached file). It seems the control+enter case is actually a more effective way to reproduce the error. I you create 10 rows and highlight all rows in 1 column and enter a value and click Control+Enter, all the data updates almost immediately (just like excel) but if you try to move to the next cell via the arrows keys, it takes sometimes up to 4-5 seconds before it moves. It stays on the currrent set of highlighted rows. I keep clicking on the Right Arrow key and sometimes i can click 10 times before it actually moves to the right. Try to do this in Excel and its instantaneous. Any suggestions would be greatly appreciated. thks, ak

VirtualGrid4.zip

[Administrator]

Hi Adam,

Please refer to the modified sample attached that is working fine, let me know if this helps.
Here is a sample
http://www.syncfusion.com/Support/user/uploads/VirtualGrid41_baf3eb14.zip

Regards,
Rajagopal

[Administrator]

in my case i only have 1 row so this doesn''t work.. also moving to the left and down when you hit enter is not the expected behavior.

Why can''t it commit and stay in the same cell but not freeze up so i can move left immediately after the data commits. This is basic excel behavior.

please advise.

thks,
ak

>Hi Adam,
>
>Please refer to the modified sample attached that is working fine, let me know if this helps.
>Here is a sample
>http://www.syncfusion.com/Support/user/uploads/VirtualGrid41_baf3eb14.zip
>
>Regards,
>Rajagopal

[Administrator]

Hi Adam,

Try calling the CurrentCell''s EndEdit() and Reactivate() method in the CurrentCellKeyDown event, this will help.
Please add the code below in the CurrentCellKeyDown event of the grid, this resolves the problem.

if (e.KeyCode == Keys.Enter)
{
if( cc.RowIndex == this.gridControl1.RowCount && cc.ColIndex == this.gridControl1.ColCount )
{
this.gridControl1.CurrentCell.EndEdit();
this.gridControl1.CurrentCell.Reactivate();
}
}

Also, set the EnterKeyBehavior property to Down, which will give the default excel behavior. This property defines the movement of the current cell when pressing the enter key.

this.gridControl1.Model.Options.EnterKeyBehavior = GridDirectionType.Down;

Take a look into the attached sample for more details.
http://www.syncfusion.com/Support/user/uploads/Virtual_Mod_2b01580a.zip

Let me know if you have any other questions.
Regards,
Rajagopal