GrapeCity.Documents.Excel.ReferenceStyle

ReferenceStyle Enum

Specifies the cell reference style used in a workbook.

Use this enum with ReferenceStyle to control whether formulas and references use A1 notation or R1C1 notation.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum ReferenceStyle : short

Public Enum ReferenceStyle As Short

Examples

workbook.ReferenceStyle = ReferenceStyle.R1C1;
worksheet.Range["A1"].FormulaR1C1 = "=R[1]C[1]";
workbook.ReferenceStyle = ReferenceStyle.A1;
worksheet.Range["B2"].Formula = "=A1";

Fields

Name Description

Name	Description
A1	Specifies to use A1 style. Absolute references are written as `$A$1` and relative references are written as `A1`.
R1C1	Specifies the R1C1 reference style for cell references. Absolute references are written as `R1C1`. Relative references are written as `R[y]C[x]`, where `y` is the relative row offset and `x` is the relative column offset.

Specifies to use A1 style. Absolute references are written as $A$1 and relative references are written as A1.

R1C1

Specifies the R1C1 reference style for cell references.

Absolute references are written as R1C1. Relative references are written as R[y]C[x], where y is the relative row offset and x is the relative column offset.