How to show cell borders in XLSX export of my reports?

Question:

I would like to show/enable cell borders in XLS/X output.

I would like that this adjustment should be available

in the output that should be generated from AdHoc View

How this could be achieved?

Answer:

This can be achieved with the scenario that I quote below:

- open in your favorite editor the configuration file:

jasperserver-proWEB-INFapplicationContext.xml

- find the part of configuration that is related to XLS export (xlsExportParameters)

and set the property ignoreCellBorder to false:

<property name="ignoreCellBorder" value="false"/>

Please see the screenshot below:

- save the configuration file

- application server should be restarted to apply the adjustment

that has been done