Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Printing / Specifying What to Print / Printing a Sheet with Cell Notes
In This Topic
    Printing a Sheet with Cell Notes
    In This Topic

    You can print cell notes as well as the data. Use the PrintNotes property in the PrintInfo object to print notes. The notes can be printed on a page either after the data is printed or as displayed on the sheet.

    The following figure shows how printing a sticky note as displayed might look.

    Printing

    For information about adding cell notes, refer to Adding a Note to a Cell.

    Using Code

    1. Use the PrintNotes property to print notes.
    2. Use the PrintSheet method to print.

    Example

    This example prints notes.

    C#
    Copy Code
    private void Form1_Load(object sender, System.EventArgs e)
    {
        fpSpread1.Sheets[0].RowCount = 20;
        fpSpread1.Sheets[0].ColumnCount = 5;
        fpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Fixed;
        fpSpread1.Sheets[0].Cells[0, 0].NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote;
        fpSpread1.Sheets[0].Cells[0, 0].Note = "test";
    }
        
    private void button1_Click(object sender, System.EventArgs e)
    {
        FarPoint.Win.Spread.PrintInfo pi = new FarPoint.Win.Spread.PrintInfo();
        pi.PrintNotes =FarPoint.Win.Spread.PrintNotes.AsDisplayed;
        fpSpread1.Sheets[0].PrintInfo = pi;
        fpSpread1.PrintSheet(-1);
    }
    
    VB
    Copy Code
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        fpSpread1.Sheets(0).RowCount = 20
        fpSpread1.Sheets(0).ColumnCount = 5
        fpSpread1.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Fixed
        fpSpread1.Sheets(0).Cells(0, 0).NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote
        fpSpread1.Sheets(0).Cells(0, 0).Note = "test"
    End Sub
    
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim pi As New FarPoint.Win.Spread.PrintInfo()
        pi.PrintNotes = FarPoint.Win.Spread.PrintNotes.AsDisplayed
        fpSpread1.Sheets(0).PrintInfo = pi
        fpSpread1.PrintSheet(-1)
    End Sub
    
    See Also