Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum ReferenceStyle Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ReferenceStyle | |
| C# | |
|---|---|
public enum ReferenceStyle : System.Enum | |
Members
| Member | Description |
|---|---|
| A1 | Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates |
| R1C1 | Uses "R" and number for row, "C" and number for column coordinates; uses brackets [ ] for relative coordinates |
Example
This example sets the reference style for the formulas in the spreadsheet.
| C# | Copy Code |
|---|---|
fpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
fpSpread1.ActiveSheet.Cells[0, 0].Value = 10;
fpSpread1.ActiveSheet.Cells[1, 0].Value = 30;
fpSpread1.ActiveSheet.SetFormula(3, 0, "R1C1 * R2C1"); | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
FpSpread1.ActiveSheet.Cells(0, 0).Value = 10
FpSpread1.ActiveSheet.Cells(1, 0).Value = 30
FpSpread1.ActiveSheet.SetFormula(3, 0, "R1C1 * R2C1") | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.Model.ReferenceStyle
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8