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, 2022 in Others by Kithuzzz
• 38,010 points
749 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, 2022 by narikkadan
• 63,420 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, 2022 in Others by gaurav
• 23,260 points
1,288 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,420 points
955 views
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, 2022 in Others by narikkadan
• 63,420 points
3,305 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, 2022 in Others by narikkadan
• 63,420 points
397 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,740 points
876 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,090 points
813 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,090 points
4,063 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
3,789 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, 2022 in Others by narikkadan
• 63,420 points
735 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, 2022 in Others by narikkadan
• 63,420 points
311 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