This is a migrated thread and some comments may be shown as answers.

Access Cell

5 Answers 151 Views

PivotGrid and PivotFieldList

This is a migrated thread and some comments may be shown as answers.

5 Answers, 1 is accepted

answered on 10 Apr 2013, 02:01 PM

Hello Shaun,

Thank you for writing back.

You can you this method in this way:

this.radPivotGrid1.UpdateCompleted += new EventHandler(radPivotGrid1_UpdateCompleted);

this.FillWithData();

}

void radPivotGrid1_UpdateCompleted(object sender, EventArgs e)

{

foreach (PivotGroupNode columnNode in this.radPivotGrid1.PivotGridElement.GetColumnGroups())

{

foreach (PivotGroupNode rowNode in this.radPivotGrid1.PivotGridElement.GetRowGroups())

{

CellAggregateValue value = this.radPivotGrid1.PivotGridElement.GetAggregateValue(columnNode.Group, rowNode.Group, false, false);

if (!string.IsNullOrEmpty(value.FormattedValue))

{

//deal with the cell value

}

I hope this is helpful.

Do not hesitate to write back anytime you have further questions or need assistance.

Greetings,
Peter
the Telerik team

WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.