SpreadsheetGear The Performance Spreadsheet Component Company 
FormulaR1C1 Property
See Also  Example
SpreadsheetGear Namespace > IRange Interface : FormulaR1C1 Property
Gets or sets the value or formula of the cells represented by this IRange using ReferenceStyle.R1C1.

Syntax

C# 
virtual string FormulaR1C1 {get; set;}

Example

C#Copy Code
// Set cells to a formula which referes to the top-left cell in the worksheet. 
range.FormulaR1C1 = "=R1C1"; 
    
Visual BasicCopy Code
' Set cells to a formula which referes to the top-left cell in the worksheet.
range.FormulaR1C1 = "=R1C1"

Remarks

To put a formula in a cell, the first character must be '='. Otherwise, attempts will be made to convert the specified string to a number, date, time, date/time, logical or error value. If none of these succeed, the value will be set in the cell as text.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also