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.
//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.
//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