Posted 25 April 2018, 12: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