Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ISheetDataModel Interface / SetNote Method
Row index
Column index
String for note

In This Topic
    SetNote Method (ISheetDataModel)
    In This Topic
    Sets the note for a cell at the specified row and column.
    Sub SetNote( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal value As String _
    Dim instance As ISheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim value As String
    instance.SetNote(row, column, value)
    void SetNote( 
       int row,
       int column,
       string value


    Row index
    Column index
    String for note
    This example returns the previously set note for the specified cell in the model.
    private void ChangeDataModel(FarPoint.Web.Spread.FpSpread ss, FarPoint.Web.Spread.Model.ISheetDataModel isd)
        isd.SetNote(0, 0, "Test Note");
        ss.ActiveSheetView.DataModel = (FarPoint.Web.Spread.Model.ISheetDataModel)isd;
        string s;
        s = isd.GetNote(0, 0);
        Response.Write("The note in the cell is " + s);
    private void PageLoad(object sender, System.EventArgs e)
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel);    
    Private Sub ChangeDataModel(ByVal ss As FarPoint.Web.Spread.FpSpread, ByVal isd As FarPoint.Web.Spread.Model.ISheetDataModel)
        isd.SetNote(0, 0, "Test Note")
        ss.ActiveSheetView.DataModel = isd
        Dim s As String
        s = isd.GetNote(0, 0)
        Response.Write("The note in the cell is " & s)
    End Sub
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ChangeDataModel(FpSpread1, FpSpread1.ActiveSheetView.DataModel)
    End Sub
    See Also