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