ReferenceStyle Property (Worksheet)

Gets or sets the style for cell and range references in cell formulas on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property ReferenceStyle As ReferenceStyle

'Usage
 
Dim instance As Worksheet
Dim value As ReferenceStyle
 
instance.ReferenceStyle = value
 
value = instance.ReferenceStyle

[System.ComponentModel.DefaultValue()]
public ReferenceStyle ReferenceStyle {get; set;}

Example

This example sets the ReferenceStyle property.

gcSpreadSheet1.Sheets[0].DefaultColumnWidth = 30;
gcSpreadSheet1.Sheets[0].DefaultRowHeight = 20;
gcSpreadSheet1.Sheets[0].Cells(0, 0).Text = "test";
gcSpreadSheet1.Sheets[0].ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1;
listBox1.Items.Add(gcSpreadSheet1.Sheets[0].LastNonEmptyRowIndex.ToString());
gcSpreadSheet1.Invalidate();

VB.NET

GcSpreadSheet1.Sheets(0).DefaultColumnWidth = 30
GcSpreadSheet1.Sheets(0).DefaultRowHeight = 20
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "test"
GcSpreadSheet1.Sheets(0).ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1
ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).LastNonEmptyRowIndex.ToString())
GcSpreadSheet1.Invalidate()

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members