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

autofill

how can I replicate the excel behaviour while dragging down the selected area from the left bottom corner of selection?

1 Reply

AD Administrator Syncfusion Team May 2, 2003 04:42 AM

Take a look at the Syncfusion\Essential Suite\Grid\Samples\In Depth\ExcelSelectionMarker sample. In that sample, if you position the cursor over the bottom right corner of a cell or selection, you get a special drag cursor that allows you to expand the selection by dragging. When you release the drag, in the sample a message box pops up that gives you the range selected. At that point, you could do your auto-fill. Now the sample does not actually do the autofill, but depending on what you want to do, you could use grid.ChangeCell to change the whole range to have the same style as the top left cell. Or, you could just loop through the range, explicitly setting values in some logical way depending upon what you want.

Loader.
Live Chat Icon For mobile
Up arrow icon