Export excel fromat error in jasperReport Server

[simon_ygp]

   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)

[hozawa]

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

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

[md.moniruzzaman]

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>