Mapping of 'OLEDragDrop' event of COM Spread 7 into Farpoint Spread 5.0 (.Net)

Posted by: sagefahad on 8 September 2017, 2:38 pm EST

  • Posted 8 September 2017, 2:38 pm EST


    I am migrating my application from COM Spread 7
    to Farpoint Spread 5.0 (
    .Net). Earlier, when a particular file is Drag and Droped onto the spread, I used 'OLEDragDrop' event of COM Spread 7 to open this particular file. Now,
    'OLEDragDrop' event is no more available in Farpoint Spread 5.0, so how could i achieve the same functionality.


    Thanks for help in advance.

  • Replied 8 September 2017, 2:38 pm EST


    You have to set AllowDrop= True in order to Spread support .Net Drag and Drop events.

    You may perform your action under fpSpread1_DragDrop event.







  • Replied 8 September 2017, 2:38 pm EST


    Thanks for the help.

    I have resolved the issue as per above mentioned worthy directives. But in addition to these directives, i have also added code in fpSpread1_DragEnter event as under:

     Private Sub FpSpread1_DragEnter(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles FpSpread1.DragEnter
        If (e.Data.GetDataPresent(DataFormats.FileDrop)) Then
          e.Effect = DragDropEffects.Copy
        End If
      End Sub

     It is necessary as fpSpread1_DragDrop event is not triggering in absence of above mentioned code.


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels