Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
305
Random "#VALUE!" in cells
posted

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.

Parents
  • 469350
    Offline posted

    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?

Reply Children