Auto Fill Options

[Administrator]

Hi,

Is there a way to enable the Auto Fill Option known from Excel in a GridDataBoundGrid.

Auto Fill Option in Excel:
1.Select a single cell.
2. move the cursor right, bottom corner of the cell. The cursor will change into a + (plus) sign.
3. Hold down the left-mouse button at drag the mouse down.
4. Release the left-mouse button. Voila a number of cells are filled with the same value as the initial cell.

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