Exporter Parameter + JasperViewer

[thiagot]

Hello,

 

I need a hand here.

 

My application is using JasperViewer but his XLS exporter isn't working well. The cells with any pattern (dd/MM/yyyy or ###0,00) comes with a single quote before the value in XLS (like '04/10/1999).

 

I made a code that sets the IS_DETECT_CELL_TYPE to true (exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true) and generated a XLS file with it and worked just fine! :)

 

The problem is that I need to do it using JasperViewer, I must add this parameter to the JasperViewer's XLS exporter. :(

 

Is there any way that can be done?

 

Thanks,

Thiago

[szaharia]

At this moment it cannot be done without modifying by hand the JRViewer class, I'm afraid.

You could post a feature request here http://jasperforge.org/sf/tracker/do/listArtifacts/projects.jasperreports/tracker.feature_requests.

 

Best regards,

sanda

[Teodor Danciu]

Hi,

 

You can customize the way documents are exported from the Swing viewer by implementing and then registering a custom "save contributor".

In JasperReports, the reusable viewer component is not exactly the JasperViewer class, but rather the JRViewer panel.

You can instantiate the JRViewer and remove the existing XLS save contributors and add a JRSaveContributor implementation of your own, that would even prompt you for export options using a dialog.

You can try implement your save contributor by looking into the ones we ship with the library by default.

 

I hope this helps.

Teodor

[thiagot]

Hi,

 

First of all, thanks a lot for the reply.

 

One thing, how can I retrieve the reference of the JRViewer within my JasperViewer? So I can get it to call the method addSaveContributor(mySaveContributor).

 

Code:

JasperViewer jrviewer = new JasperViewer(print, false);
jrviewer.setVisible(true);

 

I can't get the reference to the JRViewer in my "jrviewer".

Will I have to change the source of the JRViewer.java and JasperViewer.java?

 

Thanks a lot,

Thiago

[szaharia]

Hi,

 

the JRViewer member was private, indeed. We modified this to be protected, and changes were committed here.

You could use either the latest version of the JasperViewer class, or you can create your own class which extends the old JasperViewer, having a much more visible JRViewer member.

 

Thank you,

sanda

[thiagot]

Thanks a lot!!!

That will do :D

 

Thiago