PivotField.Name Property

Gets or sets the PivotTable field’s name.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

string Name { get; set; }

VB.NET

Property Name As String

Property Value

Type	Description
String	A String value that specifies the name of the pivot field.

Remarks

Use the Name property to rename a specific field in the PivotTable report. By default, fields get their names from the original source data (the field’s source name can be obtained using the PivotField.SourceName property).

To change the name of the field located in the data area of your report, use the PivotDataField.Name property.

Important

When renaming a field, make sure that the specified name is not equal to an existing PivotTable field name; otherwise, a System.InvalidOperationException exception will be thrown.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Name 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#

spreadsheet-document-api-pivot-table-examples/CS/SpreadsheetDocServerPivotAPI/CodeExamples/PivotCalculatedFieldActions.cs#L58

//Change the calculated field name.
field.Name = "Sales Tax Rate 15";
//Add the calculated field to the data area and specify the custom field name.

wpf-spreadsheet-pivot-table-api-examples/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotCalculatedFieldActions.cs#L58

//Change the calculated field name.
field.Name = "Sales Tax Rate 15";
//Add the calculated field to the data area and specify the custom field name.

winforms-spreadsheet-pivot-table-api/CS/SpreadsheetPivotTableExamples/CodeExamples/PivotCalculatedFieldActions.cs#L58

//Change the calculated field name.
field.Name = "Sales Tax Rate 15";
//Add the calculated field to the data area and specify the custom field name.

VB.NET

spreadsheet-document-api-pivot-table-examples/VB/SpreadsheetDocServerPivotAPI/CodeExamples/PivotCalculatedFieldActions.vb#L53

'Change the calculated field name.
field.Name = "Sales Tax Rate 15"
'Add the calculated field to the data area and specify the custom field name.

wpf-spreadsheet-pivot-table-api-examples/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/PivotCalculatedFieldActions.vb#L53

'Change the calculated field name.
field.Name = "Sales Tax Rate 15"
'Add the calculated field to the data area and specify the custom field name.

winforms-spreadsheet-pivot-table-api/VB/SpreadsheetPivotTableExamples/CodeExamples/PivotCalculatedFieldActions.vb#L53

'Change the calculated field name.
field.Name = "Sales Tax Rate 15"
'Add the calculated field to the data area and specify the custom field name.