UpdateNotes(Int32,Int32) Method

Updates cell note appearances based on style being set or on changes to note text.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub UpdateNotes( _
   ByVal row As Integer, _
   ByVal column As Integer _
)

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
 
instance.UpdateNotes(row, column)

public void UpdateNotes( 
   int row,
   int column
)

Parameters

row: Row index of cell
column: Column index of cell

Remarks

The AutoUpdateNotes property gets or sets whether the Spread component updates the location and appearance of notes when handling event notifications generated by changes made to the component. Use the UpdateNotes methods to tell the component to update the location and appearance of notes after having turned off automatic updates with AutoUpdateNotes. These members can be used together to make code that loops through lots of ranges of cells and sets properties much faster by eliminating redundant updates of the cell notes, especially if there are lots of rows in the sheet or lots of cell notes or both.

Example

This example uses the UpdateNotes method.

fpSpread1.ActiveSheet.AutoUpdateNotes =  false;            
fpSpread1.Sheets[0].UpdateNotes(1, 1);

Visual Basic

FpSpread1.ActiveSheet.AutoUpdateNotes = False
FpSpread1.Sheets(0).UpdateNotes(1, 1)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members
Overload List
AutoUpdateNotes Property

User-Task Documentation

Adding a Note to a Cell