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.
Unfortunately, activation email could not send to your email. Please try again.

General Excel Like Behaviour

Thread ID:

Created:

Updated:

Platform:

Replies:

67872 Sep 3,2007 12:13 PM Oct 26,2007 10:36 AM Windows Forms 5
loading
Tags: GridControl
steve_randomno
Asked On September 3, 2007 12:13 PM

Hi,

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?

steve_randomno
Replied On September 5, 2007 12:18 PM

Any ideas?

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

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.
http://www.syncfusion.com/Support/user/uploads/AutoFill%20Non-Contiguous%20Selection_8b754fbd.zip

Please refer our shipped browser samples for forumula support with grid simliar to excel
\\Syncfusion\EssentialStudio\5.2.1.16\Windows\Grid.Windows\Samples\2.0\FormulaSupport\

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.

http://www.syncfusion.com/Support/user/uploads/GC_ScrollIssue_64b6f6f1.zip

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

Regards,
Rajagopal

steve_randomno
Replied On September 6, 2007 02:11 AM

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

James Blibo
Replied On October 6, 2007 03:05 AM

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

Jeba S [Syncfusion]
Replied On October 26, 2007 10:36 AM

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,
Jeba.


CONFIRMATION

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.

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.

;