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

    <div class="ForumPostBodyArea">
    <div id="_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl1_PostViewWrapper" class="ForumPostContentText">
    <div class="ForumPostBodyArea">
    <div id="_ctl0__ctl1_bcr__ctl0___PostRepeater__ctl1_PostViewWrapper" class="ForumPostContentText">

    <font size="2"><span style="FONT-FAMILY:'Verdana','sans-serif';FONT-SIZE:10pt;">Hi,</span><span style="FONT-SIZE:10pt;"></span></font>

    <font size="2"><span style="font-family:'Verdana','sans-serif';font-size:10pt;">I am migrating my application from COM Spread 7</span><span style="font-family:'Verdana','sans-serif';">
    to Farpoint Spread 5.0 (</span><span style="font-family:'Verdana','sans-serif';">.Net</span><span style="font-family:'Verdana','sans-serif';">). Earlier, when a particular file is Drag and Droped onto the spread, I used 'OLEDragDrop' event of </span><span style="font-family:'Verdana','sans-serif';font-size:10pt;">COM Spread 7</span><span style="font-family:'Verdana','sans-serif';"> to open this particular file. Now, </span></font><font size="2"><span style="font-family:'Verdana','sans-serif';">'OLEDragDrop' event is no more available in Farpoint Spread 5.0, so how could i achieve the same functionality. </span></font>

    <font size="2"> </font>

    <font size="2"><span style="font-family:'Verdana','sans-serif';">Thanks for help in advance.</span></font>


  • 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