Hi,

I have 2 tabs (in XLSX format) cover page and detail page. If I put the wrapping on my 2 columns in coverpage styles, in detail page first 2 columns also getting wrapped though I specified WRAP=OFF. Can you please help me. Below is the code.

car1.fex (cover page)
DEFINE FILE CAR
Blank1/A1='';
Blank2/A1='';
END

TABLE FILE CAR
PRINT
Blank1 AS ''
Blank2 AS ''
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.COMP.CAR NOPRINT
BY CAR.CARREC.MODEL NOPRINT
BY CAR.BODY.BODYTYPE NOPRINT
BY CAR.BODY.SEATS NOPRINT

HEADING
"<+0>Client Number / Name: <+0>WF_IR_ACCOUNTNO / WF_IR_ACCOUNTNAME "
"<+0>Report Name: <+0>"
"<+0>Report Date / Time: <+0>01/01/2001 "
"<+0>Valuation date: <+0> "
"<+0> Source: <+0>US "
"<+0> Currency: <+0>USD "

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *


TYPE=HEADING, SIZE=9, HEADALIGN=BODY,$
TYPE=HEADING, ITEM=1, POSITION=N1, $

TYPE=REPORT, COLUMN=P1, WRAP=1.5, $
TYPE=REPORT, COLUMN=P2, WRAP=1.5, $

ENDSTYLE
END

car2.fex (detail page)
SET COMPOUND='OPEN'
-INCLUDE car1
SET COMPOUND=CLOSE


TABLE FILE CAR
PRINT
*

ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *

TYPE=REPORT, WRAP=OFF, $

ENDSTYLE
END

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

Try adding in the specific columns that you do not want to wrap:

 
TYPE=REPORT, COLUMN=P1, WRAP=OFF, $
TYPE=REPORT, COLUMN=P2, WRAP=OFF, $ 

Read the docs here: Controlling Column Width and Wrapping in XLSX Report Output

I have tried adding WRAP OFF on individual columns also. But it din't help.
Actually columns are not wrapping, full column is not visible unless I expand the cells manually.

Sandhya,
Did you try setting Wrap values for the columns on the second report, like:

TYPE=REPORT, COLUMN=P1, WRAP=3.0, $
TYPE=REPORT, COLUMN=P2, WRAP=3.0, $

to get the column widths you want?