alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Class AutoFilterRecord

    Summary description for AutoFilterInfoRecord.

    Inheritance
    object
    BiffRecordRaw
    AutoFilterRecord
    Implements
    IBiffStorage
    ICloneable
    Inherited Members
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    object.ToString()
    Namespace: Syncfusion.XlsIO.Parser.Biff_Records
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    [Biff(TBIFFRecord.AutoFilter)]
    [CLSCompliant(false)]
    public class AutoFilterRecord : BiffRecordRaw, IBiffStorage, ICloneable

    Constructors

    AutoFilterRecord()

    Default constructor fills all data with default values.

    Declaration
    public AutoFilterRecord()

    AutoFilterRecord(Stream, out int)

    Read / initialize Constructor.

    Declaration
    public AutoFilterRecord(Stream stream, out int itemSize)
    Parameters
    Type Name Description
    Stream stream

    Stream from which record data should be read.

    int itemSize

    Size of read item.

    Exceptions
    Type Condition
    ArgumentNullException

    If stream is not specified.

    ApplicationException

    If stream does not support read or seek operations.

    AutoFilterRecord(int)

    Reserved for record's internal data array.

    Declaration
    public AutoFilterRecord(int iReserve)
    Parameters
    Type Name Description
    int iReserve

    Amount of bytes for data array.

    Exceptions
    Type Condition
    ArgumentOutOfRangeException

    If amount of bytes requested is less than zero.

    Properties

    FirstCondition

    First condition.

    Declaration
    public AutoFilterRecord.DOPER FirstCondition { get; }
    Property Value
    Type
    AutoFilterRecord.DOPER

    Index

    Number of AutoFilter drop-down arrows on the sheet.

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

    IsAnd

    True if the custom filter conditions are ANDed; False if the custom filter conditions are ORed.

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

    IsBlank

    If filtered to blanks - true. Read-only.

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

    IsNonBlank

    If filtered to nonblanks - true. Read-only.

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

    IsPercent

    True if the Top 10 AutoFilter shows percentage; False if it shows items.

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

    IsSimple1

    True if the first condition is a simple equality.

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

    IsSimple2

    True if the second condition is a simple equality.

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

    IsTop

    True if the Top 10 AutoFilter shows the top items; False if it shows the bottom items.

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

    IsTop10

    True if the condition is a Top 10 AutoFilter.

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

    MinimumRecordSize

    Read-only. Minimum possible size of the record.

    Declaration
    public override int MinimumRecordSize { get; }
    Property Value
    Type
    int
    Overrides
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.MinimumRecordSize

    NeedDataArray

    Declaration
    public override bool NeedDataArray { get; }
    Property Value
    Type
    bool
    Overrides
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.NeedDataArray

    Options

    Option flags. Read-only.

    Declaration
    public ushort Options { get; }
    Property Value
    Type
    ushort

    SecondCondition

    Second condition.

    Declaration
    public AutoFilterRecord.DOPER SecondCondition { get; }
    Property Value
    Type
    AutoFilterRecord.DOPER

    Top10Number

    Number of elements to show in Top10 mode.

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

    Methods

    Clone()

    Creates a new object that is a copy of the current instance.

    Declaration
    public object Clone()
    Returns
    Type Description
    object

    A new object that is a copy of this instance.

    GetStoreSize(ExcelVersion)

    Size of the required storage space. Read-only.

    Declaration
    public override int GetStoreSize(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type
    int
    Overrides
    BiffRecordRaw.GetStoreSize(ExcelVersion)

    ParseStructure(DataProvider, int, int, ExcelVersion)

    Parse structure of record. Convert Data buffer to special values according to record specification.

    Declaration
    public override void ParseStructure(DataProvider provider, int iOffset, int iLength, ExcelVersion version)
    Parameters
    Type Name Description
    DataProvider provider

    Object that provides access to the data.

    int iOffset

    Offset to the record's data.

    int iLength

    Length of the record's data.

    ExcelVersion version

    Excel version used for infill.

    Overrides
    BiffRecordRaw.ParseStructure(DataProvider, int, int, ExcelVersion)

    Implements

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