alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Class PivotCacheFieldImpl

    Represents single pivot field in the pivot cache.

    Inheritance
    object
    PivotCacheFieldImpl
    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 PivotCacheFieldImpl

    Constructors

    PivotCacheFieldImpl()

    Initializes a new instance of Pivot cache field.

    Declaration
    public PivotCacheFieldImpl()

    PivotCacheFieldImpl(BiffReader)

    Initializes a new instance of pivot cache field and extracts its values from BiffReader.

    Declaration
    [CLSCompliant(false)]
    public PivotCacheFieldImpl(BiffReader reader)
    Parameters
    Type Name Description
    BiffReader reader

    Reader to get data from.

    Properties

    CalculatedItems

    Gets items within a PivotTable field that uses formula.

    Declaration
    public PivotCalculatedItems CalculatedItems { get; }
    Property Value
    Type
    PivotCalculatedItems

    Caption

    Gets or sets the caption of the cache field.

    Declaration
    public string Caption { get; set; }
    Property Value
    Type
    string

    DataType

    Gets the type of the field's data. Read-only.

    Declaration
    public PivotDataType DataType { get; }
    Property Value
    Type
    PivotDataType

    Formula

    Gets or sets the formula for the calculated field

    Declaration
    public string Formula { get; set; }
    Property Value
    Type
    string

    Index

    Gets or sets the index of this field in the parent collection.

    Declaration
    public int Index { get; set; }
    Property Value
    Type
    int

    IsDataBaseField

    Gets or sets a Boolean value indicating whether this field came from the source database.

    Declaration
    public bool? IsDataBaseField { get; set; }
    Property Value
    Type
    bool?

    IsDate

    True if the cache filed is a date. False otherwise.

    Declaration
    public bool IsDate { get; }
    Property Value
    Type
    bool

    IsDouble

    True if the cache field is a double value. False otherwise.

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

    IsDoubleInt

    True if the cache field is a double or int value. False otherwise.

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

    IsFieldGroup

    True if the cache field is Field group. False otherwise.

    Declaration
    public bool IsFieldGroup { get; }
    Property Value
    Type
    bool

    IsFormulaField

    True if the cache field is formula field. False otherwise.

    Declaration
    public bool IsFormulaField { get; }
    Property Value
    Type
    bool

    IsInIndexList

    True if the cache field is present in the index list. False otherwise.

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

    IsLongIndex

    True if the cache field has a long index. False otherwise.

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

    IsParsed

    Gets or sets a Boolean value indicating whether the shared items are parsed.

    Declaration
    public bool? IsParsed { get; set; }
    Property Value
    Type
    bool?

    IsString

    True if the cache field is a string. False otherwise.

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

    IsUnknown

    True if the cache field is unknown. False Otherwise.

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

    IsUnknown2

    True if the cache field is unknown2. False Otherwise.

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

    ItemCount

    Gets the items in the pivot cache field. Read-only.

    Declaration
    public int ItemCount { get; }
    Property Value
    Type
    int

    Name

    Gets or sets teh anme of the pivot cache field.

    Declaration
    public string Name { get; set; }
    Property Value
    Type
    string

    NumFormatIndex

    Gets or sets the number format that is applied to all items in the field.

    Declaration
    public int NumFormatIndex { get; set; }
    Property Value
    Type
    int

    ParentFeildGroupIndex

    Gets or sets the field group index.

    Declaration
    public int ParentFeildGroupIndex { get; set; }
    Property Value
    Type
    int

    Methods

    GetValue(int)

    Gets item at the specified index.

    Declaration
    public object GetValue(int index)
    Parameters
    Type Name Description
    int index

    Index of the value to get.

    Returns
    Type Description
    object

    Requested value.

    Parse(BiffReader)

    Parses pivot cache field.

    Declaration
    [CLSCompliant(false)]
    public void Parse(BiffReader reader)
    Parameters
    Type Name Description
    BiffReader reader

    Reader to extract data from.

    Serialize(OffsetArrayList)

    Serializes pivot cache field into list of Biff records.

    Declaration
    [CLSCompliant(false)]
    public void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList to serialize into.

    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved