alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Class TableRecord

    This record stores information about a multiple operation table in the sheet. It follows the first FORMULA record of the cell range containing the operation table.

    Inheritance
    object
    BiffRecordRaw
    TableRecord
    Implements
    ICloneable
    IBiffStorage
    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.Table)]
    [CLSCompliant(false)]
    public class TableRecord : BiffRecordRaw, ICloneable, IBiffStorage

    Constructors

    TableRecord()

    Default constructor

    Declaration
    public TableRecord()

    TableRecord(Stream, out int)

    Read / initialize constructor.

    Declaration
    public TableRecord(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.

    TableRecord(int)

    Reserved for record's internal data array.

    Declaration
    public TableRecord(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.

    Fields

    OperationModeBitMask

    Bit mask for the operation mode.

    Declaration
    public const ushort OperationModeBitMask = 12
    Field Value
    Type
    ushort

    OperationModeStartBit

    First bit of the operation mode.

    Declaration
    public const int OperationModeStartBit = 2
    Field Value
    Type
    int

    Properties

    FirstCol

    Index to first column of the multiple operation table range.

    Declaration
    public byte FirstCol { get; set; }
    Property Value
    Type
    byte

    FirstRow

    Index to first row of the multiple operation table range.

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

    InputCellColumn

    Index to column of input cell (in mode 1x2 index to column of input cell for row input).

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

    InputCellColumnForColumn

    In mode 1x2 index to column of input cell for column input; else not used.

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

    InputCellRow

    Index to row of input cell (in mode 1x2 index to row of input cell for row input).

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

    InputCellRowForColumn

    In mode 1x2 index to row of input cell for column input; else not used.

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

    IsCalculateOnOpen

    True to calculate array formula on open.

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

    IsRecalculate

    True to always recalculate array formula.

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

    LastCol

    Index to last column of the multiple operation table range.

    Declaration
    public byte LastCol { get; set; }
    Property Value
    Type
    byte

    LastRow

    Index to last row of the multiple operation table range.

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

    MaximumRecordSize

    Read-only. Returns maximum possible size of record's internal data array.

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

    MinimumRecordSize

    Read-only. Returns minimum possible size of record's internal data array.

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

    OperationMode

    Whether to display outline symbols (in the gutters). Changes bits of m_usOptions.

    Declaration
    public ushort OperationMode { get; set; }
    Property Value
    Type
    ushort
    Exceptions
    Type Condition
    ArgumentOutOfRangeException

    When value is more than 4.

    Methods

    ParseStructure(DataProvider, int, int, ExcelVersion)

    Parse structure of record. Converts 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

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