Wrap Label text of table/Crosstab cell

I am using BIRT4.4.1 for my report generation in eclipse. I have designed the report with more tables and crosstab used. I am facing problem when i export it to excel report.
 
I would like to wrap my text of Table Header, it works fine in webviewer but when i exported to excel the table cell text is in a single line, and also the text is overflowed. I dont want to make the cell width equal to the content, I would like to wrap the text based on its container width.
I have set the cell width and label whitespace property as auto. is it correct, or what do i do to make it work in exported excel report?
 
In web,

Find more posts tagged with

Comments

newscott

Hi,
 
 If i understand your problem correctly, i guess you were not using Ctrl + Enter for the header text. 
 
Thanks,
newscott.

Mani Kandan

Mr.newscott please tell me exactly what i have to do to set wrap text property for whole report.

newscott

You were using data element as header mean please use below script in on render of that particular data element.
 
if (reportContext.getOutputFormat() == "xlsx" || reportContext.getOutputFormat() == "xls_spudsoft" ){
<div>this.getStyle().whiteSpace = "pre";</div>
<div>}else{</div>
<div>}</div>

Mani Kandan

No my header has label only.

newscott

If it is label then no issue...Just wrap text manually using Ctrl+Enter

Mani Kandan

@newscott Your method is worked in excel(that is whatever i seen on report design, excel looks the same(have not set wrap text for that cell)) but my requirement is i want the "wrap text" option should be enabled for the headers in excel report.

Mani Kandan

newscott I have solved by setting whitespace to 'preformatted' for the labels. Its working in excel but not in webviewer. so i would like it to be same in both webviewer and excel. so is there any way to set this property only when i exported to excel?

newscott

Can you please attach a sample report...

Mani Kandan

I solved it by setting "preformatted" whitespace to the element and also setting its width.