HotXLS Delphi Excel Read Write Library / Component Developers Guide
Reference
>
IXLSWorkbook
>
ReferenceStyle
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