Skip to main content
Row

DocumentSettings.R1C1ReferenceStyle Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

bool R1C1ReferenceStyle { get; set; }

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;

Example

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.

View Example

// 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)";

The following code snippets (auto-collected from DevExpress Examples) contain references to the R1C1ReferenceStyle property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also