Row/Cell Operation

Posted by: jemid on 8 September 2017, 12:32 pm EST

  • Posted 8 September 2017, 12:32 pm EST

    Hi,
    I have a contextmenustrip attached to a spread control what I am doing now is that i have the outoClipboard property set to false, and I can delete a row and a column based on  a users selection but how can I:
    Separate behavior of keyboard and right click menu based on context(i.e  how would I now if the user is in a cell)
    When a cell gets focus I want to select the value.
    When cell is selected can you select the value to change, cut or paste?
    When cell is selected delete key deletes the value in the cell, not the row?
    When right clicking, can we contextually ‘add row above’ or  ‘add row below' (right now I am only doing and insert and it seems to add a row above)
    Thanks

    Jemi
  • Replied 8 September 2017, 12:32 pm EST

    Jemi,


    To have the data in the row selected when you click a cell, you can set the EditModePermanent and EditModeReplace properties to Trus. If you want to add a row below the active row, then call the insert method on the row under the active row. If you are at the last row already, then just increment the RowCount property by 1.

Need extra support?

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

Learn More

Forum Channels