Forum Discussion

sbkeenan's avatar
sbkeenan
Frequent Contributor
15 years ago

Working with Dev Express XtraPivotGrid - Trying to obtain column/row headings

Hi By using the following code, I am able to simulate a click on any cell within the pivot grid and obtain both its actual value and display value: colCount = pgCtrl.Cells.ColumnCount ...
sbkeenan's avatar
sbkeenan
Frequent Contributor
15 years ago
Hi Jared



I finally managed to crack the problem.



By using:



    rowIndex = pgCtrl.Cells.GetFocusedCellInfo.RowFieldIndex

    colHeading = pgCtrl.Cells.GetFocusedCellInfo.DataField.Caption

    rowHeading = pgCtrl.Cells.GetFocusedCellInfo.Data.GetRowValue(rowIndex)



I can get the column and row headings for the focused cell.



I have spent a considerable amount of time on this issue, together with a couple of others, all to do with the Dev Express pivot grid control.  So, if anyone out there is interested, I have put together a document, containing some code examples that I have been able to use in my tests.  It's a Microsoft Word 2003 document, which has been zipped for the purposes of attaching it here.



I would be happy to hear from anyone who has any comments, suggestions or better solutions!!



Many thanks.



Regards

Stephen.