I have an UltraGrid with 5 bands, using a DataSet as the underlying datasource. In 3 of the 5 bands, I have 15 unbound columns using an UltraCalcManager to do SUMs of child bands. (It does a bottom-up summation).
Every few times we load the grid with data, the "#Calculating" text appears, the UltraCalcManager does its thing, but a few cells might end up with "#VALUE!" in the cell. Next time I reload the DataSet, I might get 0 "#VALUE!"s, or I might get them in different cells.
Am I doing something wrong, or is this a "bug" with the UltraCalcManager?
Thanks,Kyle
P.S. - Attached is a screenshot as a single example.
Hi Kyle,
#VALUE indicates a value error in the calculations. If this is truly coming up at random, then it might be some kind of timing issue, but more likely, this is just the result of some calculation that is resulting in an error for some reason.
What version of the controls are you using?
What kinds of formulas are you using? Which functions are you using?
I apologize for the delayed response. I'm just now getting back to this project.
I'm using version 10.2.20102.1004. It truly is random. When I refresh the grid, with the same data, the #VALUE either totally disappears, or appears in another cell. It feels as though it's a asynchronous call that just times out or dies.
I'm only using SUM and IF functions. My formulas look similar to this: sum([../customers_orders/uctotalcost]) orif(sum([../customers_orders/uctotalsp])=0,0,sum([../customers_orders/uctotalcontrib])/sum([../customers_orders/uctotalsp]))
I think build 1004 is the release version. So my first suggestion is that you get the latest service release and see if that helps. This could be a bug which has already been fixed.
How to get the latest service release - Infragistics Community
If that does not help, then see if you can reproduce the issue in a small sample project and post it here and we will be happy to check it out. If you cannot reproduce it in a new project then maybe you can work backwards - make a copy of your real application and then remove things to narrow it down to the simplest case.