XLS element suppression

[jbarrow]

I would like to verify that xls element suppression bacame available in release 2.0.2.

 

In an old version (1.2.8) I have tried the following with no effect.

 

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.header" value="pageHeader"/>

<property name="net.sf.jasperreports.export.xls.exclude.origin.band.footer" value="pageFooter"/>

 

Thanks.

 

-James

[jbarrow]

I had a copy of 2.0.4 and the element suppression I was looking for works. It would still be interesting to know when this feature became available.

 

-James

[lucianc]

Export origin filters for the XLS exporter(s) have been introduced in JasperReports 2.0.2; in JR 2.0.3 the same functionality has been made available for all exporters.

 

Regards,

Lucian

[jbarrow]

Thanks Lucian.

 

I have another question. My xls export now has the header and footer data removed, but the rows where the data had been displayed is still there. These rows appear in the xls file with the same size as the bands that are supposed to be excluded from the export.

 

How can I make the rows not appear in the xls file?

 

-James

[lucianc]

Put

Code:

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>

in the JRXML, or set the JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS flag to true at export time.

 

HTH,

Lucian

[jbarrow]

Thanks again Lucian.

 

I have looked through the online documentation and I have had a hard time finding an resource that would have answered my recent questions.

 

Is there a resource that describes what is available in net.sf.jasperreports.export.xls.*, for the Jasper objects as well as the jrxml?

 

-James

[lucianc]

jbarrow wrote:

Is there a resource that describes what is available in net.sf.jasperreports.export.xls.*, for the Jasper objects as well as the jrxml?

 

You can consult the JasperReports API Javadocs and the configuration reference.

 

Regards,

Lucian