Spread Silverlight Documentation
ReferenceStyle Property (GcSpreadSheet)
Example 


Gets or sets the style for cell and range references in cell formulas on this sheet.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
<System.ComponentModel.CategoryAttribute("Spread Formulas")>
Public Property ReferenceStyle As ReferenceStyle
'Usage
 
Dim instance As GcSpreadSheet
Dim value As ReferenceStyle
 
instance.ReferenceStyle = value
 
value = instance.ReferenceStyle
[System.ComponentModel.DefaultValue()]
[System.ComponentModel.Category("Spread Formulas")]
public ReferenceStyle ReferenceStyle {get; set;}
Example
This example sets the ReferenceStyle property.
gcSpreadSheet1.ReferenceStyle = GrapeCity.Windows.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.Windows.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
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

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.