SpreadsheetGear
FormulaR1C1 Property
See Also  Example Send Feedback
SpreadsheetGear Namespace > IRange Interface : FormulaR1C1 Property

Gets or sets the value or formula of the cells represented by this IRange using ReferenceStyle.R1C1.

Syntax

Visual Basic (Declaration) 
Property FormulaR1C1 As String
C# 
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 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2008 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.