ExcelLikeCurrentCell & ExcelLikeSelectionFrame & grid.selections.count

[Philip Bishop]

I found on ur forum once that if u wanted to tell if u have more then one cell selected that u could use the grid.selections.count property for this. I only want the user to be able to go to another form by either double clicking the cell or a button but only if they have JUST ONE cell selected. So in the past I checked the grid.selections.count and if only one cell was selected it would return a zero. if you selected say 2 cells in one range it would return a one and i would know they had some sort of a range. if they selected 2 cells not in a range it would return a 2. so i figured out as long as it was zero there was only one cell. so this worked fine until we decided to turn on the ExcelLikeCurrentCell & ExcelLikeSelectionFrame. When that is on and when u selected ONE cell the selections count is now one? So this is where I am confused. Should it of always been one? Was this wrong and is now corrected? The big one to me is why is this different if these 2 properties are set to true or false? Maybe there is another way I can check for just one cell being checked but this was working great but now after turning those to properties to true it doesnt act the same?? Again now if i select 2 cells in a range with those properties set to true it returns 1 which i would assume is is correct but again why is it diff when these are set to false. I think there is some sort of a bug here and also think now I am going about trying to figure if more then one cell, range or not, has been selected..I have attached a sample. Select one cell one grid and push its button and look at the text box which is the count and do the same for the other grid. Thanx Phil selections.count_9396.zip

[Administrator]

Hi Phil, This is by design. If you have ExcelLikeCurrentCell & ExcelLikeSelectionFrame set to true, the grid will consider the current cell to be selected. If you want the consistent behavior like the ExcelLikeCurrentCell is set to false, you can check whether the selection has only the currentcell and can decrement the count by 1 to handle this case. Here is some code snippet.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
TextBox1.Text = (GridControl1.Selections.Count).ToString()
If (GridControl1.Selections.Count = 1) Then
Dim range As GridRangeInfo = New GridRangeInfo
range = GridRangeInfo.Cell(Me.GridControl1.CurrentCell.RowIndex, Me.GridControl1.CurrentCell.ColIndex)
If (Me.GridControl1.Selections.Ranges.ActiveRange.Equals(range)) Then
TextBox1.Text = (GridControl1.Selections.Count - 1).ToString()
End If
End If
End Sub

Attached is the sample. Thanks. Jay N selections.count_2975.zip

[Philip Bishop]

am i doing this right in the first place??is this the best way to tell that ONLY 1 cell is selected..Not one range, just ONE CELL
. I just want to know that there is eithe r ONE cell selected or more then one cells selected, ranges or not

[Administrator]

Hi Phil,
The currentcell will not be a part of the selection when the ExcelLikecurrentcell is set to false. The selectioncount will be zero in this so you can rely on this approach.

Regards,
Jay N

[Philip Bishop]

i think i''m not explaining myself well enough. i want the excel properties set to TRUE. so i asked is this the only way to tell if one cell is selected like u gave me in that sample or is there an easier way

[Administrator]

Hi Phil,
This is the way to tell whether one cell is selected. The code just checks whether the current cell is in the selected range.

Regards,
Jay N