GrapeCity.Xaml.SpreadSheet.Data
ReferenceStyle Enumeration
Example Example 


GrapeCity.Xaml.SpreadSheet.Data 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
A1 [0] Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates.
R1C1 [1] Uses "R" and number for row, "C" and number for column coordinates; uses brackets [ ] for relative coordinates.
Example
This example uses the ReferenceStyle enumeration.
gcSpreadSheet1.Sheets[0].DefaultColumnWidth = 30;
gcSpreadSheet1.Sheets[0].DefaultRowHeight = 20;
gcSpreadSheet1.Sheets[0].Cells(0, 0).Text = "test";
gcSpreadSheet1.Sheets[0].ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1;
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].LastNonEmptyRowIndex.ToString());
GcSpreadSheet1.Sheets(0).DefaultColumnWidth = 30
GcSpreadSheet1.Sheets(0).DefaultRowHeight = 20
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "test"
GcSpreadSheet1.Sheets(0).ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).LastNonEmptyRowIndex.ToString())
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace