Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / PrintNotes Enumeration
Example Example


In This Topic
    PrintNotes Enumeration
    In This Topic
    Specifies how cell notes are printed.
    Syntax
    'Declaration
     
    Public Enum PrintNotes 
       Inherits System.Enum
    'Usage
     
    Dim instance As PrintNotes
    public enum PrintNotes : System.Enum 
    Members
    MemberDescription
    AsDisplayed[2] Prints the cell notes as they are displayed on the sheet
    AtEnd[1] Prints the cell notes in summary form after the last sheet is printed
    None[0] Does not print the cell notes
    Example
    This example uses the PrintNotes enumeration.
    FarPoint.Web.Spread.PrintInfo prinf = new FarPoint.Web.Spread.PrintInfo();
    prinf.BestFitCols = true;
    prinf.BestFitRows = true;
    prinf.Centering = FarPoint.Web.Spread.Centering.Both;
    prinf.ColEnd = 10;
    prinf.Colors = new System.Drawing.Color[] {
            System.Drawing.Color.Green,
            System.Drawing.Color.Yellow,
            System.Drawing.Color.Gold,
            System.Drawing.Color.Indigo,
            System.Drawing.Color.Brown};
    prinf.ColStart = 0;
    prinf.FirstPageNumber = 1;
    prinf.Footer = "/g\"1\"/cl\"4\"This is Page /p of /pc Pages";
    prinf.FooterHeight = 40;
    prinf.Header = "/cl\"0\"Print Job For FarPoint Inc./n /n ";
    prinf.HeaderHeight = 40;
    prinf.Images = new System.Drawing.Image[] {
            System.Drawing.Image.FromFile("D:\\images\\point.jpg"),
            System.Drawing.Image.FromFile("D:\\images\\logo.gif"),
            System.Drawing.Image.FromFile("D:\\images\\icon.jpg")};
    prinf.Margin = new FarPoint.Web.Spread.PrintMargin(10, 10, 10, 10, 20, 20);
    prinf.Opacity = 50;
    prinf.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape;
    prinf.PageEnd = 5;
    prinf.PageOrder = FarPoint.Web.Spread.PrintPageOrder.OverThenDown;
    prinf.PageStart = 1;
    prinf.PrintNotes = FarPoint.Web.Spread.PrintNotes.None;
    prinf.PrintType = FarPoint.Web.Spread.PrintType.All;
    prinf.RepeatColEnd = 10;
    prinf.RepeatColStart = 1;
    prinf.RepeatRowEnd = 10;
    prinf.RepeatRowStart = 1;
    prinf.RowEnd = 10;
    prinf.RowStart = 1;
    prinf.ShowBorder = false;
    prinf.ShowColumnFooter = FarPoint.Web.Spread.PrintHeader.Show;
    prinf.ShowColumnFooterEachPage = true;
    prinf.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Show;
    prinf.ShowGrid = true;
    prinf.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Show;
    prinf.ShowSubtitle = true;
    prinf.ShowTitle = true;
    prinf.SmartPrintPagesTall = 1;
    prinf.SmartPrintPagesWide = 1;
    FarPoint.Web.Spread.SmartPrintRulesCollection prules = new FarPoint.Web.Spread.SmartPrintRulesCollection();
    prules.Add(new FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None));
    prinf.SmartPrintRules = prules;
    prinf.UseMax = true;
    prinf.UseSmartPrint = false;
    prinf.ZoomFactor = 2;
    FpSpread1.ActiveSheetView.PrintInfo = prinf;
    Dim prinf As New FarPoint.Web.Spread.PrintInfo
    prinf.BestFitCols = True
    prinf.BestFitRows = True
    prinf.Centering = FarPoint.Web.Spread.Centering.Both
    prinf.ColEnd = 10
    prinf.Colors = New Drawing.Color() {Drawing.Color.Green, Drawing.Color.Yellow, Drawing.Color.Gold, Drawing.Color.Indigo, Drawing.Color.Brown}
    prinf.ColStart = 0
    prinf.FirstPageNumber = 1
    prinf.Footer = "/g""1""/cl""4""This is Page /p of /pc Pages"
    prinf.FooterHeight = 40
    prinf.Header = "/cl""0""Print Job For FarPoint Inc./n /n "
    prinf.HeaderHeight = 40
    prinf.Images = New System.Drawing.Image() {System.Drawing.Image.FromFile("D:\images\point.jpg"), System.Drawing.Image.FromFile("D:\images\logo.gif"), System.Drawing.Image.FromFile("D:\images\icon.jpg")}
    prinf.Margin = New FarPoint.Web.Spread.PrintMargin(10, 10, 10, 10, 20, 20)
    prinf.Opacity = 50
    prinf.Orientation = FarPoint.Web.Spread.PrintOrientation.Landscape
    prinf.PageEnd = 5
    prinf.PageOrder = FarPoint.Web.Spread.PrintPageOrder.OverThenDown
    prinf.PageStart = 1
    prinf.PrintNotes = FarPoint.Web.Spread.PrintNotes.None
    prinf.PrintType = FarPoint.Web.Spread.PrintType.All
    prinf.RepeatColEnd = 10
    prinf.RepeatColStart = 1
    prinf.RepeatRowEnd = 10
    prinf.RepeatRowStart = 1
    prinf.RowEnd = 10
    prinf.RowStart = 1
    prinf.ShowBorder = False
    prinf.ShowColumnFooter = FarPoint.Web.Spread.PrintHeader.Show
    prinf.ShowColumnFooterEachPage = True
    prinf.ShowColumnHeader = FarPoint.Web.Spread.PrintHeader.Show
    prinf.ShowGrid = True
    prinf.ShowRowHeader = FarPoint.Web.Spread.PrintHeader.Show
    prinf.ShowSubtitle = True
    prinf.ShowTitle = True
    prinf.SmartPrintPagesTall = 1
    prinf.SmartPrintPagesWide = 1
    Dim prules As New FarPoint.Web.Spread.SmartPrintRulesCollection
    prules.Add(New FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None))
    prinf.SmartPrintRules = prules
    prinf.UseMax = True
    prinf.UseSmartPrint = False
    prinf.ZoomFactor = 2
    FpSpread1.ActiveSheetView.PrintInfo = prinf
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.PrintNotes

    See Also