Is there not the same function in XLSX format as XLS format export properties?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

Hi everyone!

When creating Excel reports of XLS format with Jaspersoft Studio, we can control a wide variety of controls with Export properties like this article.

"Locking / protecting a cell or column in JasperSoft Studio"

Those functions is very powerfull and wonderful for excel reports.

Can Jaspersoft Studio does the same thing in XLSX format?

Like those




Please someone suggest to me!

hongming8888's picture
Joined: Feb 18 2016 - 5:03am
Last seen: 3 months 3 weeks ago

Thank Hozawa for your reply!

In my sample report, it works fine with XLS format, but does not work with XLSX format.

What's wrong below my report?

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version using JasperReports Library version 6.5.1  -->
<jasperReport xmlns="" xmlns:xsi="" xsi:schemaLocation="" name="Locked_Unlocked_Cell_Sample_Report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b18969a8-f778-462b-959b-f934fe4c7419">
    <property name="" value="CIPS-IT2"/>
    <property name="" value=""/>
    <property name="net.sf.jasperreports.export.xls.password" value="password"/>
    <property name="net.sf.jasperreports.export.xlsx.password" value="password"/>
    <property name="" value="Only specific items can be entered Form Excel format."/>
        <![CDATA[SELECT 'A001' AS "Item1" FROM DUAL]]>
    <field name="Item1" class="java.lang.String">
        <property name="" value="Item1"/>
        <band splitType="Stretch"/>
        <band height="30" splitType="Stretch">
                <reportElement mode="Opaque" x="0" y="0" width="550" height="30" backcolor="#53C7FC" uuid="e2ad14aa-2f03-480a-b34b-57704c51da24"/>
                <textElement textAlignment="Center">
                    <font fontName="SansSerif" size="14"/>
                <text><![CDATA[About Locked/Unlocked Cell,  Excel Sample Report]]></text>
        <band height="66" splitType="Stretch">
                <reportElement x="0" y="0" width="100" height="30" uuid="86163db2-7c7c-4b7d-a8f9-01d9d22134e3"/>
                    <font fontName="SansSerif"/>
                <reportElement x="0" y="30" width="100" height="30" uuid="ca7c0ea8-5076-4ba3-8018-7ace7b52ca29"/>
                    <font fontName="SansSerif"/>
                <reportElement key="" x="100" y="0" width="450" height="30" forecolor="#FC0703" uuid="25a43960-ec90-4018-b1be-e588744f5bea">
                    <property name="net.sf.jasperreports.export.xls.cell.locked" value="false"/>
                    <font fontName="SansSerif"/>
                <reportElement x="100" y="30" width="450" height="30" uuid="6ec762ac-bf82-4606-a351-17d3c7188fab"/>
                    <font fontName="SansSerif"/>

hongming8888 - 3 years 4 months ago

1 Answer:

xls properties should be effective with xlsx too.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 3 weeks ago