The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

DocumentSettings.R1C1ReferenceStyle Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

bool R1C1ReferenceStyle { get; set; }
Property R1C1ReferenceStyle As Boolean
bool R1C1ReferenceStyle { get; set; }
Property R1C1ReferenceStyle As Boolean
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 Value

Type Description
Boolean

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

Property Value

Type Description
Boolean

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

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