Hi,

We have a requirement to run the excel(WF 8 - XLSX) report and it has to fit in A4 sheet printable portrait format.
In the excel using around 12 numeric columns.
Is there any option to do it in WebFOCUS? or using Macro (how to use)?

This message has been edited. Last edited by: <Kathryn Henning>,

I'm not sure I understand the question. Are you asking if WebFOCUS can product XLSX documents or if it can print? It can do both. The A4 is based on the user and what they select when printing. You can space out your columns using SQUEEZE to stretch each out to meet your requirement, but still at the end of the day, if someone picks Letter instead of A4, not something you can stop.

Below is my sample xlsx output, if I execute from the portal we will get like this, then user want to print this excel file without aligning any cells need to fit A4 portrait as default.

Tried with Squeeze to reduce the columns, but the sum values are coming huge amount so we can't (length of the sum column is d12)

ALL A B C D E F G H I J K Other Total
HEAD1 0.00 2.86 2.72 5.25 5.11 1.46 1.43 4.96 0.00 0.00 5.04 0.00 4.19
HEAD2 0.00 2.64 1.33 3.97 4.03 2.19 1.95 4.21 2.84 4.03 3.41 0.00 3.32
HEAD3 18.00 10.52 13.29 15.38 15.58 16.29 18.77 19.53 0 0 13.04 2.50 14.94
HEAD4 5.21 15.40 10.23 17.69 18.45 22.99 14.59 20.33 17.14 19.37 21.08 4.40 17.59
HEAD5 0 16.28 15.90 32.79 26.14 23.50 22.69 14.75 13.00 0 12.50 0 24.90
HEAD6 19.44 31.29 31.87 45.98 28.97 29.35 24.06 45.69 29.32 29.94 20.13 49.60 34.88
HEAD7 0 7.58 6.80 7.26 7.56 4.33 6.83 12.50 9.00 12.00 7.00 0 7.26
HEAD8 3.92 6.98 6.31 7.41 7.75 8.21 6.42 8.01 8.64 9.60 6.28 10.33 7.44

How about outputting to an Excel Macro, where the macro sets the page size to A4 / Fit to one page?

So we can't do it in WebFOCUS?