Class PivotFormulaRecord
This record stores a PivotTable formula.
Inheritance
Namespace: Syncfusion.XlsIO.Parser.Biff_Records.PivotTable
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
[Biff]
public class PivotFormulaRecord : BiffRecordRaw, ICloneable, IBiffStorageConstructors
PivotFormulaRecord()
Default constructor.
Declaration
public PivotFormulaRecord()PivotFormulaRecord(Int32)
Reserved for record's internal data array.
Declaration
public PivotFormulaRecord(int iReserve)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | iReserve | Amount of bytes for the data array. |
Exceptions
| Type | Condition |
|---|---|
| System.ArgumentOutOfRangeException | If amount of bytes requested is less than zero. |
PivotFormulaRecord(Stream, out Int32)
Read / initialize constructor.
Declaration
public PivotFormulaRecord(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 | When stream is not specified. |
| System.ApplicationException | When stream does not support read or seek operations. |
Properties
AppliedField
-1 if the calculated item formula applies to all fields, or, if positive, the field that this calculated item formulas applies to.
Declaration
public short AppliedField { get; set; }Property Value
| Type |
|---|
| System.Int16 |
Reserved
Reserved. Should be set to zero. Read-only.
Declaration
public ushort Reserved { get; }Property Value
| Type |
|---|
| System.UInt16 |
Methods
GetStoreSize(ExcelVersion)
Evaluates size of the required storage space.
Declaration
public override int GetStoreSize(ExcelVersion version)Parameters
| Type | Name | Description |
|---|---|---|
| ExcelVersion | version |
Returns
| Type | Description |
|---|---|
| System.Int32 | Size of the required storage space. |
Overrides
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. |