BIRT Export content to xlsx - auto fit columns width
<p>Hi, </p>
<p> </p>
<p>The report looks fine in the interactive BIRT viewer, and the layout option is set to Auto(Not Fixed). But when we try to export the report to xlsx/xls the exported columns doesnt preserve the width. the header lables are wrapped, is there anyway can we auto fit the width of the columns once it is exported to xlsx/xls?</p>
<p> </p>
<p>Please let me know if there any setting to apply?</p>
<p> </p>
<p>Thanks for looking into this.</p>
<p> </p>
<p>Thanks</p>
<p>Suresh </p>
<p> </p>
<p>The report looks fine in the interactive BIRT viewer, and the layout option is set to Auto(Not Fixed). But when we try to export the report to xlsx/xls the exported columns doesnt preserve the width. the header lables are wrapped, is there anyway can we auto fit the width of the columns once it is exported to xlsx/xls?</p>
<p> </p>
<p>Please let me know if there any setting to apply?</p>
<p> </p>
<p>Thanks for looking into this.</p>
<p> </p>
<p>Thanks</p>
<p>Suresh </p>
1
Comments
-
Hi Uwe,
You could try a different emitter like this one:
https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads/
If that emitter doesn't help with the issue or if you prefer to use the standard emitter, can you provide an example report. Even just a static data source with a couple rows of data should be enough to illustrate the issue. Along with the report, please describe the desired output (i.e. prevent text wrapping in cells B3 and B4). Also, please let me know if the data in the cells to be modified is static or dynamic.
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management