TdxSpreadSheetDefinedName.Scope Property

Specifies the scope of the defined name.

Declaration

property Scope: TdxSpreadSheetCustomView read; write;

Property Value

Type
TdxSpreadSheetCustomView

Remarks

Use this property to change the scope of the existing defined name. The Scope property specifies a worksheet object in which the defined name can be used. If the Scope property’s value is nil, the defined name can be used within the entire workbook. Since defined names cannot refer to other workbooks, the opened workbook is the maximum scope that a defined name can have.

Delphi

// The defined name can be used only within the second worksheet.
  dxSpreadSheet1.DefinedNames[0].Scope := dxSpreadSheet1.Sheets[1];

C++

// The defined name can be used only within the second worksheet.
  dxSpreadSheet1->DefinedNames->Items[0].Scope = dxSpreadSheet1->Sheets[1];