why it is have no lines

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

configuration.setShowGridLines(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">TRUE</span>);
configuration.setSheetTabColor(Color.<span style="color:#660e7a;font-weight:bold;font-style:italic;">red</span>);
configuration.setOnePagePerSheet(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">FALSE</span>);
configuration.setRemoveEmptySpaceBetweenColumns(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">TRUE</span>);

1021866588's picture
Joined: Mar 17 2016 - 6:13am
Last seen: 6 years 1 month ago

2 Answers:

Do you have grid lines in your jrxml text elements? The property just shows grid lines when there is one in the report layout.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 2 weeks ago

By default, generated sheets come with whitePageBackground property set to true, which will make sheet's content to appear as drawn on a white page. To  avoid this behavior you need to use the following setting:


Another way would be to set the following property in your JRXML file, if available:

<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>

I hope this helps,


shertage's picture
Joined: Sep 26 2006 - 8:06pm
Last seen: 1 week 5 days ago