Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SetStickyNoteStyleInfo Method
Row index of cell
Column index of cell
Style information
Example


In This Topic
    SetStickyNoteStyleInfo Method
    In This Topic
    Sets the style information for the cell notes on this sheet that stay visible.
    Syntax
    'Declaration
     
    Public Overridable Sub SetStickyNoteStyleInfo( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal info As StickyNoteStyleInfo _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim info As StickyNoteStyleInfo
     
    instance.SetStickyNoteStyleInfo(row, column, info)
    public virtual void SetStickyNoteStyleInfo( 
       int row,
       int column,
       StickyNoteStyleInfo info
    )

    Parameters

    row
    Row index of cell
    column
    Column index of cell
    info
    Style information
    Example
    This example sets the style for the sticky note.This example uses the SetNoteStyleInfo method.
    fpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development");
    fpSpread1.ActiveSheet.Cells[2, 0].NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote;
    FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo nsinfo = new FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo();
    nsinfo = fpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0);
    nsinfo.BackColor = Color.Bisque;
    nsinfo.Font = new Font("Tahoma", 24);
    nsinfo.ForeColor = Color.Cyan;
    nsinfo.Width = 320;
    nsinfo.ShapeOutlineColor = Color.Cyan;
    nsinfo.ShapeOutlineThickness = 1;
    nsinfo.ShadowOffsetX = 3;
    nsinfo.ShadowOffsetY = 3;
    fpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo);
    FpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development")
    FpSpread1.ActiveSheet.Cells(2, 0).NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote
    Dim nsinfo As FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo = New FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo
    nsinfo = FpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0)
    nsinfo.BackColor = Color.Bisque
    nsinfo.Font = New Font("Tahoma", 24)
    nsinfo.ForeColor = Color.Cyan
    nsinfo.Width = 320
    nsinfo.ShapeOutlineColor = Color.Cyan
    nsinfo.ShapeOutlineThickness = 1
    nsinfo.ShadowOffsetX = 3
    nsinfo.ShadowOffsetY = 3
    FpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo)
    fpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development");
    FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo nsinfo = new FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo();
    nsinfo = fpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0);
    nsinfo.BackColor = Color.Bisque;
    nsinfo.Font = new Font("Tahoma", 24);
    nsinfo.ForeColor = Color.Cyan;
    nsinfo.Width = 320;
    nsinfo.ShapeOutlineColor = Color.Cyan;
    nsinfo.ShapeOutlineThickness = 1;
    nsinfo.ShadowOffsetX = 3;
    nsinfo.ShadowOffsetY = 3;
    nsinfo.MarginLeft = 5;
    fpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo);
    fpSpread1.Sheets[0].Cells[2, 0].NoteIndicatorPosition = FarPoint.Win.Spread.NoteIndicatorPosition.BottomLeft;
    FpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development")
    Dim nsinfo As FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo = New FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo()
    nsinfo = FpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0)
    nsinfo.BackColor = Color.Bisque
    nsinfo.Font = New Font("Tahoma", 12)
    nsinfo.ForeColor = Color.Cyan
    nsinfo.Width = 250
    nsinfo.ShapeOutlineColor = Color.Cyan
    nsinfo.ShapeOutlineThickness = 1
    nsinfo.ShadowOffsetX = 3
    nsinfo.ShadowOffsetY = 3
    nsinfo.MarginLeft = 5
    FpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo)
    FpSpread1.Sheets(0).Cells(2, 0).NoteIndicatorPosition = FarPoint.Win.Spread.NoteIndicatorPosition.BottomLeft
    See Also