Class PivotViewFieldsExRecord
This record contains extended PivotTable view fields information.
Inherited Members
Namespace: Syncfusion.XlsIO.Parser.Biff_Records.PivotTable
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
[Biff(TBIFFRecord.PivotViewFieldsEx)]
[CLSCompliant(false)]
public class PivotViewFieldsExRecord : BiffRecordRawWithArray, ICloneable, IBiffStorage, IDisposable
Constructors
PivotViewFieldsExRecord()
Default constructor.
Declaration
public PivotViewFieldsExRecord()
PivotViewFieldsExRecord(Stream, out int)
Read / initialize constructor.
Declaration
public PivotViewFieldsExRecord(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 | When stream is not specified. |
| ApplicationException | When stream does not support read or seek operations. |
PivotViewFieldsExRecord(int)
Reserved for record's internal data array.
Declaration
public PivotViewFieldsExRecord(int iReserve)
Parameters
| Type | Name | Description |
|---|---|---|
| int | iReserve | Amount of bytes for the data array. |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | If amount of bytes requested is less than zero. |
Properties
IsAscendShow
Show top values.
Declaration
public bool IsAscendShow { get; set; }
Property Value
| Type |
|---|
| bool |
IsAscendSort
Autosort ascending.
Declaration
public bool IsAscendSort { get; set; }
Property Value
| Type |
|---|
| bool |
IsAutoShow
Autoshow is enabled.
Declaration
public bool IsAutoShow { get; set; }
Property Value
| Type |
|---|
| bool |
IsAutoSort
Autosort is enabled.
Declaration
public bool IsAutoSort { get; set; }
Property Value
| Type |
|---|
| bool |
IsCalculateField
Calculated field.
Declaration
public bool IsCalculateField { get; set; }
Property Value
| Type |
|---|
| bool |
IsDragToColumn
User can drag field to column area.
Declaration
public bool IsDragToColumn { get; set; }
Property Value
| Type |
|---|
| bool |
IsDragToHide
User can remove field from fiew.
Declaration
public bool IsDragToHide { get; set; }
Property Value
| Type |
|---|
| bool |
IsDragToPage
User can drag field to page area.
Declaration
public bool IsDragToPage { get; set; }
Property Value
| Type |
|---|
| bool |
IsDragToRow
User can drag field to row area.
Declaration
public bool IsDragToRow { get; set; }
Property Value
| Type |
|---|
| bool |
IsServerBased
This field is a server-based field in the page area.
Declaration
public bool IsServerBased { get; set; }
Property Value
| Type |
|---|
| bool |
IsShowAllItems
Show all items for this field.
Declaration
public bool IsShowAllItems { get; set; }
Property Value
| Type |
|---|
| bool |
ItemsNumber
Number of items to show for AutoShow, default is 10.
Declaration
public byte ItemsNumber { get; set; }
Property Value
| Type |
|---|
| byte |
NumberFormat
Number format of field or 0 if none.
Declaration
public ushort NumberFormat { get; set; }
Property Value
| Type |
|---|
| ushort |
Options
Option flags. Read-only.
Declaration
public ushort Options { get; }
Property Value
| Type |
|---|
| ushort |
Reserved
Reserved. Read-only.
Declaration
public byte Reserved { get; }
Property Value
| Type |
|---|
| byte |
ShowIndex
0-based index of data field that AutoShow is based on.
Declaration
public ushort ShowIndex { get; set; }
Property Value
| Type |
|---|
| ushort |
SortIndex
0-based index of data field that AutoSort is based on or 0xFFFF for current field.
Declaration
public ushort SortIndex { get; set; }
Property Value
| Type |
|---|
| ushort |
SubTotalName
Specifies the custom text that is displayed for the subtotals label.
Declaration
public string SubTotalName { get; set; }
Property Value
| Type |
|---|
| string |
Methods
ParseStructure()
Parse structure of record. Convert Data buffer to special values according to record specification.
Declaration
public override void ParseStructure()