alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Class AreaNPtg

    This token contains the reference to a cell range in the same sheet.

    Inheritance
    object
    Ptg
    AreaPtg
    AreaNPtg
    Implements
    ICloneable
    IRangeGetterToken
    IRangeGetter
    IRectGetter
    IToken3D
    Inherited Members
    AreaPtg.CodeToIndex()
    AreaPtg.ConvertFullRowColumnAreaPtgs(bool)
    AreaPtg.ConvertPtgToNPtg(IWorkbook, int, int)
    AreaPtg.ConvertToError()
    AreaPtg.ConvertToErrorPtg()
    AreaPtg.FirstOptions
    AreaPtg.FirstRow
    AreaPtg.Get3DToken(int)
    AreaPtg.GetCorrespondingErrorCode()
    AreaPtg.GetRange(IWorkbook, IWorksheet)
    AreaPtg.GetRectangle()
    AreaPtg.GetSize(ExcelVersion)
    AreaPtg.InfillPTG(DataProvider, ref int, ExcelVersion)
    AreaPtg.IsFirstColumnRelative
    AreaPtg.IsFirstRowRelative
    AreaPtg.IsLastColumnRelative
    AreaPtg.IsLastRowRelative
    AreaPtg.IsWholeColumn(IWorkbook)
    AreaPtg.IsWholeColumns(IWorkbook)
    AreaPtg.IsWholeRow(IWorkbook)
    AreaPtg.IsWholeRows(IWorkbook)
    AreaPtg.LastOptions
    AreaPtg.LastRow
    AreaPtg.Offset(int, int, int, int, Rectangle, int, Rectangle, out bool, WorkbookImpl)
    AreaPtg.Offset(int, int, WorkbookImpl)
    AreaPtg.SetArea(int, int, string, string, string, string, bool, IWorkbook)
    AreaPtg.ToByteArray(ExcelVersion)
    AreaPtg.UpdateRectangle(Rectangle)
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    Ptg.Clone()
    Ptg.CompareArrays(Ptg[], Ptg[])
    Ptg.CompareContent(Ptg)
    Ptg.CompareTo(Ptg)
    Ptg.GetString16Bit(byte[], int)
    Ptg.GetString16Bit(byte[], int, out int)
    Ptg.IndexToCode(FormulaToken, int)
    Ptg.IsOperation
    Ptg.RectangleContains(Rectangle, int, int)
    Ptg.TokenCode
    Ptg.ToString()
    Ptg.ToString(FormulaUtil)
    Ptg.ToString(FormulaUtil, int, int, bool)
    Ptg.ToString(FormulaUtil, int, int, bool, NumberFormatInfo)
    Ptg.ToString(FormulaUtil, int, int, bool, NumberFormatInfo, bool, IWorksheet)
    Ptg.ToString(int, int, bool)
    Namespace: Syncfusion.XlsIO.Parser.Biff_Records.Formula
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    [Token(FormulaToken.tAreaN1)]
    [Token(FormulaToken.tAreaN2)]
    [Token(FormulaToken.tAreaN3)]
    [CLSCompliant(false)]
    public class AreaNPtg : AreaPtg, ICloneable, IRangeGetterToken, IRangeGetter, IRectGetter, IToken3D

    Constructors

    AreaNPtg()

    Default constructor. To prevent user from creating tokens without parameters and to allow descendants.

    Declaration
    public AreaNPtg()

    AreaNPtg(DataProvider, int, ExcelVersion)

    Creates token using data from an array of bytes.

    Declaration
    public AreaNPtg(DataProvider provider, int offset, ExcelVersion version)
    Parameters
    Type Name Description
    DataProvider provider

    Object that provides access to the data.

    int offset

    Offset to the token data.

    ExcelVersion version

    Excel version that was used to infill data provider.

    AreaNPtg(string, IWorkbook)

    Creates token by its string representation.

    Declaration
    public AreaNPtg(string strFormula, IWorkbook book)
    Parameters
    Type Name Description
    string strFormula

    String representation of the formula.

    IWorkbook book

    Parent workbook.

    Exceptions
    Type Condition
    ArgumentException

    When specified string is not a valid token string.

    Properties

    FirstColumn

    First column offset (-128..127).

    Declaration
    public short FirstColumn { get; set; }
    Property Value
    Type
    short

    LastColumn

    Column offset (-128..127).

    Declaration
    public short LastColumn { get; set; }
    Property Value
    Type
    short

    Methods

    CodeToIndex(FormulaToken)

    Converts token code to index (inverse operation to IndexToCode).

    Declaration
    public static int CodeToIndex(FormulaToken token)
    Parameters
    Type Name Description
    FormulaToken token

    Token code (should be one of tAreaN1, tAreaN2, tAreaN3).

    Returns
    Type Description
    int

    Reference index.

    ConvertSharedToken(IWorkbook, int, int)

    Converts token from shared formula into token from regular formula.

    Declaration
    public override Ptg ConvertSharedToken(IWorkbook parent, int iRow, int iColumn)
    Parameters
    Type Name Description
    IWorkbook parent

    Parent workbook.

    int iRow

    Row index.

    int iColumn

    Column index.

    Returns
    Type Description
    Ptg

    New token for regular formula.

    Overrides
    Ptg.ConvertSharedToken(IWorkbook, int, int)

    IndexToCode(int)

    Converts reference index to token code.

    Declaration
    public static FormulaToken IndexToCode(int index)
    Parameters
    Type Name Description
    int index

    Reference index.

    Returns
    Type Description
    FormulaToken

    Token code.

    ToString(FormulaUtil, int, int, bool, NumberFormatInfo, bool)

    Converts token to a string.

    Declaration
    public override string ToString(FormulaUtil formulaUtil, int iRow, int iColumn, bool bR1C1, NumberFormatInfo numberFormat, bool isForSerialization)
    Parameters
    Type Name Description
    FormulaUtil formulaUtil

    Formula util.

    int iRow

    Zero-based row index of the cell that contains this token.

    int iColumn

    Zero-based row index of the cell that contains this token.

    bool bR1C1

    Indicates whether R1C1 notation should be used.

    NumberFormatInfo numberFormat
    bool isForSerialization
    Returns
    Type Description
    string

    String representation of this token.

    Overrides
    AreaPtg.ToString(FormulaUtil, int, int, bool, NumberFormatInfo, bool)

    Implements

    ICloneable
    IRangeGetterToken
    IRangeGetter
    IRectGetter
    IToken3D
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved