Class RefErrorPtg
This token contains the last reference to a deleted cell in the same sheet.
Inherited Members
Namespace: Syncfusion.XlsIO.Parser.Biff_Records.Formula
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
[ErrorCode("#REF!", 23)]
[Token]
[Token]
[Token]
public class RefErrorPtg : RefPtg, ICloneable, IRangeGetterToken, IRectGetter, IToken3D, IRangeGetterConstructors
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 | |
| Rectangle | rectSource | |
| System.Int32 | iDestSheetIndex | |
| 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. |