[C#/WPF/DEVEXPRESS] PivotGridControl 클래스 : CustomCellDisplayText 이벤트를 사용해 커스텀 셀 디스플레이 텍스트 처리하기

■ PivotGridControl 클래스의 CustomCellDisplayText 이벤트를 사용해 커스텀 셀 디스플레이 텍스트를 처리하는 방법을 보여준다.

▶ 예제 코드 (XAML)


<Grid xmlns:dxpg="http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid">
    <dxpg:PivotGridControl x:Name="pivotGridControl"
        CustomCellDisplayText="pivotGridControl_CustomCellDisplayText">
        <dxpg:PivotGridControl.Fields>
            <dxpg:PivotGridField FieldName="Country"        Area="RowArea"                                            />
            <dxpg:PivotGridField FieldName="Sales Person"   Area="RowArea"    Caption="Customer"                      />
            <dxpg:PivotGridField FieldName="OrderDate"      Area="ColumnArea" Caption="Year" GroupInterval="DateYear" />
            <dxpg:PivotGridField FieldName="CategoryName"   Area="ColumnArea" Caption="Product Category"              />
            <dxpg:PivotGridField FieldName="ProductName"    Area="FilterArea" Caption="Product Name"                  />
            <dxpg:PivotGridField FieldName="Extended Price" Area="DataArea"   CellFormat="c0"                         />
        </dxpg:PivotGridControl.Fields>
    </dxpg:PivotGridControl>
</Grid>

<dxpg:PivotGridControl x:Name="pivotGridControl"

CustomCellDisplayText="pivotGridControl_CustomCellDisplayText">

<dxpg:PivotGridControl.Fields>

<dxpg:PivotGridField FieldName="Country" Area="RowArea" />

<dxpg:PivotGridField FieldName="Sales Person" Area="RowArea" Caption="Customer" />

<dxpg:PivotGridField FieldName="OrderDate" Area="ColumnArea" Caption="Year" GroupInterval="DateYear" />

<dxpg:PivotGridField FieldName="CategoryName" Area="ColumnArea" Caption="Product Category" />

<dxpg:PivotGridField FieldName="ProductName" Area="FilterArea" Caption="Product Name" />

<dxpg:PivotGridField FieldName="Extended Price" Area="DataArea" CellFormat="c0" />

</dxpg:PivotGridControl.Fields>

</dxpg:PivotGridControl>

</Grid>

▶ 예제 코드 (C#)


using DevExpress.Xpf.PivotGrid;

#region 피벗 그리드 컨트롤 커스텀 셀 표시 텍스트 처리하기 - pivotGridControl_CustomCellDisplayText(sender, e)

/// <summary>
/// 피벗 그리드 컨트롤 커스텀 셀 표시 텍스트 처리하기
/// </summary>
/// <param name="sender">이벤트 발생자</param>
/// <param name="e">이벤트 인자</param>
private void pivotGridControl_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)
{
    if(e.RowValueType    != FieldValueType.GrandTotal || e.ColumnValueType == FieldValueType.GrandTotal || e.ColumnValueType == FieldValueType.Total)
    {
        return;
    }

    if(Convert.ToSingle(e.Value) < 50000)
    {
        e.DisplayText = "Low";
    }
    else if(Convert.ToSingle(e.Value) > 100000)
    {
        e.DisplayText = "High";
    }
    else
    {
        e.DisplayText = "Middle";
    }
}

#endregion

using DevExpress.Xpf.PivotGrid;

#region 피벗 그리드 컨트롤 커스텀 셀 표시 텍스트 처리하기 - pivotGridControl_CustomCellDisplayText(sender, e)

/// <summary>

/// 피벗 그리드 컨트롤 커스텀 셀 표시 텍스트 처리하기

/// </summary>

/// <param name="sender">이벤트 발생자</param>

/// <param name="e">이벤트 인자</param>

private void pivotGridControl_CustomCellDisplayText(object sender, PivotCellDisplayTextEventArgs e)

{

if(e.RowValueType != FieldValueType.GrandTotal || e.ColumnValueType == FieldValueType.GrandTotal || e.ColumnValueType == FieldValueType.Total)

{

return;

}

if(Convert.ToSingle(e.Value) < 50000)

{

e.DisplayText = "Low";

}

else if(Convert.ToSingle(e.Value) > 100000)

{

e.DisplayText = "High";

}

else

{

e.DisplayText = "Middle";

}

#endregion