Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1871
Limit selected to cells to one column at a time.
posted

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.

Parents
  • 34810
    Verified Answer
    Offline posted

    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

Reply Children