Unmerge two cells in Jasper report when it is downloaded as XLSX

[minschka]

Hey guys!

Currently I am working with Jaspersoft Studio 6.2.

Right now I want to seperate two columns which are merged when I download the report as XLSX.

E.g. the column "margin" appears seperately in the report but as sonn as I download the report as XLSX, two cells, e.g. B and C, are merged in Excel (which should not be the case).

Any suggestions how to fix this issue?

Thanks in advance!

[reportdev]

align all the fields in grid lines of your report layout. it will eliminate the merging of cells in xlsx.

sample jrxml

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0  --><!-- 2017-02-27T09:34:54 --><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="conditional" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="db6c00f0-db29-49f5-8e70-22e8b82b00ea">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <queryString>        <![CDATA[select 2017as year,700000as figure1,390000 as figure2,98000 as figure3,50000 as figure4 from dual unionselect 2018as year,250000as figure1,85000 as figure2,70000 as figure3,160000 as figure4 from dual unionselect 2019as year,21149.43as figure1,9252.87 as figure2,0 as figure3,0 as figure4 from dual]]>    </queryString>    <field name="YEAR" class="java.math.BigDecimal"/>    <field name="FIGURE1" class="java.math.BigDecimal"/>    <field name="FIGURE2" class="java.math.BigDecimal"/>    <field name="FIGURE3" class="java.math.BigDecimal"/>    <field name="FIGURE4" class="java.math.BigDecimal"/>    <variable name="Sum" class="java.math.BigDecimal" incrementType="Column" calculation="Sum">        <variableExpression><![CDATA[$F{FIGURE1}.add($F{FIGURE2}).add($F{FIGURE3}).add($F{FIGURE4})]]></variableExpression>    </variable>    <background>        <band splitType="Stretch"/>    </background>    <columnHeader>        <band height="20" splitType="Stretch">            <staticText>                <reportElement x="0" y="0" width="80" height="20" uuid="46953091-95ae-45a0-824a-c6349193ff95"/>                <text><![CDATA[YEAR]]></text>            </staticText>            <staticText>                <reportElement x="180" y="0" width="100" height="20" uuid="c6dc70ef-2c28-4d64-9df8-c42816c01f31"/>                <text><![CDATA[FIGURE1]]></text>            </staticText>            <staticText>                <reportElement x="280" y="0" width="100" height="20" uuid="e9585303-7fe5-4507-a3c7-644f754e679f"/>                <text><![CDATA[FIGURE2]]></text>            </staticText>            <staticText>                <reportElement x="380" y="0" width="100" height="20" uuid="8239325a-b107-4454-81ed-e39d9514bb26"/>                <text><![CDATA[FIGURE3]]></text>            </staticText>            <staticText>                <reportElement x="480" y="0" width="100" height="20" uuid="e514dc9e-41e3-4d5b-945f-8075a4e15f55"/>                <text><![CDATA[FIGURE4]]></text>            </staticText>            <staticText>                <reportElement x="80" y="0" width="100" height="20" uuid="4f52ebc9-80bc-4db2-8dc5-50e49bb2ade5"/>                <text><![CDATA[sum]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="20" splitType="Stretch">            <textField>                <reportElement x="0" y="0" width="80" height="20" uuid="d50a5931-7d89-4975-a885-18f1449986e1"/>                <textFieldExpression><![CDATA[$F{YEAR}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.##;¤-#,##0.00">                <reportElement x="180" y="0" width="100" height="20" uuid="3767ad7c-044a-48b2-85fe-884d4a721517"/>                <textFieldExpression><![CDATA[$F{FIGURE1}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.##;¤-#,##0.00">                <reportElement x="280" y="0" width="100" height="20" uuid="949b7196-f620-4a45-a0a2-ebfc97016ae3"/>                <textFieldExpression><![CDATA[$F{FIGURE2}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.##;¤-#,##0.00">                <reportElement x="380" y="0" width="100" height="20" uuid="bd1411b1-1326-43bb-a42c-ec8f91a30170"/>                <textFieldExpression><![CDATA[$F{FIGURE3}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.##;¤-#,##0.00">                <reportElement x="480" y="0" width="100" height="20" uuid="304de87a-d1d9-4c65-82b1-20d3a5f54a06"/>                <textFieldExpression><![CDATA[$F{FIGURE4}]]></textFieldExpression>            </textField>            <textField pattern="¤#,##0.##;¤-#,##0.00">                <reportElement x="80" y="0" width="100" height="20" uuid="e8c5c029-32dd-47c6-8f6a-d623645f3f4c"/>                <textFieldExpression><![CDATA[$V{Sum}]]></textFieldExpression>            </textField>        </band>    </detail></jasperReport>[/code]