GrapeCity.Documents.Excel.IName.RefersToR1C1

RefersToR1C1 Property

RefersToR1C1

Gets or sets the formula that the name is defined to refer to, in the language of the macro and in R1C1-style notation, beginning with an equal sign.

Use this property to read or set the defined name formula in R1C1-style notation. To work with the A1-style equivalent, use RefersTo.

Declaration

string RefersToR1C1 { get; set; }

Property RefersToR1C1 As String

Examples

worksheet.Range["A1:A3"].Value = new object[,] { { 100 }, { 200 }, { 300 } };
IName definedName = worksheet.Names.Add("SalesTotal", "=A1:A3");
definedName.RefersToR1C1 = "=R1C1:R3C1";
string refersToR1C1 = definedName.RefersToR1C1;