Table of Contents

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

Namespace: FlexCel.Core

public class TTokenRelativeCellAddress: TToken

Constructors

Name Description
TTokenRelative​Cell​Address 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.