Gets or sets the cell reference style for cells with formulas.
Syntax
Visual Basic (Declaration) | |
---|
Public Property ReferenceStyle As ReferenceStyle |
Property Value
ReferenceStyle setting that determines the cell reference style
Example
Visual Basic | Copy Code |
---|
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 |
C# | Copy Code |
---|
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)"); |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also