API Reference

Class

LegacyXlsPivotLineItem

Namespace OfficeIMO.Excel.LegacyXls.Model
Assembly OfficeIMO.Excel
Modifiers sealed

Describes one SXLI PivotTable row or column line item.

Inheritance

  • Object
  • LegacyXlsPivotLineItem

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Constructors

public LegacyXlsPivotLineItem(Int16 sameAsPreviousCount, UInt16 itemType, Int16 entryCount, Boolean multiDataName, Byte dataIndex, Boolean subtotal, Boolean blockTotal, Boolean grandTotal, Boolean multiDataOnAxis, IReadOnlyList<Int16> entryIndexes) #

Creates a PivotTable line item.

Parameters

sameAsPreviousCount System.Int16 requiredposition: 0
itemType System.UInt16 requiredposition: 1
entryCount System.Int16 requiredposition: 2
multiDataName System.Boolean requiredposition: 3
dataIndex System.Byte requiredposition: 4
subtotal System.Boolean requiredposition: 5
blockTotal System.Boolean requiredposition: 6
grandTotal System.Boolean requiredposition: 7
multiDataOnAxis System.Boolean requiredposition: 8
entryIndexes System.Collections.Generic.IReadOnlyList{System.Int16} requiredposition: 9

Properties

public Int16 SameAsPreviousCount { get; } #

Gets the count of leading entries that repeat the previous line item.

public UInt16 ItemType { get; } #

Gets the raw SXLI item type.

public Nullable<LegacyXlsPivotLineItemType> ItemTypeKind { get; } #

Gets the decoded SXLI item type, when known.

public String ItemTypeName { get; } #

Gets the SXLI item type name or a stable raw identifier for unknown values.

public Int16 EntryCount { get; } #

Gets the declared number of line entries.

public Boolean MultiDataName { get; } #

Gets whether the data field name is used for the total or subtotal.

public Byte DataIndex { get; } #

Gets the data item index associated with a subtotal.

public Boolean Subtotal { get; } #

Gets whether the line item represents a subtotal.

public Boolean BlockTotal { get; } #

Gets whether the line item represents a block total.

public Boolean GrandTotal { get; } #

Gets whether the line item represents a grand total.

public Boolean MultiDataOnAxis { get; } #

Gets whether a line entry represents a data item index.

public IReadOnlyList<Int16> EntryIndexes { get; } #

Gets the raw pivot line entry indexes.

public IReadOnlyList<String> EntryIndexNames { get; } #

Gets stable names for the pivot line entry indexes.