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

System.Object

Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw

TableRecord

Implements

System.ICloneable

IBiffStorage

Namespace: Syncfusion.XlsIO.Parser.Biff_Records

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

[Biff]
public class TableRecord : BiffRecordRaw, ICloneable, IBiffStorage

Constructors

TableRecord()

Default constructor

Declaration

public TableRecord()

TableRecord(Int32)

Reserved for record's internal data array.

Declaration

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

TableRecord(Stream, out Int32)

Read / initialize constructor.

Declaration

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

Fields

OperationModeBitMask

Bit mask for the operation mode.

Declaration

public const ushort OperationModeBitMask = 12

Field Value

Type
System.UInt16

OperationModeStartBit

First bit of the operation mode.

Declaration

public const int OperationModeStartBit = 2

Field Value

Type
System.Int32

Properties

FirstCol

Index to first column of the multiple operation table range.

Declaration

public byte FirstCol { get; set; }

Property Value

Type
System.Byte

FirstRow

Index to first row of the multiple operation table range.

Declaration

public ushort FirstRow { get; set; }

Property Value

Type
System.UInt16

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

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

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

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

IsCalculateOnOpen

True to calculate array formula on open.

Declaration

public bool IsCalculateOnOpen { get; set; }

Property Value

Type
System.Boolean

IsRecalculate

True to always recalculate array formula.

Declaration

public bool IsRecalculate { get; set; }

Property Value

Type
System.Boolean

LastCol

Index to last column of the multiple operation table range.

Declaration

public byte LastCol { get; set; }

Property Value

Type
System.Byte

LastRow

Index to last row of the multiple operation table range.

Declaration

public ushort LastRow { get; set; }

Property Value

Type
System.UInt16

MaximumRecordSize

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

Declaration

public override int MaximumRecordSize { get; }

Property Value

Type
System.Int32

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

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

Exceptions

Type	Condition
System.ArgumentOutOfRangeException	When value is more than 4.

Methods

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

System.ICloneable

IBiffStorage