Sort CellRange in C1Flexgrid for Winforms

Blogs

There are occasions when users need to implement sort on a selected range of cells and not the entire C1Flexgrid. There’s no direct method to implement this and here we will discuss implementation of the very same subject.

Say there is a C1Flexgrid on the Form with a particular CellRange selected using Mouse or code and we need to sort that cell range.

Lets drop a button on the Form besides the C1Flexgrid and start writing some code in the Click event of the button.

And here’s the logic:

1. Capture the CellRange object.

C1.Win.C1FlexGrid.CellRange cr = this.c1FlexGrid1.Selection;

2. Create a temporary C1Flexgrid object.

var fg = new C1.Win.C1FlexGrid.C1FlexGrid();

3. Add the same number of rows and columns to the temporary C1flexgrid object as the number of rows and columns in CellRange.

fg.Cols.Count = cr.c2 - cr.c1 + 1;
fg.Cols.Fixed = 0;
fg.Rows.Count = cr.r2 - cr.r1 + 1;
fg.Rows.Fixed = 0;

4. Populate this temporary ClFlexgrid with data from CellRange.

for (int i = cr.r1; i <= cr.r2; i++)
{
    for (int j = cr.c1; j <= cr.c2; j++)
    {
        fg[_row, _col] = this.c1FlexGrid1[ i ,  j ];
        _col += 1;
    }
    _row += 1;
    _col = 0;
}

5. Sort temporary C1Flexgrid.

fg.Sort(C1.Win.C1FlexGrid.SortFlags.Ascending, 0);

6. Populate the sorted data from cells in temporary C1Flexgrid to the CellRange in original C1Flexgrid.

for (int i = cr.r1; i <= cr.r2; i++)
{
    for (int j = cr.c1; j <= cr.c2; j++)
    {
        this.c1FlexGrid1[ i ,  j ] = fg[_row, _col];
        _col += 1;
    }
    _row += 1;
    _col = 0;
}

Eventually the entire code in Button’s Click event looks like:

//Get CellRange from selection done via Mouse
C1.Win.C1FlexGrid.CellRange cr = this.c1FlexGrid1.Selection;

//Create a temporary Flex object 'fg'.
var fg = new C1.Win.C1FlexGrid.C1FlexGrid();

//Set the same number of rows and columns in temp object as in the CellRange of the actual grid.
fg.Cols.Count = cr.c2 - cr.c1 + 1;
fg.Cols.Fixed = 0;
fg.Rows.Count = cr.r2 - cr.r1 + 1;
fg.Rows.Fixed = 0;

int _row = 0;
int _col = 0;

//Populate temp grid with data from selected range
for (int i = cr.r1; i <= cr.r2; i++)
{
    for (int j = cr.c1; j <= cr.c2; j++)
    {
        fg[_row, _col] = this.c1FlexGrid1[ i ,   j ];
        _col += 1;
    }
    _row += 1;
    _col = 0;
}

//Set Sort Type and the column index you wish sort to be implemented on.
//In this case, leftmost column of 'fg', and thereby leftmost column
//of selected CellRange in actual grid gets sorted in Ascending order.
fg.Sort(C1.Win.C1FlexGrid.SortFlags.Ascending, 0);

_row = 0;
_col = 0;

//Populate the selected range in actual grid with data from temp grid.
for (int i = cr.r1; i <= cr.r2; i++)
{
    for (int j = cr.c1; j <= cr.c2; j++)
    {
        this.c1FlexGrid1 = fg[_row, _col];
        _col += 1;
    }
    _row += 1;
    _col = 0;
}

//Dispose temporary Flexgrid Object
fg.Dispose();

Here’s a screenshot of a C1Flexgrid with a sorted CellRange.