how to find column, row and data area values from cell object in Devex Pivot grid

Question

I am using Dev ex pivot grid to show some data on the screen. When user click on any cell in data area, I want to find out it's corresponding row, column and data area value and their field name.

I am handling CellClick event of devex pivot grid. with PivotCellEventArgs object I can find fieldname but not value.

I want the name and value for given cell from all perspectives (row, column and data area).

Thanks in advance.

I tried but couldn't find much. Can you point me to some sample code for it. — Abhash786, Jul 20 '16 at 08:22
You should really ask this stuff on the DevExpress support forum. https://www.devexpress.com/Support/Center — Shiv, Dec 15 '19 at 23:05

jalil burbara · Accepted Answer · 2020-09-10T16:32:39.377

In Razor MVC you can do that

@Html.DevExpress().PivotGrid(settings =>
{
    settings.Name = "PivotGrid";
    settings.CallbackRouteValues = new { Controller = "Home", Action = "PivotGridPartial" };

    settings.ClientSideEvents.CellClick = @"
    function(s,e){
        var EventArgs=e; 
        console.log(EventArgs.RowValue);
        console.log(EventArgs.RowFieldName);
        console.log(EventArgs.ColumnValue);
        console.log(EventArgs.ColumnFieldName);
        console.log(EventArgs.Value); 
    }";

    settings.Fields.Add(field =>
    {
        field.Area = PivotArea.RowArea;
        ...
    });

    settings.Fields.Add(field =>
    {
        field.Area = PivotArea.ColumnArea;
        ...
    });

    settings.Fields.Add(field =>
    {
        field.Area = PivotArea.DataArea;
        ...
    });

}).Bind(Model).GetHtml()

how to find column, row and data area values from cell object in Devex Pivot grid

1 Answers1