officefileapi-devexpress-dot-spreadsheet-dot-formulas-e6e175ed.md
Lists types of the worksheet reference.
Namespace : DevExpress.Spreadsheet.Formulas
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum SheetReferenceType
Public Enum SheetReferenceType
| 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.
|
The following properties accept/return SheetReferenceType values:
An object of the SheetReferenceType type is used to specify the SheetReference.Type property value.
See Also