DocumentSettings.R1C1ReferenceStyle Property
Gets or sets whether the workbook uses the R1C1 reference style.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
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 |
|
| Workbook |
|
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:
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.
// 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)";
Related GitHub Examples
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.