SheetReference.Type Property
Gets or sets the type of the worksheet reference.
Namespace: DevExpress.Spreadsheet.Formulas
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| SheetReferenceType | A SheetReference enumeration member that indicates the reference type. |
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. |