PivotGridFieldBase.CellFormat Property

Provides access to the format settings applied to cells.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v17.2.Core.dll

Declaration

C#

[XtraSerializableProperty(XtraSerializationVisibility.Content)]
public FormatInfo CellFormat { get; }

VB.NET

<XtraSerializableProperty(XtraSerializationVisibility.Content)>
Public ReadOnly Property CellFormat As FormatInfo

Property Value

Type	Description
FormatInfo	A FormatInfo object that provides the format settings applied to cells.

Remarks

To learn more about formatting values displayed in the Pivot Grid, see Data Formatting.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CellFormat property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-define-a-filter-criterion-where-two-data-fields-are-compared-to-each-other-e625/CS/PrefilterFieldVsField/Form1.cs#L52

grid.Fields["Year"].Width = 70;
grid.Fields["ForecastSale"].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grid.Fields["ForecastSale"].CellFormat.FormatString = "c";

how-to-access-other-cell-value-while-calculating-the-current-cell-e1110/CS/WinAppCustomCellValue/Form1.cs#L23

fieldPercentOfBeverages.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
fieldPercentOfBeverages.CellFormat.FormatString = "P";

how-to-highlight-field-headers-when-they-are-filtered-e545/CS/HighlightFieldHeaderWhenFiltered/Form1.cs#L49

grid.Fields["Year"].Width = 70;
grid.Fields["Sale"].CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grid.Fields["Sale"].CellFormat.FormatString = "c";

how-to-assign-different-in-place-editors-to-different-types-of-cells-t153888/CS/PivotGridControl_CustomCellEdit/Form1.cs#L23

fieldQuantityPercent.SummaryDisplayType = PivotSummaryDisplayType.PercentOfColumn;
fieldQuantityPercent.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom;
fieldQuantityPercent.CellFormat.FormatString = "{0}%";

how-to-override-the-cell-editor-used-for-the-in-place-editing-t515806/CS/PivotGridControl_CustomCellEdit/Form1.cs#L22

fieldQuantityPercent.SummaryDisplayType = PivotSummaryDisplayType.PercentOfColumn;
fieldQuantityPercent.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom;
fieldQuantityPercent.CellFormat.FormatString = "{0}%";

VB.NET

how-to-define-a-filter-criterion-where-two-data-fields-are-compared-to-each-other-e625/VB/PrefilterFieldVsField/Form1.vb#L54

grid.Fields("Year").Width = 70
grid.Fields("ForecastSale").CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric
grid.Fields("ForecastSale").CellFormat.FormatString = "c"

how-to-access-other-cell-value-while-calculating-the-current-cell-e1110/VB/WinAppCustomCellValue/Form1.vb#L16

fieldPercentOfBeverages.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric
fieldPercentOfBeverages.CellFormat.FormatString = "P"

how-to-highlight-field-headers-when-they-are-filtered-e545/VB/HighlightFieldHeaderWhenFiltered/Form1.vb#L51

grid.Fields("Year").Width = 70
grid.Fields("Sale").CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric
grid.Fields("Sale").CellFormat.FormatString = "c"

how-to-assign-different-in-place-editors-to-different-types-of-cells-t153888/VB/PivotGridControl_CustomCellEdit/Form1.vb#L24

fieldQuantity1.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfColumn
fieldQuantity1.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom
fieldQuantity1.CellFormat.FormatString = "{0}%"

how-to-override-the-cell-editor-used-for-the-in-place-editing-t515806/VB/PivotGridControl_CustomCellEdit/Form1.vb#L23

fieldQuantity1.SummaryDisplayType = DevExpress.Data.PivotGrid.PivotSummaryDisplayType.PercentOfColumn
fieldQuantity1.CellFormat.FormatType = DevExpress.Utils.FormatType.Custom
fieldQuantity1.CellFormat.FormatString = "{0}%"