PivotGridOptionsChartDataSourceBase.ProvideCellValuesAsType Property

Gets or sets the type to which cell values are converted, before they are exported to the Chart Control.

Namespace: DevExpress.XtraPivotGrid.Data

Assembly: DevExpress.PivotGrid.v19.1.Core.dll

Declaration

C#

[DefaultValue(null)]
[Browsable(false)]
[XtraSerializableProperty(-100)]
public virtual Type ProvideCellValuesAsType { get; set; }

VB.NET

<DefaultValue(Nothing)>
<Browsable(False)>
<XtraSerializableProperty(-100)>
Public Overridable Property ProvideCellValuesAsType As Type

Property Value

Type	Default	Description
Type	*null*	A Type object, representing the type to which cell values are converted.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to ProvideCellValuesAsType
WinForms Controls	PivotGridControl	.OptionsChartDataSource.ProvideCellValuesAsType
Reporting	XRPivotGrid	.OptionsChartDataSource.ProvideCellValuesAsType
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsChartDataSource.ProvideCellValuesAsType
	MVCxPivotGrid	.OptionsChartDataSource.ProvideCellValuesAsType
	PivotGridSettings	.OptionsChartDataSource.ProvideCellValuesAsType

Remarks

If the ProvideCellValuesAsType property is set to null, cell values are not converted before export, unless the pivot grid contains multiple data fields with different data types. In this instance, cell values are converted to Double (if possible).

To specify the type to which the column field and row field values are converted, use the PivotGridOptionsChartDataSourceBase.ProvideColumnFieldValuesAsType and PivotGridOptionsChartDataSourceBase.ProvideRowFieldValuesAsType properties, respectively.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ProvideCellValuesAsType 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#

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/CS/Form1.cs#L47

pivotGridControl1.OptionsChartDataSource.ProvideColumnFieldValuesAsType = typeof(string);
pivotGridControl1.OptionsChartDataSource.ProvideCellValuesAsType = typeof(int);
CreateEncodeTables();

VB.NET

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/VB/Form1.vb#L51

pivotGridControl1.OptionsChartDataSource.ProvideColumnFieldValuesAsType = GetType(String)
pivotGridControl1.OptionsChartDataSource.ProvideCellValuesAsType = GetType(Integer)
CreateEncodeTables()