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