autofill

[Dan Roman]

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

[Administrator]

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.