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
770
windgrid.cellchange can't get latest updated value?
posted

Hi all,

I have a windgrid showing recipe with the weight and percentage.

When users edit the weight, I need to recalculate the percentage and update the percentage cell. Some thing when the users edit the percentage.

I set the windgrid.UpdateMode = OnUpdate

When I edited the percentage by selecting all the value then press a number and the cellchange event is triggered, I get the below info.

e.Cell.Row.Cells("Percentage").Text = ""

e.Cell.Row.Cells("Percentage").Value= xx (original value)

Please let me know what I can do so that the value is always updated.

  • 71886
    Offline posted

    Hello engloon,

    It seems to me that you are making the recalculations too early, before the cell has accepted the new value. You might want to consider using the 'AfterCellUpdate' event in order to run your calculations.

    Please try the suggestion above and feel free to let me know if I misunderstood you or if you have any other questions.