Excel like Sum of Selected Range of Cells in GridControl

[Sridhar]

Hi,

I have a requirement in which i need to display the sum of selected range of cells from a GridControl to a label. Could you suggest me a best possible way to do this?

Thanks and Regards,
Sridhar N

[Administrator]

One way you can do this is to use the grid.SelectionChanged event.

        void gridControl1_SelectionChanged(object sender, Syncfusion.Windows.Forms.Grid.GridSelectionChangedEventArgs e)
        {
            if (!e.Range.IsEmpty)
            {
                double sum = 0;
                double d;
                GridRangeInfo range = e.Range.ExpandRange(1, 1, gridControl1.RowCount, gridControl1.ColCount);
                int row, col;
                if (range.GetFirstCell(out row, out col))
                {
                    if (gridControl1[row, col].CellValue != null && double.TryParse(gridControl1[row, col].Text, out d))
                        sum += d;
                    while (range.GetNextCell(ref row, ref col) && gridControl1[row, col].CellValue != null 
                              && double.TryParse(gridControl1[row, col].Text, out d))
                    {
                        sum += d;
                    }
                    this.label1.Text = string.Format("{0}", sum);
                }
             }
            else
                this.label1.Text = "";
        }

[Sridhar]

Thanks a lot.

>One way you can do this is to use the grid.SelectionChanged event.

        void gridControl1_SelectionChanged(object sender, Syncfusion.Windows.Forms.Grid.GridSelectionChangedEventArgs e)
        {
            if (!e.Range.IsEmpty)
            {
                double sum = 0;
                double d;
                GridRangeInfo range = e.Range.ExpandRange(1, 1, gridControl1.RowCount, gridControl1.ColCount);
                int row, col;
                if (range.GetFirstCell(out row, out col))
                {
                    if (gridControl1[row, col].CellValue != null && double.TryParse(gridControl1[row, col].Text, out d))
                        sum += d;
                    while (range.GetNextCell(ref row, ref col) && gridControl1[row, col].CellValue != null 
                              && double.TryParse(gridControl1[row, col].Text, out d))
                    {
                        sum += d;
                    }
                    this.label1.Text = string.Format("{0}", sum);
                }
             }
            else
                this.label1.Text = "";
        }

[SubhaSheela R]

Hi Sridhar,

Thanks for your update.

Please feel free to open new one if you have any other concern.

Regards,
Subhasheela R

[Gaurav Pandey]

Well, this technique just works if I select a contiguous set of cells next to each other. If I select few cells which are not in a sequence, how will I be able to retrieve those? I need to do the same thing as the original post - compute the sum of the selected cells in the grid control with an additional requirement - selection is not done in a sequence.

Thanks,
Gaurav