Jasper Report Freeze header of Excel report

Question

I am using Jasper IReport designer version 3.7.6 . Is there any way to freeze the first two rows of the excel report that is generated? Below is a part of the column header. Row 1 is the PDD , Row 2 is Reparto. I want them freezed during scroll.

<columnHeader>
    <band height="24">
        <staticText>
            <reportElement x="0" y="0" width="50" height="12">
                <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Bottom"/>
            </reportElement>
            <textElement verticalAlignment="Middle">
                <font size="7" isBold="true"/>
            </textElement>
            <text><![CDATA[ Pdd]]></text>
        </staticText>
        <staticText>
            <reportElement x="0" y="12" width="50" height="12"/>
            <textElement verticalAlignment="Middle">
                <font size="7" isBold="true"/>
            </textElement>
            <text><![CDATA[ Reparto]]></text>
        </staticText>
    </band>
</columnHeader>

From the documentation : https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.freeze.column

I tried to use: net.sf.jasperreports.export.xls.freeze.row

net.sf.jasperreports.export.xls.freeze.row.edge

without success. I am guessing it's because I am using an older version of Jasper Ireport. Is there any alternative to achieve my goal without updating the version of the app. Updating the version is not an option.

Thank you

Answer 1

Changing the export type from xlsx to xls managed to solve the issue.