Property for show or hide grid line XLS

Hi,

 

Thank you for spending your time on this problem.

The patch is ok, but it's limted to a particular case (JRXlsExporter only, with property defined at report level).

 

We considered an extended implementation to include all Excel exporters, and to allow the new property to be defined at element level. This is very useful when in a given document some sheets should hide gridlines and some others should not.

 

Sources are now available on the svn(rev 5616), please feel free to test them and see if they are now according to your needs.

 

The name of the new property is net.sf.jasperreports.export.xls.show.gridlines.

 

Regards,

sanda

Changed Priority from Normal to High

Changed Severity from Minor to Major

Changed Reproducibility from Not Attempted to Always

Changed Resolution from Fixed to Open

Changed Status from Closed to New

---

Hi,Is this patch is included in the latest releases?I have checked in 5.0.1 and 5.0.4 but not found these changes.

Changed Resolution from Open to Fixed

Changed Status from New to Resolved

---

Hi,The feature is available for both 5.0.1 and 5.0.4.Could you be more specific about the issues you've got? Thank you,sanda

Hi Sanda,

 

Thanks for your response.

Actually my requirement is to have white background(no grid lines) for entire excel sheet. For that I have configured net.sf.jasperreports.export.xls.show.gridlines property as false in my jrxml. But I am not getting white background as expected by using 5.0.1 or 5.0.4 jars. But by using the above attached files, I am able to get white back ground as per my expectation. I had checked the source code for 5.0.1 and 5.0.4 releases, but unable to find the changes related to PROPERTY_SHOW_GRID_LINE property in JRXlsAbstractExporter.java,JRXlsAbstractExporterParameter.java and JRXlsExporter.java which have been attached above.

So, I'm suspecting that these changes might not have been included in these releases.

If these changes are there with 5.0.1 or 5.0.4 or any latest releases, could you please share me related link to download corresponding jars.

 

Thanks,

Sasidhar.

Hi,

 

I just tested the property on a local sample with both JR 5.0.1 and 5.0.4 jars, and it worked as expected. So, the problem might come either from inappropriate jars, or from the jrxml template itself.

The name of the property is PROPERTY_SHOW_GRIDLINES. (see http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.show.gridlines)

Regarding the jars: they can downloaded from

http://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%205.0.1 (JR 5.0.1)

and

http://sourceforge.net/projects/jasperreports/files/jasperreports/JasperReports%205.0.4 (JR 5.0.4)

 

As a notice: make sure your app classpath actually contains only the appropriate JR jar (5.0.1 or 5.0.4) and all other older versions were removed.

 

If the issue still persists, then it might be a problem with the jrxml file. In this case, please attach the jrxml file too.

 

Thank you,

sanda

Hi,

 

Thanks a lot for your support.

Now it is working fine after replacing the jars.

 

 

Thanks,

Sasidhar