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
Namespace: Syncfusion.XlsIO.Parser.Biff_Records
Assembly: Syncfusion.XlsIO.UWP.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
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
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. |