In excel output row is getting split to next row because data is more in the cell, but i want data in the same cell. I'm using jasper 5.6

[smadhusudanreddy8]

Data is getting split to next row. I want the below column data to come in one cell even if the data is large.

             <band height="100"  splitType="Prevent" >               

             <textField isBlankWhenNull="true">
                <reportElement x="5000" y="0" width="100" height="30">
                <property name="net.sf.jasperreports.export.xls.column.width.ratio" value="2.25f"/>
                <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>
                    <printWhenExpression><![CDATA[$P{ecs_report_parameter_attrs_to_export}.contains("ecs_rend_name")]]></printWhenExpression>
                </reportElement>
                <textElement>
                     <font fontName="Arial"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA["Rendition Name"]]></textFieldExpression>
               </textField>
                  

            <textField isStretchWithOverflow="true" isBlankWhenNull="true">
                <reportElement stretchType="RelativeToBandHeight" x="5000" y="0" width="100" height="15" isPrintInFirstWholeBand="true" isPrintWhenDetailOverflows="true"/>
                <textElement>
                    <font fontName="Arial"/>
                </textElement>
                <textFieldExpression class="java.lang.String"><![CDATA[ECSFValueFormatter.formatRepeatingString($F{ecs_rend_name},",")]]></textFieldExpression>
            </textField>

I have used isStretchWithOverflow="true" and <property name="net.sf.jasperreports.export.xls.column.width.ratio" value="2.25f"/>
                <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>

 

but nothing working once cell got bigger but still data is splitted to next row