Posted 30 May 2018, 4:43 am ESTI have an active x control that I am using on vb6:
FarPoint Spreadsheet control version: 18.104.22.168
I am using the object of type: vaSpread
I print a grid with .action = ACTION_SMARTPRINT '32
If the grid does not fit in portrait orientation, it is printed in landscape orientation.
Now, some of the printers does not print the grid.
When I change the grid to fit in portrait orientation (by resizing columns), these printers print it in portrait orientation.
We decided to print it always as landscape so the grid will always fit the page.
When I put the line:
.PrintOrientation = vbPRORLandscape
The printers still don't print the page.
I read on the internet that .PrintOrientation needs to be set before PrintSheet, but I don't have the method PrintSheet.
What should I do in order to print the grid in landscape orientation ?