[#12241] - XLS Export Image Retain Shape

Category:
Bug report
Priority:
Immediate
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

Image Retain shape parameter is not takin in account when export Report into xls. The image is shaped to zoom in Cell Size.
The exprt XLs works fine with Jasper Studio 6.10 but not with previous version of Studio.
Notice that this is the same for Local ressources image and query images (blob format).
This quit urgent I have 200 reports to migrate from JRS 4.2.1 to JRS 6.43

jrxl sample

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown -->
<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="XLSImageexport" columnCount="15" printOrder="Horizontal" pageWidth="1117" pageHeight="210" orientation="Landscape" columnWidth="74" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="ae0dfe18-94a6-491c-a857-498863583b24">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="C8_Reports"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="ireport.jasperserver.url" value="http://localhost:8086/jasperserver/"/>
<property name="ireport.jasperserver.user" value="jasperadmin"/>
<property name="ireport.jasperserver.report.resource" value="/RR/XLSImageexport_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/RR/XLSImageexport"/>
<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>
<property name="net.sf.jasperreports.export.xls.image.border.fix.enabled" value="true"/>
<property name="net.sf.jasperreports.export.xls.font.size.fix.enabled" value="true"/>
<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.hyperlink" value="true"/>
<queryString>
<![CDATA[SELECT top 100 [_id_]
,[Style]
,[Image]
,[Active]
,[BOM]
,[Brand/BU]
,[CarryOver]
,[Description]
,[_ExportedDate_]
FROM [Reports].[dbo].[Style] where [Image] is not Null]]>
</queryString>
<field name="_id_" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="_id_"/>
</field>
<field name="Style" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Style"/>
</field>
<field name="Image" class="java.io.InputStream">
<property name="com.jaspersoft.studio.field.label" value="Image"/>
</field>
<field name="Active" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Active"/>
</field>
<field name="BOM" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="BOM"/>
</field>
<field name="Brand/BU" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Brand/BU"/>
</field>
<field name="CarryOver" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="CarryOver"/>
</field>
<field name="Description" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="Description"/>
</field>
<field name="_ExportedDate_" class="java.sql.Timestamp">
<property name="com.jaspersoft.studio.field.label" value="_ExportedDate_"/>
</field>
<detail>
<band height="111" splitType="Stretch">
<image scaleImage="RetainShape" hAlign="Center" vAlign="Middle" onErrorType="Icon">
<reportElement mode="Opaque" x="0" y="0" width="74" height="65" uuid="036c5190-cfdf-4ccd-a81e-17dca2265c14">
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="true"/>
<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>
<property name="net.sf.jasperreports.export.xls.image.border.fix.enabled" value="true"/>
<property name="net.sf.jasperreports.export.xls.font.size.fix.enabled" value="true"/>
<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
<property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
</reportElement>
<box>
<pen lineColor="#FFFFFF"/>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<imageExpression><![CDATA[$F{Image}]]></imageExpression>
</image>
<textField>
<reportElement mode="Opaque" x="0" y="65" width="75" height="15" backcolor="#F2CAC9" uuid="12619d5f-b5cc-41fe-8267-678baf6877ae">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Calibri" size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{Style}]]></textFieldExpression>
</textField>
<textField>
<reportElement mode="Opaque" x="0" y="80" width="75" height="15" backcolor="#F2CAC9" uuid="026d7b32-4cc3-4f42-8f97-9b7e6a06ceb8">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Calibri" size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{BOM}]]></textFieldExpression>
</textField>
<textField>
<reportElement mode="Opaque" x="0" y="95" width="75" height="15" backcolor="#F2CAC9" uuid="f71f45d9-aa60-44c5-a292-ffa2f750f1cd">
<property name="com.jaspersoft.studio.unit.x" value="px"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Calibri" size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{Brand/BU}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>

v6.4.3
JasperServer
ntaibi's picture
5
Joined: Sep 23 2019 - 5:54am
Last seen: 2 hours 14 min ago
Feedback