Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel output to fit in default A4 print sheet

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Excel output to fit in default A4 print sheet
 Login/Join
 
Dev
Gold member
posted
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>,


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Report This Post
GavinL
Master
posted Hide Post
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.



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
 
Posts: 578 | Registered: October 01, 2014Report This Post
Dev
Gold member
posted Hide Post
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


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Report This Post
Doug
Expert
posted Hide Post
How about outputting to an Excel Macro, where the macro sets the page size to A4 / Fit to one page?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Dev
Gold member
posted Hide Post
So we can't do it in WebFOCUS?


8202, 8105M, 7.7.03
 
Posts: 79 | Registered: June 12, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel output to fit in default A4 print sheet

Copyright © 1996-2020 Information Builders