Spread Windows Forms 8.0 Product Documentation
ReferenceStyle Enumeration
Example Example 


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

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

See Also

Reference

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

 

 


Copyright © GrapeCity, inc. All rights reserved.