You are here

Export excel fromat error in jasperReport Server

Posted on December 29, 2016 at 4:04pm

I use studio create a report

(broken image link)

export xlsx thie format is right in studio .

(broken image link)

but up load report tojasperReport Server ,the format error.

(Broken Image link)

JasperReports® Server

simon_ygp

2

Joined: Dec 2 2016 - 1:03am

Last seen: 6 years 5 months ago

Hi Hozawa, same issue here. after set this xls export properties. this issue is not solved yet.

<bean id="xlsExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean">

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

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

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

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

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

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

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

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

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

<property name="maximumRowsPerSheet" value="0"/>

<property name="xlsFormatPatternsMap" ref="formatPatternsMap"/>

</bean>

md.moniruzzaman - 6 years 7 months ago

Log in or register to post comments

1 Answer:

Posted on December 29, 2016 at 11:24pm

JasperReports Server has a different JasperReports properties settings. Set the xls export properties.

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

hozawa

190723

Joined: Apr 24 2010 - 4:31pm

Last seen: 4 years 3 months ago