Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / SetValue Method
Row index of cell in model
Column index of cell in model
Value to set
Example


In This Topic
    SetValue Method (DefaultSheetDataModel)
    In This Topic
    Sets the value for the cell of the specified row and column.
    Syntax
    'Declaration
     
    Public Overrides Sub SetValue( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As Object _
    ) 
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As Object
     
    instance.SetValue(row, column, value)
    public override void SetValue( 
       int row,
       int column,
       object value
    )

    Parameters

    row
    Row index of cell in model
    column
    Column index of cell in model
    value
    Value to set
    Remarks
    use the GetValue method to return the value in a specified cell.
    Example
    This example sets an application-defined tag value for the cell of the specified row and column.
    dataModel = FpSpread1.ActiveSheetView.DataModel; 
    dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1); 
    dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2); 
    FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM"); 
    FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT"); 
    FpSpread1.ActiveSheetView.SetValue(0, 0, 10); 
    FpSpread1.ActiveSheetView.SetValue(1, 0, 10);
    dataModel.SetTag(2, 2, "TWICEPRODUCT"); 
    dataModel.RemoveCustomName("TWICESUM")
    dataModel.Recalculate(); 
    
    Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
    dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel
    dataModel.AddCustomName("TWICESUM", "2*SUM(A1,A2)", 1, 1)
    dataModel.AddCustomName("TWICEPRODUCT", "2*A1*A2", 2, 2)
    FpSpread1.ActiveSheetView.SetFormula(1, 1, "TWICESUM")
    FpSpread1.ActiveSheetView.SetFormula(2, 2, "TWICEPRODUCT")
    FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
    FpSpread1.ActiveSheetView.SetValue(1, 0, 10)
    dataModel.SetTag(2, 2, "TWICEPRODUCT")
    dataModel.RemoveCustomName("TWICESUM")
    dataModel.Recalculate();
    See Also