ReferenceStyle Property (DefaultSheetDataModel)

Gets or sets the cell reference style for cells with formulas.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ReferenceStyle As ReferenceStyle

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

public ReferenceStyle ReferenceStyle {get; set;}

Property Value

ReferenceStyle setting that determines the cell reference style

Example

Visual Basic

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
dataModel.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
dataModel.SetValue(0, 0, 5)
dataModel.SetValue(1, 0, 5)
dataModel.SetFormula(0, 0, "3*SUM(A1,B1)")
FpSpread1.ActiveSheet.Models.Data = dataModel

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(3, 3);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
dataModel.SetValue(0, 0, 5);
dataModel.SetValue(1, 0, 5);
dataModel.SetFormula(0, 0, "3*SUM(A1,B1)");

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members