Spread Windows Forms 6.0 Product Documentation
ReferenceStyle Enumeration
Example  See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace : ReferenceStyle Enumeration


Glossary Item Box

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

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

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.
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 BasicCopy 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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.