Wrap text of Table cell in exported Excel in BIRT

0 votes

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

enter image description here

After exported, Excel view

enter image description here

Oct 29 in Others by Kithuzzz
• 20,660 points
54 views

1 answer to this question.

0 votes
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.
answered Oct 29 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
529 views
0 votes
1 answer
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
68 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
33 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
397 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,371 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,836 views
0 votes
1 answer

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
73 views
0 votes
1 answer

Change the size of one cell in excel 2016

I'm sorry, but it's not feasible. A ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
48 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP