API Reference

Class

LegacyXlsArrayFormulaRecord

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

Describes an Array BIFF record discovered while importing a legacy XLS worksheet.

Inheritance

  • Object
  • LegacyXlsArrayFormulaRecord

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

Properties

public Int32 FirstRow { get; } #

Gets the first one-based row covered by the array formula.

public Int32 FirstColumn { get; } #

Gets the first one-based column covered by the array formula.

public Int32 LastRow { get; } #

Gets the last one-based row covered by the array formula.

public Int32 LastColumn { get; } #

Gets the last one-based column covered by the array formula.

public String Range { get; } #

Gets the A1 range covered by the array formula.

public UInt16 OptionFlags { get; } #

Gets the raw Array record option flags.

public Boolean AlwaysCalculate { get; } #

Gets whether the array formula asks Excel to calculate during the next recalculation.

public Int32 FormulaTokenByteCount { get; } #

Gets the byte count of the parsed formula token stream.

public Int32 FormulaExtraByteCount { get; } #

Gets the byte count of ancillary parsed-formula data after the token stream.

public Int32 MatchedFormulaCellCount { get; set; } #

Gets the number of cached formula cells matched to this Array record during import.

public Int32 DeclaredCellCount { get; } #

Gets the number of cells covered by the declared array formula range.

public Boolean FormulaTextProjected { get; set; } #

Gets whether OfficeIMO projected formula text onto at least one matched cached formula cell.

public Int32 RecordOffset { get; } #

Gets the byte offset of the Array BIFF record.

public UInt16 RecordType { get; } #

Gets the source BIFF record type.

public Int32 PayloadLength { get; } #

Gets the source BIFF payload length in bytes.