Wrap text of Table cell in exported Excel in BIRT

Question

To create reports, I'm using BIRT 4.4.1 in Eclipse.

I would like to enclose the text in the table header; it appears to operate correctly in the web viewer but appears to be overflowing when exported to Excel. I would like to wrap the text based on the width of its container rather than making the cell width equal to the content.

The cell width and label whitespace properties are both set to auto. Is it accurate, or how can I get it to operate in the exported Excel report?

In Webview

After exported, Excel view

Answer 1

Export as XLS in 4.4.2 (not xlsx). You can also use a line return to make the text display appropriately when you convert it to xlsx as a workaround.

Selecting the text box in the cell and setting the Whitespace setting in General Properties to Preformatted offers a third method that is compatible with xlsx output. Then, either change the header cell size to a height that covers the necessary text OR set the layout to Auto Layout in the general report properties.