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.

ExcelSelectionMarker and griddataboundgrid

Thread ID:

Created:

Updated:

Platform:

Replies:

41733 Mar 9,2006 07:43 PM Mar 10,2006 04:39 AM Windows Forms 2
loading
Tags: GridControl
Jenny Wilson
Asked On March 9, 2006 07:43 PM

I''ve been trying to implement your example of the ExcelSelectionMarker and am not having much luck. My intent was to implement this then add the AutoFill functionality. Will this work on a GridDataBoundGrid? One thing I''ve found is that I''m using a databoundgrid, and your example has made use of the SelectionChanging event, which is not available for this type of grid. Additionally, when I run your example, I drag the mouse over multiple cells - the cells are highlighted but the border does not change around these cells, and when I release the mouse, the highlighted cells becomes unhighlighted -- basically nothing happens. It would be helpful if you could provide any examples in VB instead of C#. Thanks.

Jenny Wilson
Replied On March 9, 2006 07:46 PM

My apologies -- I am able to get your example to work -- user error. I do still need to know if this will work with a data bound grid however. Thanks again. >I''ve been trying to implement your example of the ExcelSelectionMarker and am not having much luck. My intent was to implement this then add the AutoFill functionality. > >Will this work on a GridDataBoundGrid? > >One thing I''ve found is that I''m using a databoundgrid, and your example has made use of the SelectionChanging event, which is not available for this type of grid. > >Additionally, when I run your example, I drag the mouse over multiple cells - the cells are highlighted but the border does not change around these cells, and when I release the mouse, the highlighted cells becomes unhighlighted -- basically nothing happens. > >It would be helpful if you could provide any examples in VB instead of C#. > >Thanks.

Administrator [Syncfusion]
Replied On March 10, 2006 04:39 AM

Hi Wilson, The Excel like selection behavior illustrated in the ExcelSelectionMarker sample can also be implemented in the GridDataBoundGrid. In that sample the SelectionChanging event is handled to avoid selecting the first column and, is not needed to handle this event to get excel like selection behavior. But, still this event is there in the GridDataBoundGrid under the GridModel.   this.gridDataBoundGrid1.Model.SelectionChanging += new GridSelectionChangingEventHandler(Model_SelectionChanging); To get the Autofill functionality, the ExcelMarkerMouseController from the ExcelSelectionMarker sample can be used which, enables dragging at the bottom right corner of a cell and on release you can get the affected cell range. At this point you have to affect copying into the range using whatever algorithm you want to use to fill the expanded range. Best Regards, Calvin.

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.

;