Contains workbook options related to formula calculation.
The notation for WinForms and WPF controls is as follows:
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 Range.Formula property. To obtain a cell reference in the R1C1 reference style, you can use the Range.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)";