Class RefErrorPtg

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

Inheritance
System.Object
Ptg
RefPtg
RefErrorPtg
Implements
System.ICloneable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
Namespace: Syncfusion.XlsIO.Parser.Biff_Records.Formula
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
[ErrorCode("#REF!", 23)]
[Token(FormulaToken.tRefErr1)]
[Token(FormulaToken.tRefErr2)]
[Token(FormulaToken.tRefErr3)]
public class RefErrorPtg : RefPtg, ICloneable, IRangeGetterToken, IRectGetter, IToken3D, IRangeGetter

Constructors

RefErrorPtg()

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

Declaration
public RefErrorPtg()

RefErrorPtg(DataProvider, Int32, ExcelVersion)

Creates token using data from array of bytes.

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

Object that provides access to the data.
System.Int32 offset

Offset to the token data.
ExcelVersion version

Excel version that was used to infill data provider.

RefErrorPtg(RefPtg)

Creates error token based on specified ref token.

Declaration
public RefErrorPtg(RefPtg dataHolder)
Parameters
Type Name Description
RefPtg dataHolder

Token to take data from.

RefErrorPtg(String)

Declaration
public RefErrorPtg(string errorName)
Parameters
Type Name Description
System.String errorName

RefErrorPtg(String, IWorkbook)

Declaration
public RefErrorPtg(string errorName, IWorkbook book)
Parameters
Type Name Description
System.String errorName
IWorkbook book

Fields

ReferenceError

Declaration
public const string ReferenceError = "#REF!"
Field Value
Type
System.String

Methods

ConvertPtgToNPtg(IWorkbook, Int32, Int32)

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.
System.Int32 iRow

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

Represents first column from cells range of shared formula.Zero-based.
Returns
Type Description
Ptg

New token for shared formula.
Overrides

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.

IndexToCode(Int32)

Converts reference index to token code.

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

Reference index.
Returns
Type Description
FormulaToken

Token code.

Offset(Int32, Int32, Int32, Int32, Rectangle, Int32, Rectangle, out Boolean, 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
System.Int32 iCurSheetIndex
System.Int32 iTokenRow
System.Int32 iTokenColumn
System.Int32 iSourceSheetIndex
System.Drawing.Rectangle rectSource
System.Int32 iDestSheetIndex
System.Drawing.Rectangle rectDest
System.Boolean bChanged
WorkbookImpl book

Parent workbook.
Returns
Type
Ptg
Overrides

ToString()

Converts token to a string.

Declaration
public override string ToString()
Returns
Type Description
System.String

String representation of this token.
Overrides

ToString(FormulaUtil, Int32, Int32, Boolean, NumberFormatInfo, Boolean)

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.
System.Int32 iRow

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

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

Indicates whether R1C1 notation should be used.
System.Globalization.NumberFormatInfo numberFormat
System.Boolean isForSerialization
Returns
Type Description
System.String

String representation of this token.
Overrides

Implements

System.ICloneable