PivotGridFieldCollectionBase.GetVisibleFieldCount(PivotArea) Method

Returns the number of visible fields displayed within the specified area.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

public int GetVisibleFieldCount(
    PivotArea area
)

VB.NET

Public Function GetVisibleFieldCount(
    area As PivotArea
) As Integer

Parameters

Name	Type	Description
area	PivotArea	A PivotArea value that identifies the targeted area.

Returns

Type	Description
Int32	An integer value that identifies the number of visible fields displayed within the specified area.

Remarks

This method traverses through the collection and calculates the number of visible fields located within the specified area. A field is visible if its PivotGridFieldBase.Visible property is set to true. A field’s current area is specified by the PivotGridFieldBase.Area property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetVisibleFieldCount(PivotArea) method.

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-provide-custom-summary-values-for-total-grand-total-and-ordinary-cells-t555679/CS/WinPivotCustomSummaryCellType/Form1.cs#L23

PivotGridControl pivot = sender as PivotGridControl;
int lastRowFieldIndex = pivot.Fields.GetVisibleFieldCount(PivotArea.RowArea) - 1;
int lastColumnFieldIndex = pivot.Fields.GetVisibleFieldCount(PivotArea.ColumnArea) - 1;

how-to-hide-pivot-grid-columns-e2683/CS/XtraPivotGrid_HidingColumns/Form1.cs#L18

PivotCustomFieldValueCellsEventArgs e) {
if (pivotGridControl1.Fields.GetVisibleFieldCount(PivotArea.ColumnArea) == 0
    && ceHideColumnGrandTotal.Checked)

VB.NET

how-to-provide-custom-summary-values-for-total-grand-total-and-ordinary-cells-t555679/VB/VBWinPivotCustomSummaryCellType/Form1.vb#L23

Dim pivot As PivotGridControl = TryCast(sender, PivotGridControl)
Dim lastRowFieldIndex As Integer = pivot.Fields.GetVisibleFieldCount(PivotArea.RowArea) - 1
Dim lastColumnFieldIndex As Integer = pivot.Fields.GetVisibleFieldCount(PivotArea.ColumnArea) - 1

how-to-hide-pivot-grid-columns-e2683/VB/XtraPivotGrid_HidingColumns/Form1.vb#L18

Private Sub pivotGridControl1_CustomFieldValueCells(ByVal sender As Object, ByVal e As PivotCustomFieldValueCellsEventArgs) Handles pivotGridControl1.CustomFieldValueCells
    If pivotGridControl1.Fields.GetVisibleFieldCount(PivotArea.ColumnArea) = 0 AndAlso ceHideColumnGrandTotal.Checked Then
        e.Remove(e.GetCell(True, 0))