Using Excell like options and data fill

[Todd Armstrong]

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.

[Administrator]

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

[Todd Armstrong]

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

[Jonas Wilkstrom]

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 > >

[stanleyj]

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