HotXLS Delphi Excel Read Write Library / Component Developers Guide loslab Inc.

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;
Copyright©2007-2019 loslab.com