SetNote Method (SheetView)

Sets a note in a specified cell on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetNote( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As String _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As String
 
instance.SetNote(row, column, value)

public void SetNote( 
   int row,
   int column,
   string value
)

Parameters

row: Row index of specified cell
column: Column index of specified cell
value: Note text to associate with the cell

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows
System.ArgumentOutOfRangeException	Specified column index is out of range; must be between 0 and the total number of columns

Remarks

This method sets a cell note, comments or tips for the user, in a specified cell.

Example

This example sets a note in the specified cell.

fpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating;
fpSpread1.ActiveSheet.SetNote(0, 1, "Currently out-of-stock");

Visual Basic

FpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating
FpSpread1.ActiveSheet.SetNote(0, 1, "Currently out-of-stock")

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

Reference

SheetView Class
SheetView Members
Note Property
GetNote Method
ShowNotes Method

User-Task Documentation

Adding a Note to a Cell