Printing Issues

Posted by: Luis.Alvarez on 25 April 2018, 9:47 am EST

  • Posted 25 April 2018, 9:47 am EST

    I have the need to change the page orientation between landscape and portrait depending on the number of spreadsheet columns. I have tried to set the orientation using and then assigning the printinfo object
    Dim printinfo As New PrintInfo()
    ' Set the deafult Print Dialog Box options
    printinfo.Orientation = PrintPageOrientation.Landscape
    GcSpreadSheet1.Sheets(0).PrintInfo = printinfo
    GcSpreadSheet1.Print()
    but I'm always getting a portrait orientation. Also is there a way to add a new line to the Header and footer so that I can print multiple lines?

    Thank you,
    Luis
  • Marked as Answer

    Replied 26 April 2018, 7:57 am EST

    Hello,

    I test the code below to print in Landscape mode and it works absolutely fine:

     GrapeCity.Windows.SpreadSheet.Data.PrintInfo printset = new GrapeCity.Windows.SpreadSheet.Data.PrintInfo();
    printset.Orientation = GrapeCity.Windows.SpreadSheet.Data.PrintPageOrientation.Landscape;
    printset.PageOrder = GrapeCity.Windows.SpreadSheet.Data.PrintPageOrder.Auto;
    printset.PageRange = "1-3";
    printset.PaperSize = new GrapeCity.Windows.SpreadSheet.Data.PaperSize(System.Drawing.Printing.PaperKind.A4);
    //printset.PaperSize = new GrapeCity.Windows.SpreadSheet.Data.PaperSize(600, 300);
    //printset.PaperSize = new GrapeCity.Windows.SpreadSheet.Data.PaperSize();
    gcSpreadSheet1.Sheets[0].PrintInfo = printset;
    gcSpreadSheet1.SavePdf("C:\\Data\\testportrait.pdf", 0);


    I tested it for latest version. Please refer to the sample application attached.

    Thanks,
    Deepak Sharma
  • Replied 26 April 2018, 7:57 am EST

    Here is the attachment.
    SpreadWPFPrintLandscape.zip
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels