Hi,
Firstly apologies if this is a simple mistake on my part or has been covered elsewhere but I've just started back with the grid and calc manager and am struggling to get the attached to work (VS2010 with 2013.2075)
Simple project attached and when I click in the new row the formula for column d doesn't appear to work but it works fine for existing rows. If I change the DeferredCalculationsEnabled to True on the calc manager then it works fine but my summary isn't fully calculated unless the grid is fully scrolled. I've tried various combinations of the DeferredCalculationsEnabled and CalcFrequency but just can't seem to get it to give a complete summary and complete the formula for a new row.
Any help greatly appreciated.
Thanks
Hello,
The DeferredCalculationsEnabled will set the calculations on the visible objects. In this case, the visible rows. If you run the sample the with this property set to True, then the scrolling is required to get grand total for all your rows.
Can you clarify by the following?
when I click in the new row the formula for column d doesn't appear to work but it works fine for existing rows
After adding a new row to your data, the calcmanager auto detects and adds it the entry to the total. Does this occur for you?
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.