GrapeCity.Documents.Excel.IRange.FormulaR1C1

FormulaR1C1 Property

FormulaR1C1

Gets or sets the formula of the cells represented by this IRange in R1C1-style notation.

Declaration

string FormulaR1C1 { get; set; }

Property FormulaR1C1 As String

Examples

worksheet.Range["A1"].Value = 10;
worksheet.Range["A2"].Value = 5;
IRange range = worksheet.Range["B1"];
range.FormulaR1C1 = "=RC[-1]+R[1]C[-1]";
workbook.Calculate();
object value = range.Value;