Spread Windows Forms 11.0 Product Documentation
ReferenceStyle Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : ReferenceStyle Enumeration
Specifies the reference style in formulas and custom names in the sheet.
Syntax
'Declaration
 
Public Enum ReferenceStyle 
   Inherits System.Enum
'Usage
 
Dim instance As ReferenceStyle
public enum ReferenceStyle : System.Enum 
Members
MemberDescription
A1Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates
R1C1Uses "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.
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");
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

See Also

Reference

FarPoint.Win.Spread.Model Namespace
ReferenceStyle Property (SheetView Class)