SheetReference.Type Property
Gets or sets the type of the worksheet reference.
Namespace: DevExpress.Spreadsheet.Formulas
Assembly:
DevExpress.Spreadsheet.v20.2.Core.dll
Declaration
public SheetReferenceType Type { get; set; }
Public Property Type As SheetReferenceType
Available values:
Name |
Description |
Simple
|
A reference that contains the sheet name and the cell reference. A sheet name is the name of the sheet in the current workbook, for example “Sheet1!A2”.
|
CurrentWorksheet
|
Reference type that is specific for defined names. For example, if the DefinedName.RefersTo property is the “!$D$6” string, then the type of this reference is the CurrentWorksheet.
|
CurrentWorkbook
|
A type that is used sparsely. A reference of this type can be created in Microsoft Excel for a defined name. It is in the form “temp.xslx!DefinedName” where “temp.xslx” is the name of the file containing the reference.
|
External
|
A reference to an external worksheet.
|
Invalid
|
Invalid sheet reference in expressions used in defined names.
|
See Also