Export excel fromat error in jasperReport Server

Posted on December 29, 2016 at 4:04pm

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

   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's picture
simon_ygp
2
Joined: Dec 2 2016 - 1:03am
Last seen: 5 years 2 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 - 5 years 4 months ago
add comment

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's picture
hozawa
131818
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 3 weeks ago
Feedback