SetNoteBounds Method

Sets the location and dimensions for a cell note when the style sets the note to always be shown.

Syntax

Visual Basic
C#

'Declaration
 
Public Sub SetNoteBounds( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal x As Integer, _
   ByVal y As Integer, _
   ByVal width As Integer, _
   ByVal height As Integer _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim x As Integer
Dim y As Integer
Dim width As Integer
Dim height As Integer
 
instance.SetNoteBounds(row, column, x, y, width, height)

public void SetNoteBounds( 
   int row,
   int column,
   int x,
   int y,
   int width,
   int height
)

Parameters

row: Row index of cell with note
column: Column index of cell with note
x: X-coordinate of beginning of note
y: Y-coordinate of beginning of note
width: Number of pixels in width of note
height: Number of pixels in height of note

Example

This example sets the location of the sticky note.

fpSpread1.ActiveSheet.SetNote(0, 0, "Head of Development");
fpSpread1.ActiveSheet.Cells(0, 0).NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote;
fpSpread1.ActiveSheet.SetNoteBounds(0, 0, 80, 80, 80, 80);

Visual Basic

FpSpread1.ActiveSheet.SetNote(0, 0, "Head of Development")
FpSpread1.ActiveSheet.Cells(0, 0).NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote
FpSpread1.ActiveSheet.SetNoteBounds(0, 0, 80, 80, 80, 80)

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
SetNote Method
Note Property

User-Task Documentation

Adding a Note to a Cell