[CLOSED]Need to change the excel report's default printing settings.
Hi All,
I want to change the excel report's default printing settings. Below changes will get effected automatically, when I pressed CTRL+P for printing: 1. Change the margin from 'Custom' to 'Narrow'. 2. Change the scaling from 'No Scaling' to 'Fit All columns on Single Page'.
How can I achieve it via WebFOCUS code. Please help.
Thanks and Regards, Sandy SagarThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 7.6 Windows, All Outputs
December 29, 2015, 07:36 AM
Dave
Sandy,
that can only be achieved if you have an excel-template with these settings and/or a macro to apply these settings.
No direct control from WebFocus code.
_____________________ WF: 8.0.0.9 > going 8.2.0.5
December 29, 2015, 05:28 PM
Waz
With EXL2k you may be able to do it.
I've affected the page size in the past, unfortunately I don.t have access to the code anymore.
I may have posted it here though.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
December 29, 2015, 05:33 PM
Waz
Found this I posted 3 years ago that sets the print area.
Not sure if it can do that you want, only EXL2K format