Class PivotFormulaRecord
This record stores a PivotTable formula.
Inheritance
Inherited Members
Namespace: Syncfusion.XlsIO.Parser.Biff_Records.PivotTable
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
[CLSCompliant(false)]
[Biff(TBIFFRecord.PivotFormula)]
public class PivotFormulaRecord : BiffRecordRaw, ICloneable, IBiffStorage
Constructors
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 | Description |
---|---|
System.Int16 |
Reserved
Reserved. Should be set to zero. Read-only.
Declaration
public ushort Reserved { get; }
Property Value
Type | Description |
---|---|
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. |