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. Image for the cookie policy date

Using Excell like options and data fill

In a databound grid, I have set ExcelLikeCurrentCell and ExcelLikeSelectionFrame to true. I would like to be able to drag a cell like Excel to perform a fill of the column. Is that possible? If so, how? Thx.

4 Replies

AD Administrator Syncfusion Team January 4, 2005 01:42 AM

This sample shows how to drag the lower right corner of a selection to start a fill operation. It also raises an event showing the target range. But it does not actually do anything to the range to try to fill it. You would handle this event and fill the target using whatever algorithm you wanted to determine the fill contents. Grid\Samples\In Depth\ExcelSelectionMarker


TA Todd Armstrong January 4, 2005 11:06 AM

Clay, Thanks very much. I modified this sample to work with a GridDataBoundGrid as well. If you look at the modified attached, you can see how I applied to perform the drag and fill. Thx, Todd >This sample shows how to drag the lower right corner of a selection to start a fill operation. It also raises an event showing the target range. But it does not actually do anything to the range to try to fill it. You would handle this event and fill the target using whatever algorithm you wanted to determine the fill contents. > >Grid\Samples\In Depth\ExcelSelectionMarker > > ExcelMarker_9478.zip


JW Jonas Wilkstrom February 15, 2006 04:58 AM

Hello Todd and Clay When using these examples I would like the delete button to work in the same manner as in a regular select. >Clay, > >Thanks very much. I modified this sample to work with a GridDataBoundGrid as well. If you look at the modified attached, you can see how I applied to perform the drag and fill. > >Thx, > >Todd > >>This sample shows how to drag the lower right corner of a selection to start a fill operation. It also raises an event showing the target range. But it does not actually do anything to the range to try to fill it. You would handle this event and fill the target using whatever algorithm you wanted to determine the fill contents. >> >>Grid\Samples\In Depth\ExcelSelectionMarker >> >> > > > > > >ExcelMarker_9478.zip > >


ST stanleyj Syncfusion Team February 16, 2006 05:36 AM

Hi Jonas, In the attached sample you will find a similar try to get the dragged ranges filled, additionally selecting the filled ranges helps to delete the selection. Let me know if you are looking something different. Look for GetDraggedRangesFilled function of the class ExcelMarkerMouseController in the sample. Forum_23046.zip Best regards, Stanley

Loader.
Live Chat Icon For mobile
Up arrow icon