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
185
Column/Row freezing in UltraWinGrid exactly like in Excel
posted

Hi

I am using UltraWinGrid of Infragistics 2008 in my project. I want to hav the functionality of freezing rows/columns of the grid just like we can in Excel. For example, if I click on column 5 to be freezed, columns 1 through 4 should also get freezed. Similarly in case of 10 fixed columns, if I unfreeze column 3, then all columns from 3 till 10 should get unfreezed.

I am using the grids property to freeze/unfreeze columns/rows, but on freezing a column or row, this freezed column or row is moved to the front of the grid, which i dont want.

I have tried to generate such functionality in rows by fixing/unfixing the rows through looping in OnBeforeRowFixedStateChanged event of the grid. But because of looping within the grid, in case of a large dataset, say 10000, this method is not efficient.

It would be really helpfull if you can suggest any other way of having this functionality for Columns & Rows

Anoop

  • 53790
    posted

    Hello Anoop,

    Maybe one possible approach to achieve this behavior if you  handle ultraGrid1_BeforeColPosChanged() and set Fixed property of desired column`s ahead/before the frozen one. Please take a look at the attached sample for more details.
    Please let me know if you have any questions.
    Regards

    UltraGirdFreezeColumns.zip