[#10266] - net.sf.jasperreports.export.xls.white.page.background does not work for JRXlsMetadataExporter()

Category:
Bug report
Priority:
Normal
Status:
Closed
Project: Severity:
Minor
Resolution:
Works as Designed
Component: Reproducibility:
Always
Assigned to:
0

We are working with v6.5 of the library and JSS eclipse plugin.

When we export using 'JRXlsMetadataExporter()', the cell background is white and the grid lines are not visible.

Adding the property, 'net.sf.jasperreports.export.xls.white.page.background' with a value of 'false' does not affect the output. We applied the property at both the report and element levels with the same results.

In our testing, we found that the property does appear to function correctly using just the plain 'JRXlsExporter()' method, but we must use the 'JRXlsMetadataExporter()' method to strip the report formatting.

gthompson's picture
Joined: Feb 28 2013 - 12:16pm
Last seen: 33 min 8 sec ago

2 Comments:

#1
  • Resolution:Open» Works as Designed
  • Status:New» Feedback Requested
  • Assigned:nobody» shertage

In addition, you need to set

net.sf.jasperreports.export.xls.ignore.cell.background=true

to instruct the metadata exporter to ignore the default background color of report elements.
Please let us know if this setting solved the problem for you.

Thanks,
Sanda

#2
  • Status:Feedback Requested» Closed

Thanks! We had tried both properties, but never together. By combining them both, we attained the desired results.

Feedback
randomness