How to auto-height column?

[pavel.kavaliuk365]

Hi, I have a question about realizing the auto-height feature to a column. I can't understand why it doesn't work.

<style name="common" fontName="Times New Roman" fontSize="12" isBlankWhenNull="true">    <paragraph lineSpacing="1_1_2"/></style>

<style name="halfPointBorder" style="common">    <box><pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/></box></style>

<style name="departmentName" style="halfPointBorder" vTextAlign="Bottom" hTextAlign="Left"/>

<detail>    <band height="18">        ...        <textField textAdjust="StretchHeight">            <reportElement x="160" y="0" width="80" height="18" isRemoveLineWhenBlank="true" style="departmentName"                           stretchType="RelativeToTallestObject">                <property name="net.sf.jasperreports.export.xls.row.outline.level.2" value="Body"/>                <printWhenExpression><![CDATA[$F{areaName} != null]]></printWhenExpression>            </reportElement>            <textElement>                <paragraph lineSpacing="Fixed" lineSpacingSize="24.0" spacingBefore="10" spacingAfter="12"/>            </textElement>            <textFieldExpression><![CDATA[$F{areaName}]]></textFieldExpression>        </textField>            ...    </band></detail>

It is for the column "Участок".

 

[pavel.kavaliuk365]

Helped to add properties to reportElement.
 

<property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/><property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>