ODS wraptext only in headers

[Meg4]

Hello, 

is there any solution to wraptext in ODS Excel but only in headers or first row?

When I put in options WRAPTEXT='yes' then whole table is wrapped.

options
(
sheet_name="XYZ"
AutoFilter = 'All'
Frozen_Headers ='1'
Orientation='Landscape'
WRAPTEXT ='yes'
AUTOFIT_HEIGHT = 'yes'
embedded_titles = 'No'
ABSOLUTE_COLUMN_WIDTH= '8, 9, 9, 7, 9, 11'
);

(...)

Thanks in advance 🙂

[PeterClemmensen]

Use the Flow= Option to specify the designated worksheet area that enables Wrap Text. So in your case, specify FLOW = 'HEADERS'. See the ODS Excel Documentation for more information. 

[Meg4]

I've tried with this, but same results. Even with different combinations in options (like only 3 options left) always wrapping whole table.

I'm using SAS EG 8.3

options
(
sheet_name="XYZ"
AutoFilter = 'All'
Frozen_Headers ='1'
Orientation='Landscape'

FLOW = 'HEADERS'
WRAPTEXT ='yes'
AUTOFIT_HEIGHT = 'yes'
embedded_titles = 'no'
ABSOLUTE_COLUMN_WIDTH= '8, 9, 9, 7, 9, 11, 7, 11'
FitToPage ='yes'
);

[Ksharp]