menu

UWP

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

    Show / Hide Table of Contents

    Class AutoFilterRecord

    Summary description for AutoFilterInfoRecord.

    Inheritance
    System.Object
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw
    AutoFilterRecord
    Implements
    IBiffStorage
    System.ICloneable
    Namespace: Syncfusion.XlsIO.Parser.Biff_Records
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    [Biff]
    public class AutoFilterRecord : BiffRecordRaw, IBiffStorage, ICloneable

    Constructors

    AutoFilterRecord()

    Default constructor fills all data with default values.

    Declaration
    public AutoFilterRecord()

    AutoFilterRecord(Int32)

    Reserved for record's internal data array.

    Declaration
    public AutoFilterRecord(int iReserve)
    Parameters
    Type Name Description
    System.Int32 iReserve

    Amount of bytes for data array.

    Exceptions
    Type Condition
    System.ArgumentOutOfRangeException

    If amount of bytes requested is less than zero.

    AutoFilterRecord(Stream, out Int32)

    Read / initialize Constructor.

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

    Stream from which record data should be read.

    System.Int32 itemSize

    Size of read item.

    Exceptions
    Type Condition
    System.ArgumentNullException

    If stream is not specified.

    System.ApplicationException

    If stream does not support read or seek operations.

    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
    System.UInt16

    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
    System.Boolean

    IsBlank

    If filtered to blanks - true. Read-only.

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

    IsNonBlank

    If filtered to nonblanks - true. Read-only.

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

    IsPercent

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

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

    IsSimple1

    True if the first condition is a simple equality.

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

    IsSimple2

    True if the second condition is a simple equality.

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

    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
    System.Boolean

    IsTop10

    True if the condition is a Top 10 AutoFilter.

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

    MinimumRecordSize

    Read-only. Minimum possible size of the record.

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

    NeedDataArray

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

    Options

    Option flags. Read-only.

    Declaration
    public ushort Options { get; }
    Property Value
    Type
    System.UInt16

    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
    System.Int32

    Methods

    Clone()

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

    Declaration
    public object Clone()
    Returns
    Type Description
    System.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
    System.Int32
    Overrides
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.GetStoreSize(Syncfusion.XlsIO.ExcelVersion)

    ParseStructure(DataProvider, Int32, Int32, 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.

    System.Int32 iOffset

    Offset to the record's data.

    System.Int32 iLength

    Length of the record's data.

    ExcelVersion version

    Excel version used for infill.

    Overrides
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw.ParseStructure(Syncfusion.XlsIO.Parser.Biff_Records.DataProvider, System.Int32, System.Int32, Syncfusion.XlsIO.ExcelVersion)

    Implements

    IBiffStorage
    System.ICloneable

    Extension Methods

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