Good point. You really would not be able to fix it in a case like that unless you knew the name of the reference that the CalcReference for the grid is using interally. I think it goes something like: "_band_0". Like I said, this is almost certainly a bug.

Fortunately i'm using datatable, but how can i fix this problem if i have a custom List of object as a datasource of the grid? something like this

public class Person
    {
        private String _Name;
        private double _Salary;

        public double Salary
        {
            get { return _Salary;}
            set { _Salary = value; }
        }

        public string Name
        {
            get { return _Name; }
            set { _Name = value; }
        }
    }

        ultraGrid2.DataSource = TestData2();

        public List<Person> TestData2()
        {
            List<Person> persons = new List<Person>();

            Person ps = new Person();
            ps.Salary = 1500;
            ps.Name = "John";

            Person ps1 = new Person();
            ps1.Salary = 2100;
            ps1.Name = "Jim";

            persons.Add(ps);
            persons.Add(ps1);

            return persons;
        }

ps:I have submited a new incident.

Hi Mike,

perhaps its a syntax problem on the formula. I have made a simple example and attached to this discussion. It is a form that has a wingrid with 1 column and an ultranumericeditor. Basically i want to sum all cells of this column and the result multiplied by 2, finally show this result on the ultranumericeditor.

thank you.

Hi Walter.

This all sounds like a pretty simple case of using formulas to me. I'm having a hard time understanding what you are asking for here. Are you having trouble with the syntax? Or setting up a NamedReference? Or applying a formula to an UltraNumericEditor?

Personally, I would use a NamedReference for anything you don't need to display to the user. It doesn't make sense to use a control just to calculate a formula that is never displayed.

To sum grid column in a NamedReference, you would use the Sum function and pass in the grid column reference.