SpreadsheetGear 2010
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

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 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.