menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class PivotArea - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Class PivotArea

    Represents pivot area.

    Inheritance
    System.Object
    PivotArea
    Namespace: Syncfusion.XlsIO.Implementation.PivotTables
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    public class PivotArea : Object

    Constructors

    PivotArea(PivotCacheFieldImpl)

    Initializes the PivotArea

    Declaration
    public PivotArea(PivotCacheFieldImpl cacheField)
    Parameters
    Type Name Description
    PivotCacheFieldImpl cacheField

    Properties

    AreaType

    Gets or sets the type of the selection rule.

    Declaration
    public PivotAreaType AreaType { get; set; }
    Property Value
    Type
    PivotAreaType

    Axis

    Gets or sets the region of the PivotTable to which this rule applies.

    Declaration
    public PivotAxisTypes Axis { get; set; }
    Property Value
    Type
    PivotAxisTypes

    FieldIndex

    Gets or sets the index of the field that this selection rule refers to.

    Declaration
    public int FieldIndex { get; set; }
    Property Value
    Type
    System.Int32

    FieldPosition

    Gets or sets the position of the field within the axis to which this rule applies.

    Declaration
    public int FieldPosition { get; set; }
    Property Value
    Type
    System.Int32

    HasColumnGrand

    Gets or sets a flag indicating whether the column grand total is included.

    Declaration
    public bool HasColumnGrand { get; set; }
    Property Value
    Type
    System.Boolean

    HasRowGrand

    Gets or sets a flag indicating whether the row grand total is included.

    Declaration
    public bool HasRowGrand { get; set; }
    Property Value
    Type
    System.Boolean

    IsCacheIndex

    Gets or sets a flag indicating whether any indexes refer to fields or items in the Pivot cache and not the view.

    Declaration
    public bool IsCacheIndex { get; set; }
    Property Value
    Type
    System.Boolean

    IsDataOnly

    Gets or sets a flag indicating whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.

    Declaration
    public bool IsDataOnly { get; set; }
    Property Value
    Type
    System.Boolean

    IsLableOnly

    Gets or sets a flag indicating whether only the item labels for an item selection are selected and does not include the data values (in the data area of the view).

    Declaration
    public bool IsLableOnly { get; set; }
    Property Value
    Type
    System.Boolean

    IsOutline

    Gets or sets a flag indicating whether the rule refers to an area that is in outline mode.

    Declaration
    public bool IsOutline { get; set; }
    Property Value
    Type
    System.Boolean

    IsSubtotal

    Gets or sets a flag indicating whether any indexes refer to fields or items in the Pivot cache and not the view.

    Declaration
    public bool IsSubtotal { get; set; }
    Property Value
    Type
    System.Boolean

    Range

    Declaration
    public IRange Range { get; set; }
    Property Value
    Type
    IRange

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved