I have a grid with formulas using the Calc Manager.
I want to load the form and re calc the grid and then save to the data, but i don't want to show the form. I want to do it in the background.
I am getting some very inconsistent results. Sometimes i get the correct results, sometimes i will get zero and sometimes i get incorrrect results.
I have set the CalcFrequency to manual and DeferredCalculationsEnabled to false. I populate the data then i call recalc on the calcmamager then i update the tableadapter to update the database.
Do i need to load the form and show the grid?
You seem to be doing everything right. There's nothing else I can think of that should cause the calculations not to work.
Are you using the latest Hot Fix? If not, you should get it and see if that helps.
If not, recommend that you try to duplicate this behavior in a small sample and Submit an incident to Infragistics Developer Support so they can check it out.
I am using the latest hotfix.
I will try and create a sample to submit.