alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Class Area3DPtg

    This token contains a 3D reference or an external reference to a cell range.

    Inheritance
    object
    Ptg
    AreaPtg
    Area3DPtg
    AreaError3DPtg
    Implements
    ICloneable
    IRangeGetterToken
    IRectGetter
    IToken3D
    ISheetReference
    IReference
    IRangeGetter
    Inherited Members
    AreaPtg.ConvertFullRowColumnAreaPtgs(bool)
    AreaPtg.ConvertToError()
    AreaPtg.FirstColumn
    AreaPtg.FirstOptions
    AreaPtg.FirstRow
    AreaPtg.Get3DToken(int)
    AreaPtg.GetRectangle()
    AreaPtg.IsFirstColumnRelative
    AreaPtg.IsFirstRowRelative
    AreaPtg.IsLastColumnRelative
    AreaPtg.IsLastRowRelative
    AreaPtg.IsWholeColumn(IWorkbook)
    AreaPtg.IsWholeColumns(IWorkbook)
    AreaPtg.IsWholeRow(IWorkbook)
    AreaPtg.IsWholeRows(IWorkbook)
    AreaPtg.LastColumn
    AreaPtg.LastOptions
    AreaPtg.LastRow
    AreaPtg.Offset(int, int, WorkbookImpl)
    AreaPtg.SetArea(int, int, string, string, string, string, bool, IWorkbook)
    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.tArea3d1)]
    [Token(FormulaToken.tArea3d2)]
    [Token(FormulaToken.tArea3d3)]
    [CLSCompliant(false)]
    public class Area3DPtg : AreaPtg, ICloneable, IRangeGetterToken, IRectGetter, IToken3D, ISheetReference, IReference, IRangeGetter

    Constructors

    Area3DPtg()

    Default constructor. To prevent user from creating a token without parameters and to allow descendants do this.

    Declaration
    public Area3DPtg()

    Area3DPtg(DataProvider, int, ExcelVersion)

    Creates token using data from an array of bytes.

    Declaration
    public Area3DPtg(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.

    Area3DPtg(Area3DPtg)

    Creates new token based on another Area3D token.

    Declaration
    public Area3DPtg(Area3DPtg ptg)
    Parameters
    Type Name Description
    Area3DPtg ptg

    Token to copy.

    Area3DPtg(int, int, int, int, int, byte, byte)

    Initializes new token.

    Declaration
    public Area3DPtg(int iSheetIndex, int iFirstRow, int iFirstCol, int iLastRow, int iLastCol, byte firstOptions, byte lastOptions)
    Parameters
    Type Name Description
    int iSheetIndex

    Worksheet reference index.

    int iFirstRow

    Zero-based first row index.

    int iFirstCol

    Zero-based first column index.

    int iLastRow

    Zero-based last row index.

    int iLastCol

    Zero-based last column index.

    byte firstOptions

    First cell options.

    byte lastOptions

    Second cell options.

    Area3DPtg(int, int, int, string, string, string, string, bool, IWorkbook)

    Initializes new token.

    Declaration
    public Area3DPtg(int iCellRow, int iCellColumn, int iRefIndex, string strFirstRow, string strFirstColumn, string strLastRow, string strLastColumn, bool bR1C1, IWorkbook book)
    Parameters
    Type Name Description
    int iCellRow

    Zero-based row index of the cell that will contain new token.

    int iCellColumn

    Zero-based column index of the cell that will contain new token.

    int iRefIndex

    Worksheet reference index.

    string strFirstRow

    String representation of the first row of the area.

    string strFirstColumn

    String representation of the first column of the area.

    string strLastRow

    String representation of the last row of the area.

    string strLastColumn

    String representation of the last column of the area.

    bool bR1C1

    Indicates whether strings are in R1C1 notation.

    IWorkbook book

    Parent workbook.

    Area3DPtg(string, IWorkbook)

    Constructs token by string value and parent workbook.

    Declaration
    public Area3DPtg(string strFormula, IWorkbook parent)
    Parameters
    Type Name Description
    string strFormula

    String representation of the token.

    IWorkbook parent

    Workbook containing the token.

    Exceptions
    Type Condition
    ArgumentException

    When specified formula string is not valid Area3D string.

    Properties

    RefIndex

    Reference to the worksheet. Read-only.

    Declaration
    public ushort RefIndex { get; set; }
    Property Value
    Type
    ushort

    Methods

    BaseToString(FormulaUtil, int, int, bool)

    Calls ToString method of the base (not 3d) class.

    Declaration
    public string BaseToString(FormulaUtil formulaUtil, int iRow, int iColumn, bool bR1C1)
    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.

    Returns
    Type Description
    string

    String representation of this token.

    CodeToIndex()

    Declaration
    public override int CodeToIndex()
    Returns
    Type
    int
    Overrides
    AreaPtg.CodeToIndex()

    CodeToIndex(FormulaToken)

    Converts specified token code to index.

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

    Token code for which index is required.

    Returns
    Type Description
    int

    Index that corresponds to the code.

    Exceptions
    Type Condition
    ArgumentOutOfRangeException

    When index is not one of tArea1, tArea2, tArea3.

    ConvertPtgToNPtg(IWorkbook, int, int)

    Converts tokens from regular formula into tokens from shared formula.

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

    Parent workbook.

    int iRow

    Represents first row from cells range of shared formula.Zero-base.

    int iColumn

    Represents first column from cells range of shared formula.Zero-based.

    Returns
    Type Description
    Ptg

    New token for shared formula.

    Overrides
    AreaPtg.ConvertPtgToNPtg(IWorkbook, int, int)

    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)

    ConvertToErrorPtg()

    Converts incorrect area range to corresponding error ptg.

    Declaration
    public override AreaPtg ConvertToErrorPtg()
    Returns
    Type
    AreaPtg
    Overrides
    AreaPtg.ConvertToErrorPtg()

    GetCorrespondingErrorCode()

    Declaration
    public override FormulaToken GetCorrespondingErrorCode()
    Returns
    Type
    FormulaToken
    Overrides
    AreaPtg.GetCorrespondingErrorCode()

    GetRange(IWorkbook, IWorksheet)

    Returns range represented by the token that implements this interface.

    Declaration
    public IRange GetRange(IWorkbook book, IWorksheet sheet)
    Parameters
    Type Name Description
    IWorkbook book

    Workbook that contains range.

    IWorksheet sheet

    Worksheet that contains range.

    Returns
    Type Description
    IRange

    Range represented by the token.

    GetSize(ExcelVersion)

    Read-only. Size of the token.

    Declaration
    public override int GetSize(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type
    int
    Overrides
    AreaPtg.GetSize(ExcelVersion)

    IndexToCode(int)

    Converts specified index to the token code.

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

    Function parameter index.

    Returns
    Type Description
    FormulaToken

    Token code that corresponds to the specified index.

    Exceptions
    Type Condition
    ArgumentOutOfRangeException

    When index is less than 1 or greater than 3.

    InfillPTG(DataProvider, ref int, ExcelVersion)

    Infill PTG structure.

    Declaration
    public override void InfillPTG(DataProvider provider, ref int offset, ExcelVersion version)
    Parameters
    Type Name Description
    DataProvider provider

    Represents storage.

    int offset

    Offset in storage.

    ExcelVersion version

    Excel version that was used to infill data provider.

    Overrides
    AreaPtg.InfillPTG(DataProvider, ref int, ExcelVersion)

    Offset(int, int, int, int, Rectangle, int, Rectangle, out bool, WorkbookImpl)

    Declaration
    public override Ptg Offset(int iCurSheetIndex, int iTokenRow, int iTokenColumn, int iSourceSheetIndex, Rectangle rectSource, int iDestSheetIndex, Rectangle rectDest, out bool bChanged, WorkbookImpl book)
    Parameters
    Type Name Description
    int iCurSheetIndex
    int iTokenRow
    int iTokenColumn
    int iSourceSheetIndex
    Rectangle rectSource
    int iDestSheetIndex
    Rectangle rectDest
    bool bChanged
    WorkbookImpl book

    Parent workbook.

    Returns
    Type
    Ptg
    Overrides
    AreaPtg.Offset(int, int, int, int, Rectangle, int, Rectangle, out bool, WorkbookImpl)

    SetSheetIndex(string, IWorkbook)

    Sets index of the sheet in the correct value, taking information from the specified workbook.

    Declaration
    protected void SetSheetIndex(string sheetName, IWorkbook parent)
    Parameters
    Type Name Description
    string sheetName

    Name of the worksheet that is referenced.

    IWorkbook parent

    Workbook that contains this record and must contain specified worksheet.

    Exceptions
    Type Condition
    ParseException

    Unable to find specified worksheet in the workbook, possibly because wasn't loaded yet.

    SetValues(Match, IWorkbook)

    Set area values such as reference indexes, first and last columns, and rows.

    Declaration
    protected void SetValues(Match m, IWorkbook parent)
    Parameters
    Type Name Description
    Match m

    Match that contains such groups SheetName, Column1, Column2, Row1, Row2.

    IWorkbook parent

    Workbook that contains this token.

    ToByteArray(ExcelVersion)

    Converts token to array of bytes.

    Declaration
    public override byte[] ToByteArray(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type Description
    byte[]

    Array of bytes that represents this token.

    Overrides
    AreaPtg.ToByteArray(ExcelVersion)

    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)

    ValidateSheetName(string)

    To check the sheet name it's having any special charecter or not

    Declaration
    public static bool ValidateSheetName(string value)
    Parameters
    Type Name Description
    string value
    Returns
    Type
    bool

    Implements

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