We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

General Excel Like Behaviour

Thread ID:





67872 Sep 3,2007 04:13 PM UTC Oct 26,2007 02:36 PM UTC WinForms 5
Tags: GridControl
Asked On September 3, 2007 04:13 PM UTC


Are there any good examples or reusable code stubs that I can use to make the Grid control behave more like Excel.

The following is a list of general excel like behaviour that I would like to reproduce.

1: Control + Arrow keys - moves cell cursor to the cells bordering the transition between contiguous blocks of filled and empty cells(have managed this one to a certain extent).
2: Control + Shift + Arrow keys - similar to the above but allows selection of blocks of cells rather than just navigation.
3: Excel like formulae entry - automatic closure of brackets, navigation / selection of blocks of text when using Ctrl key / Shift + Ctrl key etc...
4: Multiple entry of values when selecting range of cells and entering Ctrl + Enter.

In general, I want to implement as much Excel Like behaviour as possible. Some of this should be boilerplate code for most implimentations of the grid control - is there a repository somewhare?

Replied On September 5, 2007 04:18 PM UTC

Any ideas?

Rajagopal [Syncfusion]
Replied On September 5, 2007 11:11 PM UTC

Hi Steve,

Thanks for your interest in Syncfusion Products.

You need to have a custom MouseController that AutoFills similar to the Excel. If you mouse hover at the bottom right corner of the cell, a cross cursor appears similar to the Excel and you can extend the selection to AutoFill the up/down rows similar to the Excel.

Please check the below sample for more details.

Please refer our shipped browser samples for forumula support with grid simliar to excel

To have multiple range of cells getting pasted on pressing enter, you need to handle the CurrentCellKeyDown event. Please refer the below sample that shows this working fine similiar to excel.


Let me know if you have any other questions.
Thanks for your patience.


Replied On September 6, 2007 06:11 AM UTC

THanks - I will look into the demos you have supplied.

James Blibo
Replied On October 6, 2007 07:05 AM UTC

Will this excel drag example work for the grid grouping control?

Jeba S [Syncfusion]
Replied On October 26, 2007 02:36 PM UTC

Hi James,

Sorry for the delay in response.

The ExcelLikeSelection behavior and the Excel Selection Marker behavior are particulary designed for GridControl not for GridGroupingControl.

Kindly let us know if you need any further assistance.

Best Regards,


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon