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.

Hi,

If the Deffered Calcs FALSE case is not working, then it could be that the fix didn't make it into the latest service release. I thought it did because I asked Developer Support to try it out and they couldn't reproduce the issue, but I could be wrong - in which case it will be fixed in the next SR.

For the TRUE case, are you running the new sample I attached here with my last post? That sample works for me in every version I tried. I even went back to 11.2 just to be sure. The workaround I provided here should work regardless of what version you are using. I suppose it's possible that there is some fix in my internal version that's making it work for me and that you don't have, but it seems extremely unlikely.

Mike,

OK looking at summary in isolation (can try and resolve row template later), I've

- just downloaded again to be sure

- loaded into VS - Infragistics version is 13.2.20132.2075 ie I haven't needed to change control versions from the one you supplied

- run the project - deferred calcs is set to false on your control - for results see form image to top right - summary showing 930 - correct

- stopped project and changed deferred calcs to true on the control - for results see image - summary showing 90 - wrong as only includes first 9 rows.  You can also see from this image in the output that the values for column d are nothing from row 10 onwards.  You can also see the extra code you've added in the BeginSummary sub which I haven't changed.

I'm sure I must be doing something wrong but can't see what.

Thanks for your continued help it's really appreciated.

Hi,

Sorry, this was my fault. I thought the sample had DeferredCalculationsEnabled set to true.

Anyway, you can still get it to work, but you have to turn off DeferredCalculationsEnabled temporarily when calculating the summary:

Friend Sub BeginCustomSummary(summarySettings As Infragistics.Win.UltraWinGrid.SummarySettings, rows As Infragistics.Win.UltraWinGrid.RowsCollection) Implements Infragistics.Win.UltraWinGrid.ICustomSummaryCalculator.BeginCustomSummary
            CType(ultraCalcManager, Infragistics.Win.UltraWinCalcManager.UltraCalcManager).DeferredCalculationsEnabled = False
           Dim columnRef As IUltraCalcReference = ultraCalcManager.GetReference("//UltraGrid1/abc/d")
            ultraCalcManager.EnsureCalculated(columnRef, True)
            CType(ultraCalcManager, Infragistics.Win.UltraWinCalcManager.UltraCalcManager).DeferredCalculationsEnabled = True

            Me.invoiced = 0
            Me.paid = 0
        End Sub

Although the more I think about it, the more I realize that DeferredCalculationsEnabled isn't really giving you a lot of benefit here. Since you have a a summary at the top of the grid, everything has to be calculated immediately, anyway, in order for the summary calculation to be accurate. So unless the summary is scrolled out of view and you make a change, the calculations can almost never be deferred.

Mike and Michael, many thanks for your help on this issue.  I think we've all spent plenty of time on this already and it does appear, to me, that there isn't an easy solution to this.  I thought originally I might just be missing something and a quick change of property values would sort it out.  In summary and to clarify what I'm seeing with the last few posts:

1. Summary not working when deferred calcs is TRUE initially - having inserted the extra lines of code in the previous post then yes I agree that the summary now does work as expected without scrolling to the bottom of the grid.  However, template row doesn't work.

2. I've checked the template issue in isolation again using 2014.1 and it still doesn't work with deferred calcs set to FALSE initially.  I think it may appear to work in your sample as you set the value to TRUE in the BeforeEnterEditMode event.

After playing a little again the best value in my situation for deferred calcs is TRUE as it allows the template to work and the summary even updates when the template is getting updated.  The only issue being that as you've already said, Mike, is that the rows out of view don't have column d populated until scrolled into view.  I've now got around that in the AggregateCustomSummary with the following line of code (sorry not sure how to insert code in reply like you've done):

If row.Cells("d").Value Is Nothing Then row.Cells("d").Value = CDec(row.Cells("a").Value) + CDec(row.Cells("b").Value)

This does mean the formula is sort of duplicated within the code but never mind.  There may be a better / more robust way of updating the cell value or testing that it's not been calculated and if so I'd be grateful for advice on that.

Once again thanks for all your help and I think it's time to move on....

Hi,

You are correct. I didn't notice that the sample project was working around the problem by setting DeferredCalculationsEnabled to true in BeforeEnterEditMode. So the issue with the TemplateAddRow still exists.

I will re-open the issue and we will look into this again and try to get it fixed. Once that issue is fixed, then you should be able to achieve what you want by setting DeferredCalculationsEnabled to false.

Once again, I apologize for the confusion.

Mike, I can confirm that we now have a working solution and once again thanks for your time on this.

Cheers

Hi,

So we took another look, and it looks like fixing this in the control would be extremely dangerous and have a high potential for breakage.

The good news is that I found another workaround that I think should be acceptable and get you what you want. In fact, I am pretty sure this workaround will fix both of the issues you reported here, and alleviate the need for the changes in your custom summary calculator.

All you have to do is set the FormulaRowSourceIndex to either RowIndex or ListIndex.

By default, formulas are based on the VisualIndex of the rows. Usually, this doesn't matter, since you don't often use formulas that rely on the relative indices of rows. And such is the case with your sample - you aren't using any row indices in your formulas. The reason the AddRow isn't calculating is because it's Index is -1, and the CalcManager things it's an invalid row.

By switching the index to use RowIndex, both the summary and the cell in the AddNew row calculated immediately. You still need to set DeferredCalculationsEnabled to false, but as I mentioned above, that doesn't really matter since you have a summary that forces the calculation of every row, anyway.

So in your sample, I just added this line of code to the Form_Load

Me.UltraGrid1.DisplayLayout.Override.FormulaRowIndexSource = FormulaRowIndexSource.RowIndex

No worries Mike, I'll await the outcome of your investigation.