GrapeCity.Xaml.SpreadSheet.Data
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
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

Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options