Jump to content
We've recently updated our Privacy Statement, available here ×

JasperServer to Excel deleting cell borders


jack w.
Go to solution Solved by jack w.,

Recommended Posts

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:

https://community.jaspersoft.com/wiki/tips-exporting-excel

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">
        <box>

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

jH6Bvv5.png

Thanks for help

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution

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.

https://community.jaspersoft.com/wiki/xls-export-parameters-jasperreports-server

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.

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...