topic Re: ODS wraptext only in headers in ODS and Base Reporting

ODS wraptext only in headers

Meg4 — Thu, 17 Nov 2022 11:04:48 GMT

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 🙂

Re: ODS wraptext only in headers

PeterClemmensen — Thu, 17 Nov 2022 11:19:09 GMT

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.

Re: ODS wraptext only in headers

Meg4 — Thu, 17 Nov 2022 11:37:12 GMT

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'
);

Re: ODS wraptext only in headers

Ksharp — Thu, 17 Nov 2022 13:03:27 GMT