在BIRT的导出Excel中包装表格单元格的文本

问题描述

我在eclipse中使用BIRT 4.4.1来生成报表。

我想包装我的Table Header文本，它在webviewer中工作正常，但是当我导出到excel表格单元格文本是在一行，而且文本也被溢出。我不想使单元格宽度等于内容，我想根据其容器宽度来包装文本。

我设置了单元格宽度和标签空格财产为汽车。是否正确，或者我如何使其在导出的excel报表中工作？

在Webview

导出后，Excel视图

解决方案

在4.4.2导出为XLS（不是xlsx）。作为解决方法，您还可以在文本中添加行返回，并在导出到xlsx时正确显示。

与xlsx输出配合使用的第三个选项是选择单元格中的文本框和常规属性将空格设置为预格式化。然后，将标题单元格大小设置为覆盖整个报表的一般属性所需的文本或高度，将布局设置为自动布局。

I am using BIRT 4.4.1 in eclipse for report generation.

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 Webview

After exported, Excel view

解决方案

In 4.4.2 export as XLS (not xlsx). As a workaround you can also add a line return within the text and that will appear correctly when you export to xlsx.

A third option that works with xlsx output is to select the text box in the cell, and in General Properties set the Whitespace to Preformatted. Then, either set the header cell size to a height that covers the required text OR in general properties of the entire report, set the layout to Auto Layout.

这篇关于在BIRT的导出Excel中包装表格单元格的文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！