We want to implement something similar to Excel functionality in a (WPF) .NET application in gridview or any other control. The functionality should be the same as in Excel, where the user can select a cell and drag the mouse down to the desired row (number), and the value of the first row will be copied to all selected rows (drag and drop values).
Does anyone know if this is possible? I spent a lot of time searching on Google and did not find anything useful.
It would be easier to write VSTO for Excel, but we have a lot of (inherited) VBA code and current tests of VSTO worksheets, and add-ons return “mixed” results, while mixing VSTO and VBA is not the best solution for us.
EDIT: credit decision can also be mentioned. :)
source share