JasperServer to Excel deleting cell borders

I've just started learning to work with JasperServer and uploaded my report. When I export my report to .xls from my local directory, everything works just fine. The problem is, when I want to generate the .xls report from the server, it deletes cell borders from my report. Why is this happening? I've found this property:

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

under this link:


Still, it's not working. Maybe I'm putting it in a wrong spot? I don't think it matters though, but here is the part of my XML code where I put the above property:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3  -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="81 test" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="05b3d052-31ff-4f8e-a52a-7fffa81abc28">
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="BazadanychKZ.xml"/>
    <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/"/>
    <property name="ireport.jasperserver.user" value="jasperadmin"/>
    <property name="ireport.jasperserver.report.resource" value="/reports/10_RaportZestawienie_files/main_jrxml"/>
    <property name="ireport.jasperserver.reportUnit" value="/reports/10_RaportZestawienie"/>
    <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
    <style name="Crosstab_CH" mode="Opaque" backcolor="#D2691E">

And also, heres a screenshot with the looks of my report after exporting to .xls using the server:

Thanks for help

jack w.'s picture
Joined: Nov 9 2017 - 2:41am
Last seen: 5 years 10 months ago

1 Answer:

This is ridiculous, how I try to do something for an hour, post the question and then get the solution myself. This link shows the list of parameters, but as I'm new to the Jasper, I make stupid mistakes.


I've tried to put the "ignore cell border" property this way:

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

I don't know why the examples are written this way under the above link, but when I put this:

<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"/>

It started working.

jack w.'s picture
Joined: Nov 9 2017 - 2:41am
Last seen: 5 years 10 months ago

Not surprising.  Working to make your quesiton clear to others can also make it clearer to yourself.

djohnson53 - 5 years 10 months ago