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
20
Preserve Visible Rows
posted

Background:

Example of Grid structure -

ID Non-editable Editable Editable Calculated Calculated

When an editable cell is changed, the grid refreshes and updates the calculated field (the values in the calculated field are dependent on another grid).

Problem:

When the grid refreshes, it closes groupings and/or scrolls back to the top of the grid.  If there are 12 months worth of data in 5 different groupings, and the user is updating all 12 months, they need to scroll the grid back to where it was to update the next row which is frusterating.

Is there any way to hold the rows that are visible when the AfterCellUpdate fires and reassign those visible rows to the grid after it refreshes in order to maintain the grid position?

Thank you for any help that you can provide with this.

  • 17259
    Offline posted

    You can do it by saving the rows states somewhere with an id for each row that will allow you to recognize the row after refresh. Also save the id of grid.ActiveRowScrollRegion.FirstRow. After refresh, go through the row and set their state as before, and set the FirstRow to be the row with the same id of he previous FirstRow.