We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridGroupingControl Urgent Help Required

Thread ID:

Created:

Updated:

Platform:

Replies:

54708 Jan 16,2007 04:21 AM UTC Jan 19,2007 08:37 AM UTC WinForms 2
loading
Tags: GridControl
Chakravarthi Os
Asked On January 16, 2007 04:21 AM UTC

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

Administrator [Syncfusion]
Replied On 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

Chakravarthi Os
Replied On 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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;