ReferenceStyle Property (GcSpreadSheet)

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

Syntax

Visual Basic
C#

'Declaration
 
<CategoryAttribute()>
<DefaultValueAttribute()>
Public Property ReferenceStyle As ReferenceStyle

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

[Category()]
[DefaultValue()]
public ReferenceStyle ReferenceStyle {get; set;}

Example

This example sets the ReferenceStyle property.

C#
VB.NET

gcSpreadSheet1.ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1;
gcSpreadSheet1.SheetCount = 1;
//Or
//gcSpreadSheet1.Sheets.Count = 1;
gcSpreadSheet1.Sheets[0].RowRangeGroup.Group(0, 2);
gcSpreadSheet1.Sheets[0].ColumnRangeGroup.Group(3, 2);
gcSpreadSheet1.ShowColumnRangeGroup = true;
gcSpreadSheet1.ShowRowRangeGroup = true;
gcSpreadSheet1.ShowGridLine = true;

GcSpreadSheet1.ReferenceStyle = GrapeCity.Xaml.SpreadSheet.Data.ReferenceStyle.A1
GcSpreadSheet1.SheetCount = 1
'Or
'GcSpreadSheet1.Sheets.Count = 1
GcSpreadSheet1.Sheets(0).RowRangeGroup.Group(0, 2)
GcSpreadSheet1.Sheets(0).ColumnRangeGroup.Group(3, 2)
GcSpreadSheet1.ShowColumnRangeGroup = True
GcSpreadSheet1.ShowRowRangeGroup = True
GcSpreadSheet1.ShowGridLine = True

Reference

GcSpreadSheet Class
GcSpreadSheet Members