alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Class PivotItemOptions

    Represents a single item in PivotTable field.

    Inheritance
    object
    PivotItemOptions
    Inherited Members
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    object.ToString()
    Namespace: Syncfusion.XlsIO.Implementation.PivotTables
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    public class PivotItemOptions

    Constructors

    PivotItemOptions()

    Initializes the pivot item options

    Declaration
    public PivotItemOptions()

    Properties

    DrillAcross

    Gets or sets a Boolean value that indicates whether attribute hierarchies nested next to each other on a PivotTable row or column will offer drilling "across" each other or not.

    Declaration
    public bool DrillAcross { get; set; }
    Property Value
    Type
    bool

    HasChildItems

    Gets or sets a Boolean value that indicates whether the pivot filed item has child items.

    Declaration
    public bool HasChildItems { get; set; }
    Property Value
    Type
    bool

    IsCalculatedItem

    Gets or sets a Boolean value indicating whether this item is a calculated item.

    Declaration
    public bool IsCalculatedItem { get; set; }
    Property Value
    Type
    bool

    IsChar

    True if the item has a character value. False Otherwise.

    Declaration
    public bool IsChar { get; set; }
    Property Value
    Type
    bool

    IsExpaned

    Gets or sets a Boolean value indicating whether this item is expanded in the PivotTable view.

    Declaration
    public bool IsExpaned { get; set; }
    Property Value
    Type
    bool

    IsHidden

    True if the item is hidden. False Otherwise.

    Declaration
    public bool IsHidden { get; set; }
    Property Value
    Type
    bool

    IsHiddenDetails

    Gets or sets a Boolean value that indicates whether the details for this item are hidden.

    Declaration
    public bool IsHiddenDetails { get; set; }
    Property Value
    Type
    bool

    IsMissing

    True if the item has a missing value. False otherwise.

    Declaration
    public bool IsMissing { get; set; }
    Property Value
    Type
    bool

    ItemType

    Gets or sets the type of the item. Value of 'default' indicates a grand total as the last row item value.

    Declaration
    public PivotItemType ItemType { get; set; }
    Property Value
    Type
    PivotItemType

    UserCaption

    Gets or sets the user caption of the item.

    Declaration
    public string UserCaption { get; set; }
    Property Value
    Type
    string
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved