Jump to content
  • Property for show or hide grid line XLS

    Assigned User shertage
    CategoryBug report
    Property in the library to be shown or not the grid line XLS file generated.

    User Feedback

    Recommended Comments



    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.




    Link to comment
    Share on other sites

    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.
    Link to comment
    Share on other sites

    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
    Link to comment
    Share on other sites

    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.




    Link to comment
    Share on other sites



    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)


    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,


    Link to comment
    Share on other sites

    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

  • Create New...