1. Home
  2. Forum
  3. WinForms
  4. GridGroupingControl Urgent Help Required

GridGroupingControl Urgent Help Required

Hi,

I have 3 questions.

Question 1.

I have a DataTable with columns ProductId,ProductName,ChannelId, ChannelName,ModId,ModName...etc.
I have grouped these records(Please see the attachment.
In the QueryCoveredRange event handler, i have merged the cells and changed the cell type to "GridListEdit".


The problem is when i choose a value from the dropdowd grid, it is just updating only the cell in the first row in the range. all the cells in the merged range should should be updated.

Question 2

I have formulas in my cells. when i do sorting, the reference should be maintained.How can i do that? and, how do i set formulas like =SUM(R[-5]c:r[-1]C)?

Question 3.

I want excel like column grouping.
Please see the attachment.
Please provide a complete and simple solution asap.

Please provide solutions only on GridGroupingControl.

Awaiting reply.
Thanks in advance


Chakravarthi


Problems.zip

2 Replies
AD Administrator Syncfusion Team January 16, 2007 07:14 PM UTC

Hi Chakravarthi,

Issue 1: Update the covered Cells.

You can handle the TableControlCurrentCellCloseDropDown event of the grid and set the value of the related merged cell in grid. Here is a code snippet to show this.

private void gridGroupingControl1_TableControlCurrentCellCloseDropDown(object sender, GridTableControlPopupClosedEventArgs e)
{
GridCurrentCell cc = e.TableControl.CurrentCell;
GridRangeInfo range = e.TableControl.Model.CoveredRanges.FindRange(cc.RowIndex,cc.ColIndex);

for(int i= range.Top ; i<= range.Bottom;i++)
for(int j= range.Left ;j<=range.Right ;j++)
e.TableControl.Model[i,j].CellValue = cc.Renderer.ControlValue;
}

Issue 2: Formula cell

Please refer to following forum theard for more details.
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=41993

Issue 3: Excel Like Cloumn Grouping.

Please refer this.
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=32554

Best Regards,
Haneef

CO Chakravarthi Os January 19, 2007 08:37 AM UTC

Please provide me a sampole for Excel like column grouping only for GridGroupingControl

>Hi Chakravarthi,

Issue 1: Update the covered Cells.

You can handle the TableControlCurrentCellCloseDropDown event of the grid and set the value of the related merged cell in grid. Here is a code snippet to show this.

private void gridGroupingControl1_TableControlCurrentCellCloseDropDown(object sender, GridTableControlPopupClosedEventArgs e)
{
GridCurrentCell cc = e.TableControl.CurrentCell;
GridRangeInfo range = e.TableControl.Model.CoveredRanges.FindRange(cc.RowIndex,cc.ColIndex);

for(int i= range.Top ; i<= range.Bottom;i++)
for(int j= range.Left ;j<=range.Right ;j++)
e.TableControl.Model[i,j].CellValue = cc.Renderer.ControlValue;
}

Issue 2: Formula cell

Please refer to following forum theard for more details.
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=41993

Issue 3: Excel Like Cloumn Grouping.

Please refer this.
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=32554

Best Regards,
Haneef

Loader.
Up arrow icon