activate row in FpSpread spreadsheet

Posted by: yuriy-fp on 8 September 2017, 3:04 pm EST

  • Posted 8 September 2017, 3:04 pm EST

    How to set row in spreadsheet to be selected without setting cell active when user click on cell in spreadsheet.


    Thanks,


    Yuriy

  • Replied 8 September 2017, 3:04 pm EST

    Hello,

    You can use the CellClick event to cancel the default operation of setting the selected cell as active cell and rather select the row when the cell is clicked. Please have a look at the attached sample that fulfills your requirement. Hope it helps.

    Thanks,

    Manpreet Kaur


    2013/02/SelectRow.zip
  • Replied 8 September 2017, 3:04 pm EST

    Yuriy,

    You may set the Operation mode for Spread sheet to RowMode if you want the complete row to be selected on a click. Here is how you can do that:

    fpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.RowMode;

    Thanks,

  • Replied 8 September 2017, 3:04 pm EST

    Yes,  but what I want  is  to allow user select row and in the sane time do not allow cell  to be activated :  user click cell in row --.> row selected and cell not.


     


    Thanks,


    Yuriy

  • Replied 8 September 2017, 3:04 pm EST

    Thanks, it works.
Need extra support?

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

Learn More

Forum Channels