Spread Windows Forms 9.0 Product Documentation
Formula Property (Row)
Example 


Gets or sets the formula for cells in this row.
Syntax
'Declaration
 
Public Property Formula As String
'Usage
 
Dim instance As Row
Dim value As String
 
instance.Formula = value
 
value = instance.Formula
public string Formula {get; set;}

Property Value

String containing the formula
Remarks

Set this property to a mathematical expression made up of cell references, operators, and functions (either provided or custom functions you define). For a list of the operators and functions you can use in formulas, refer to the Formula Reference.

The Spread component can use absolute or relative cell references. You define the cell reference style for the spreadsheet by using the ReferenceStyle property. The formula cannot contain both absolute and relative row or column references.

Returning the value of the Formula property provides a string containing the written expression of the formula, for example, SUM(A1:B1). However, if you have changed the cell reference style to a style that cannot represent the formula, the Spread component provides the formula with question marks as placeholders for cell references that cannot be represented.

For more information about formulas, refer to the Formula Reference.

Example
This example specifies the formula for the cells in the row.
FarPoint.Win.Spread.Row r;
fpSpread1.ActiveSheet.SetValue(0, 0, 10);
fpSpread1.ActiveSheet.SetValue(1, 0, 10);
r = fpSpread1.ActiveSheet.Cells[2, 0].Row;
r.Formula = "A1 + A2";
Dim r As FarPoint.Win.Spread.Row
FpSpread1.ActiveSheet.SetValue(0, 0, 10)
FpSpread1.ActiveSheet.SetValue(1, 0, 10)
r = FpSpread1.ActiveSheet.Cells(2, 0).Row
r.Formula = "A1 + A2"
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

Row Class
Row Members

 

 


Copyright © GrapeCity, inc. All rights reserved.