Spread for ASP.NET 9.0 Product Documentation
SetNote Method (ISheetDataModel)
Example 


Row index
Column index
String for note
Sets the note for a cell at the specified row and column.
Syntax
'Declaration
 
Sub SetNote( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As String _
) 
'Usage
 
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
)

Parameters

row
Row index
column
Column index
value
String for note
Example
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

ISheetDataModel Interface
ISheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.