GrapeCity Forums

Hi,

We have need to paste a single data item ti multiple cells like excel does. I want to implement functionality of Pasting data from clipboard to cells being selected by hovering mouse on the spread for ASP.NET. I am not sure if this is already has been answered in these forums here.

Thanks,

Vinod

Hello,

There is no any direct method or property available to paste a single value to multiple selected cells.You would need to write code for paste for every selected cell.I have written a server side code that might give you an idea about how to do so, you might need to write code on client side as clipboard is not accessible server side.

 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim row, row2, col, col2 As Integer

        row = FpSpread1.ActiveSheetView.SelectionModel.AnchorRow

        row2 = FpSpread1.ActiveSheetView.SelectionModel.LeadRow

        col = FpSpread1.ActiveSheetView.SelectionModel.AnchorColumn

        col2 = FpSpread1.ActiveSheetView.SelectionModel.LeadColumn

        FpSpread1.ActiveSheetView.Cells(row, col, row2, col2).Text = Text

    End Sub 

 Thanks,