Export excel fromat error in jasperReport Server

   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)
simon_ygp's picture
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

1 Answer:

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

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

hozawa's picture
190723
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Feedback