ReferenceStyle Enumeration

Specifies the reference style in formulas and custom names in the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ReferenceStyle 
   Inherits System.Enum

'Usage
 
Dim instance As ReferenceStyle

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.

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

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

Reference

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