HotXLS Docs

ReferenceStyle property

Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write Integer.

Syntax

property ReferenceStyle: Integer;

Description

ReferenceStyle can be one of these constants:
xlA1 A1 reference style
xlR1C1 R1C1 reference style

Example

This example sets R1C1 reference style for a Workbook.

Workbook.ReferenceStyle := xlR1C1;