Mike / Michael, thanks for looking into this for me.  I think the summary might be confusing things a little but I'll come back to that.  So if deferred calcs are:

- TRUE - then when I click the add row the formula in column d is prefilled with a 0 and works should you enter a value in column a and tab to column b, you don't need the row to be added full.  Editing existing rows work the same.

- FALSE - then when I click the add row the formula in column d doesn't get prefilled or work until the row is actually added to the grid fully.  However, editing an existing row then changes in d are immediately apparent on leaving a cell but without leaving the row

If I didn't care about the summary I could just change the deferred calcs to TRUE and all would be well.  However, I'd like a summary at the top showing the summary of all rows not just those visible initially or that have been scrolled into view.  To do this I need to set deferred calcs to FALSE.

I think this makes my requirements a bit clearer but if not let me know.  As I say there may be some combination of something I'm missing or I might be going about things in the wrong way.

Thanks in advance for your thoughts.

weejock said:

- TRUE - then when I click the add row the formula in column d is prefilled with a 0 and works should you enter a value in column a and tab to column b, you don't need the row to be added full.  Editing existing rows work the same.

- FALSE - then when I click the add row the formula in column d doesn't get prefilled or work until the row is actually added to the grid fully.  However, editing an existing row then changes in d are immediately apparent on leaving a cell but without leaving the row

That's the same behavior I get with your sample.

DeferredCalculations just means that the grid will defer calculations that are out of view. It's a performance tweak so that the grid gives preference to the calculation of formulas that are visible on the screen. So when it's true, the grid gives top priority to the formulas that the user can see, which includes the TemplateAddRow. When it's false, I can only assume that there are other calculations taking place and since the TempalteAddRow is not a priority, it's getting put off, but will eventually be calculated. This doesn't really make sense, though, since you don't have a huge number of rows in your sample and the TemplateAddRow should probably be calculated almost immediately, anyway. So I think there's probably a bug there.

weejock said:

If I didn't care about the summary I could just change the deferred calcs to TRUE and all would be well.  However, I'd like a summary at the top showing the summary of all rows not just those visible initially or that have been scrolled into view.  To do this I need to set deferred calcs to FALSE.

If the summary is being calculated based on only what is in view, then something is wrong. That should never happen - or at least it should not be based on DeferredCalculationsEnabled. DeferredCalculationsEnabled should only affect WHEN the formulas are calculated, it should not have any effect on the calculation results.

Mike, where does that leave us then?  If it's a bug do I need to report this somewhere or is it something you will pick up and if so how do I track it?

Cheers

Hello, 

This property is causing issues on form load.

As a test, I was able to get the expected behavior by changing the deferred calc to true within the BeforeEnterEditMode event. With the sample you provided, the property needs to be false in the designer initially, then wait for the form and calculation to load the data correctly. After which you can set the property back to true to get the expected behavior. 

Private Sub UltraGrid1_BeforeEnterEditMode(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles UltraGrid1.BeforeEnterEditMode
UltraCalcManager1.DeferredCalculationsEnabled = True
End Sub

OK, thanks Michael, I'll keep an eye on the development issues you've created.