Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

LegacyXlsPivotLineItem

Namespace OfficeIMO.Excel.LegacyXls.Model
Assembly OfficeIMO.Excel
Source revision 02c4d39034ec with working tree changes
Modifiers sealed

Describes one SXLI PivotTable row or column line item.

Inheritance

  • Object
  • LegacyXlsPivotLineItem

Usage

Explore 1 API references to this type

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

Returned or exposed by 1

Constructors

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

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
entrySlotCount System.Int32? = null optionalposition: 10

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 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 Int32 EntrySlotCount { get; } #

Gets the physical entry slots occupied by this line item in the SXLI record.

public IReadOnlyList<String> EntryIndexNames { get; } #

Gets stable names for the pivot line entry indexes.