API Reference

Class

LegacyXlsDataConsolidationSettings

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

Represents worksheet-level BIFF DCon data-consolidation settings.

Inheritance

  • Object
  • LegacyXlsDataConsolidationSettings

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 LegacyXlsDataConsolidationSettings(LegacyXlsDataConsolidationFunction function, Boolean usesTopLabels, Boolean usesLeftLabels, Boolean linksToSourceData, UInt16 rawFunction, UInt16 optionFlags) #

Creates worksheet data-consolidation settings parsed from a BIFF DCon record.

Parameters

function OfficeIMO.Excel.LegacyXls.Model.LegacyXlsDataConsolidationFunction requiredposition: 0
usesTopLabels System.Boolean requiredposition: 1
usesLeftLabels System.Boolean requiredposition: 2
linksToSourceData System.Boolean requiredposition: 3
rawFunction System.UInt16 requiredposition: 4
optionFlags System.UInt16 requiredposition: 5

Properties

public LegacyXlsDataConsolidationFunction Function { get; } #

Gets the decoded data-consolidation aggregation function.

public Boolean UsesTopLabels { get; } #

Gets whether the first source row supplies category labels.

public Boolean UsesLeftLabels { get; } #

Gets whether the first source column supplies category labels.

public Boolean LinksToSourceData { get; } #

Gets whether the consolidation links to source data.

public UInt16 RawFunction { get; } #

Gets the raw BIFF aggregation function identifier.

public UInt16 OptionFlags { get; } #

Gets the raw BIFF data-consolidation option flags.