GrapeCity.Documents.Excel.Workbook.ReferenceStyle

ReferenceStyle Property

ReferenceStyle

Gets or sets the reference style used by the workbook.

The reference style determines how cell references are represented in formulas and addresses, such as A1 style references like A1 or R1C1 style references like R1C1.

Declaration

public ReferenceStyle ReferenceStyle { get; set; }

Public Property ReferenceStyle As ReferenceStyle

Implements

IWorkbook.ReferenceStyle

Examples

worksheet.Range["B1"].Value = 100;
worksheet.Range["C1"].Value = 200;
workbook.ReferenceStyle = ReferenceStyle.R1C1;
ReferenceStyle style = workbook.ReferenceStyle;
worksheet.Range["A1"].Formula = "=RC[1]+RC[2]";