Focal Point
[CLOSED] Using WRAP On Excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5207075886

December 07, 2017, 03:23 AM
wyp
[CLOSED] Using WRAP On Excel
Can I use [wrap=off] on excel format?

When I put the following code on source tag and execute from source tag, it works well. But, when I execute from report tag, it does not work. If check code on source tag, the following code was disappear. I have no idea what's wrong with this? Confused

CODE:
$
TYPE=REPORT,
WRAP=OFF,
$

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05M
Windows, Excel , CSV Outputs
December 07, 2017, 04:28 AM
Chaudhary
quote:
Can I use [wrap=off] on excel format?

you only can use numeric values TO WRAP OR use SQUEEZE [SQUEEZE=OFF/ON]

Try some thing like this ,

TYPE=REPORT,
     WRAP=1.083333,
$ 



WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10
December 07, 2017, 11:30 PM
wyp
So, I can't use [wrap=OFF] on excel format.
I want the data like this:

COL1 COL2 COL3 COL4
COL5 COL6
---------------------------------
AAAA BBBB CCCC DDDD
EEEE FFFFFFFFFFFFF

If I can't use [wrap=off] for excel output,
Is there any way to get the data like [COL6]?


WebFOCUS 8.1.05M
Windows, Excel , CSV Outputs
December 08, 2017, 02:46 AM
Chaudhary
you can try "xlsx" ouput format , it will automatically remove Text wrap in excel .


WF Production :- WF:8.0.0.4, 8.1.05 App-studio/Developer Studio(8.1.x) ,
8.2.0.1M , 8.2.0.2 (App-Studio8.2.x),
InfoAssist/+, InfoDiscovery
Output format:-AHTML, PDF, Excel, HTML
Platform:-Windows 7, 8,10