Problem with Multi Range Selections.

Posted by: vkempanna on 8 September 2017, 12:56 pm EST

  • Posted 8 September 2017, 12:56 pm EST


    In my application i am using spread 3.0 for .net.

    I want to support MultiRange selection of the cells(Only Individual cells and not entire Row).

    I have set the setting as :

    SelectionBlockOptions :Cells, Rows, Columns, Sheet



    In cell click event if Right Mouse button is pressed,i have to set the cell which the user has clicked as the Active Cell.After this i try to get the range to cells selected.

    <FONT size=2>

    </FONT><FONT color=#008000 size=2>//Enables cell selection on Right Click.</FONT>

    <FONT color=#0000ff size=2>if</FONT><FONT size=2> (fpSpread1_Sheet1.Models.Selection.IsSelected(e.Row, e.Column) == </FONT><FONT color=#0000ff size=2>false</FONT><FONT size=2>)</FONT>

    <FONT size=2><FONT color=#008000>//set the cell which the user has clicked as the active cell.</FONT>

    {fpSpread1_Sheet1.SetActiveCell(e.Row, e.Column);}

    <FONT color=#008000>//Get the range of selection made.</FONT>

    FarPoint.Win.Spread.Model.</FONT><FONT color=#008080 size=2>CellRange</FONT><FONT size=2>[] crArr = fpSpread1_Sheet1.GetSelections();</FONT>

    The problem i am facing is:

    1:When ever i make selections on the last column in the spread ,and try to get the selections made,the crArr does not return any selections.However the crArr return valid selection when selection is made on other columns.

    2.When only one cell is selected the crArr does not return any selections.

    3.When a cell in last row is selected along with other cells,the crArr again does not return any selection.

    Can you please get the solution for this.

    I have attached the sample application for your reference



    <FONT size=2> 



  • Replied 8 September 2017, 12:56 pm EST


    Numbers 1 and 3 were bugs in an earlier release of Spread for Windows Forms. If you get the latest maintenance release, thes should be fixed. Number 2 is as designed. A selection is not made on one cell. If there is no selection, you can query the active cell to see the same information.

  • Replied 8 September 2017, 12:56 pm EST


    Thanks for the reply.

    Where can i get the latest Maintenance release.



  • Replied 8 September 2017, 12:56 pm EST


    You can go to and click on the Updates link on the left of the page to get to our updates section.

Need extra support?

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

Learn More

Forum Channels