TTokenRelativeCellAddress Class

A single cell address in the same sheet or to other sheet. It handles a reference relative to the current cell. So a reference in Cell A4 of RowOffset = -1 and ColOffset = 3 would mean the cell D3.

Syntax

Unit: FlexCel.Core

TTokenRelativeCellAddress = class(TToken);

Constructors

Name	Description
Create	Creates a new relative cell address token.

Properties

Name	Description
RowOffset	The number of rows after or before the current row. It might be negative.
ColOffset	The number of columns after or before the current column. It might be negative.
ExternalBookName	File where the reference points to, when this is a reference to other file. Empty or null if the reference is to the same file.
Sheet	Sheet where the reference points to. Empty or null if the reference points to the same sheet.