How can i have multi cell selection like in excel

Posted by: dhan-fp on 8 September 2017, 12:33 pm EST

  • Posted 8 September 2017, 12:33 pm EST


    I'd like to reproduce one way or another the behaviour found in excel for multiple cell selection, and that is by pressing ctrl key and clicking or draging a cell you can have multiple cell selection. Using the farpoint spread i could have this behaviour for rows
        spread.ActiveSheet.OperationMode = OperationMode.MultiSelect;
        spread.ActiveSheet.SelectionUnit = SelectionUnit.Row;
    but not for cells
        spread.ActiveSheet.OperationMode = OperationMode.MultiSelect;

        spread.ActiveSheet.SelectionUnit = SelectionUnit.Cell;
    Using the last two lines of code i get the same behaviour as for the row selection unit, though selection block options is set just to cells either ways

    Am i doing something wrong, or this behaviour is not supported and i have to programatically implement it?

  • Replied 8 September 2017, 12:33 pm EST


    You would need to leave the OperationMode at Normal and set the SelectionPolicy to MultiRange to get the behavior you are looking.

Need extra support?

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

Learn More

Forum Channels