.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

DocumentSettings.R1C1ReferenceStyle Property

Gets or sets whether the workbook uses the R1C1 reference style.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll

Declaration

bool R1C1ReferenceStyle { get; set; }
Property R1C1ReferenceStyle As Boolean

Property Value

Type Description
Boolean

true, if the R1C1 reference style is turned on; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type Path to R1C1ReferenceStyle
IWorkbook
.DocumentSettings.R1C1ReferenceStyle
Workbook
.DocumentSettings.R1C1ReferenceStyle

Remarks

The R1C1 reference style refers to both the rows and columns on the worksheet using numbers. Cell location is indicated by an "R" followed by the row number and a "C" followed by the column number. For more information, refer to Cell Referencing.

Use the following code to switch on the R1C1 reference style in a workbook loaded in the SpreadsheetControl:


spreadsheetControl1.Document.DocumentSettings.R1C1ReferenceStyle = true;

Examples

This example demonstrates how to create formulas using the R1C1 reference style. To do this, switch on the DocumentSettings.R1C1ReferenceStyle option and assign a formula string containing R1C1 cell references to the CellRange.Formula property. To obtain a cell reference in the R1C1 reference style, you can use the CellRange.GetReferenceR1C1 method.

// Switch on the R1C1 reference style in a workbook.
workbook.DocumentSettings.R1C1ReferenceStyle = true;

// Specify a formula with relative R1C1 references in cell D2
// to add values contained in cells A2 through A11.
worksheet.Cells["D2"].Formula = "=SUM(RC[-3]:R[9]C[-3])";

// Specify a formula with absolute R1C1 references 
// to add values contained in cells A2 through A11.
worksheet.Cells["D3"].Formula = "=SUM(R2C1:R11C1)";
See Also