Gets or sets whether the workbook uses the R1C1 reference style.
true, if the R1C1 reference style is turned on; otherwise, false.
You can access this nested property as listed below:
|Object Type||Path to R1C1ReferenceStyle|
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:
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.
A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339
// 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]:RC[-3])"; // Specify a formula with absolute R1C1 references // to add values contained in cells A2 through A11. worksheet.Cells["D3"].Formula = "=SUM(R2C1:R11C1)";