Auto-fill (flood-fill) and Advanced Cell Selection

[Kevin]

I enjoy the blog posts and forum examples both from Telerik employees and their customers, and was wondering if there are any examples of the following for the RadGrid:

Autofill functionality:  In Excel, a user can select a cell.  The cell will then show a small box in the bottom-right corner.  Dragging that box onto other cells will auto-fill (flood-fill) the value of the orginal cell.  I imagine this can be done with a custom cell style and some mouse/drag events, but thought a blog or forum post demonstrating this would be excellent.

Multi-row selection when Cell SelectionMode = SelectionMode.Extended:  When the grid's selectionMode is Extended, the user can select a range of cells, but not a range of entire rows.  I also imagine this could be accomplished by hooking into mouse events on the row header cells and programatically selecting all the cells for the rows that should be selected.

Telerik, are there any blog posts for these, or could we get some, since a lot of users could gain value?  Other customers, have you done anything like this?

[Milan]

Hello Kevin,

The AutoFill functionality is not trivial to implement and we currently do not have any examples. Nevertheless I will try to implement something similar and I will notify you ass soon as I make any progress.

Regarding mixed mode selection, currently it is not supoprted by the grid but you could take a look at the attached application which enables Cell or Row selected depending on the context - if you click on row header you will engage row selection; if you click on a cell you will engage cell selection.

Hope this helps.

Greetings,
Milan
the Telerik team

[Brian]

Milan

Do you have any update on autofill functionality. We also need that functionality 


Brian

[Milan]

Hello Kevin,

I did send some time researching this but unfortunately it is almost impossible to have this working correctly in RadGridView. For example, scrolling when doing autofill would be impossible and I guess you would need this working. 

In general, this is a feature that is available for spreadsheet components and the data grid is built to behave differently. We have plans to introduce spreadsheet control but it is still unclear when we will be able to do so. 

Best wishes,
Milan
the Telerik team