Posted 25 April 2018, 12:47 am ESTI 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
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?