Problem with Multi Range Selections.

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

  • Posted 8 September 2017, 12:56 pm EST

    Hi,


    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


    OperationMode:Normal


    SelectionPolicy:MultiRange.


    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.


    //Enables cell selection on Right Click.


    if (fpSpread1_Sheet1.Models.Selection.IsSelected(e.Row, e.Column) == false)


    //set the cell which the user has clicked as the active cell.


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


    //Get the range of selection made.


    FarPoint.Win.Spread.Model.CellRange[] crArr = fpSpread1_Sheet1.GetSelections();


    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


    Regards


    Vinutha


     


     


    2007/12/MultiRangeSelection.zip
  • Replied 8 September 2017, 12:56 pm EST

    Vinutha,


    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

    Scott,


    Thanks for the reply.


    Where can i get the latest Maintenance release.


    Regards


    Vinutha

  • Replied 8 September 2017, 12:56 pm EST

    Vinutha,


    You can go to www.clubFarPoint.com 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