I have a grid with multiple columns but only two columns cells can be edited the rest of the columns cannot be. The two columns are both check editors. They can select any of the cells in the column but I want to limit them to only selecting cells in a single column at time. For instance, if the two columns are Active and Inactive the user should be able to select cells in Active or Inactive just not at the same time. I was also wondering if there is a way to only allow certain summaries. For instance, a string in my case doesn't need to have average etc. but we would like for the end user to be able to select count which in some cases is very useful.
I was hoping for a property but I could not find one. I thought about doing something similar to attached project sample. I will implement this and see how it goes. Thanks.
Should I make a separate post for the summary question?
Hello Michael,
I have been investigating into your requirement to limit the UltraGrid selection to cells from one column at a time, and I would recommend taking a look at the attached sample project.
There is no dedicated property for this, but you can utilize the BeforeSelectChange event of the grid to check the cells that are coming in versus the ones that are already selected and check the Column of each for differences. This event is cancellable, and when cancelled, the cells that were going to be selected will not be.
Please let me know if you have any other questions or concerns on this matter.
UltraGridSelectFromOneColumn.zip