SheetReferenceType Enum
Lists types of the worksheet reference.
Namespace: DevExpress.Spreadsheet.Formulas
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Members
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. |
Related API Members
The following properties accept/return SheetReferenceType values:
Remarks
An object of the SheetReferenceType type is used to specify the SheetReference.Type property value.