TXlsNamedRange Record

An Excel named range.

Pascal

TXlsNamedRange = record
  Name: string;
  RangeFormula: string;
  OptionFlags: integer;
  NameSheetIndex: integer;
end;

C++

struct TXlsNamedRange {
  AnsiString Name;
  AnsiString RangeFormula;
  int OptionFlags;
  int NameSheetIndex;
};

Members	Description
Name: string;	The name of the range.
RangeFormula: string;	This is a formula defining the range. It can be used to define complex ranges. For example you can use "=Sheet1!$A1:$B65536,Sheet1!$A1:$IV2".
OptionFlags: integer;	Options of the range as an integer. Bit Mask Description 0 0001h = 1 if the name is hidden 1 0002h = 1 if the name is a function 2 0004h = 1 if the name is a Visual Basic procedure 3 0008h = 1 if the name is a function or command name on a macro sheet 4 0010h = 1 if the name contains a complex function 5 0020h = 1 if the name is a built-in name. (NOTE: When setting a built in named range, this bit is automatically set)
NameSheetIndex: integer;	The sheet index for the name (1 based). A named range can have the same name than other as long as they are on different sheets. The default value(0) means a global named range, not tied to any specific sheet.

What do you think about this topic? Send feedback!