Right Click Copy and Paste

Posted by: lg_sony_27 on 8 September 2017, 1:25 pm EST

  • Posted 8 September 2017, 1:25 pm EST

    Hi!


    I can use Ctrl C and Ctrl V in the spread already. I would like also to do the same operation by using mouse.

  • Replied 8 September 2017, 1:25 pm EST

    You can set up a ContextMenu with a Copy and Paste button on it and assign it to the spread and then use Spreads ClipboardCopy and ClipboardPaste methods.
  • Replied 8 September 2017, 1:25 pm EST

    this is what i did but its not copying and pasting.


    Dim custommenu As New ContextMenu


    custommenu.MenuItems.Add("&Copy")


    custommenu.MenuItems.Add("&Paste")


    FpSpread2.ContextMenu = custommenu


    FpSpread2.ActiveSheet.ClipboardCopy()


    FpSpread2.ActiveSheet.ClipboardPaste()

  • Replied 8 September 2017, 1:25 pm EST

    You have to add the handlers for the click events for the menu items and put the Clipboard code in those events.
Need extra support?

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

Learn More

Forum Channels