nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to wrap up in xlsx and export chart in xls

DarkSilver

Hi all,
I need to ask for few questions, please help me.
 
1) I have many column in a report, in order to show most of them, I set the width in 0.5in and the Whitespace to "Auto". By doing this, in my BIRT Viewer and exporting to xls, the columns are able to wrap up automatically according to the data; it's all good. The problem start when I export it to xlsx, the data (which is longer that 0.5in) not able to wrap up automatically. 
 
Whitespace have 4 options: Auto, No Wrapping, Normal, Preformatted.
 
I have tried both Auto & Normal can't, only Preformatted will be able to allow the data to wrap up when exporting to xlsx, but when I use Preformatted, now the BIRT Viewer is the one not wrap up.
Where can I set it so that I am able to wrap up the data in BIRT Viewer, also when export it to xlsx?
 
I am using BIRT: "Version: Kepler Service Release 1, Build id: 20130919-0819" 
XLS Emitter: "org.eclipse.birt.report.engine.emitter.prototype.excel_4.3.1.v201309131458.jar"
XLSX Emitter: "uk.co.spudsoft.birt.emitters.excel_4.3.1.v201308301349"
 
2) Each time I open my exported xls report, it will pop up this error message "The file format and extension of 'Report_Name.xls' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyways?" When I clicked "Yes", there is nothing wrong with the report.
 
3) What can I do to be able to export my chart in xls? any emitters can be added? please let me know the step on implementing it.
 
Thanks in advance for helping me.

Find more posts tagged with

Comments

JFreeman

Can you attach a sample report based on classic models or a flat file data source we can run that demonstrates the issues?

DarkSilver

Hi JFreeman,
 
Please refer to the attachment sample report.
 
1) Take note that:
<ul><li>"ORDER NUMBER" uses Normal Whitespace. BIRT Viewer wraps up, xlxs not wrap up.</li>
<li>"SHIPPED DATE" uses Preformatted Whitespace. BIRT Viewer not wrap up, xlxs wraps up.</li>
<li>Others use Auto Whitespace. BIRT Viewer wraps up, xlxs not wrap up.</li>
</ul>2) "samplereport.xls" shows error message.
3) What can I do to be able to export my chart in xls? any emitters can be added? please let me know the step on implementing it.
 
Thanks in advance for helping me.

DarkSilver

Hi JFreeman,
 
Please refer to the attachment sample report.
 
1) Take note that:
<ul><li>"ORDER NUMBER" uses Normal Whitespace. BIRT Viewer wraps up, xlxs not wrap up.</li>
<li>"SHIPPED DATE" uses Preformatted Whitespace. BIRT Viewer not wrap up, xlxs wraps up.</li>
<li>Others use Auto Whitespace. BIRT Viewer wraps up, xlxs not wrap up.</li>
</ul>2) "samplereport.xls" shows error message.
3) What can I do to be able to export my chart in xls? any emitters can be added? please let me know the step on implementing it.
 
Thanks in advance for helping me.