hongming8888

Hi all, I'm currently creating a budget management excel report. The report has a budget entry field using Text Field element. This item is blank and is an operational specification in which the budget manager inputs the amount to the export in Excel report. And it is a requirement that this item has Excel amount formatting. If there are any numbers, for example zero, it will format fine. However, if there is no value, the set format could not be reflected in the cell. I have tried two formatting methods. Method 1: How to format the Patten property of a Text Field element <textField pattern="#,##0"> Method 2: How to set the net.sf.jasperreports.export.xls.pattern property in the Text Field element and format the Value <textField> <reportElement key="" style="Style7" x="104" y="42" width="58" height="14" uuid="cb95cc41-dd52-4ca3-9c53-211993d223dd"> <property name="net.sf.jasperreports.export.xls.pattern" value="#,##0"/> </reportElement> </textField> Reference article:net.sf.jasperreports.export.xls.pattern to export time format to Excel | Jaspersoft Community Is there a way to force the format even if there is no value? The version of Studio I'm using is 6.5.1. Best Regard.

Someone suggest this issue!

I'm also facing this issue, someone give a solution!

I want to know that how to solve it.

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 6.5.1.final using JasperReports Library version 6.5.1 --> <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="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="com.jaspersoft.studio.data.defaultdataadapter" value="CIPS-IT2"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="net.sf.jasperreports.export.xls.password" value="password"/> <property name="net.sf.jasperreports.export.xlsx.password" value="password"/> <property name="com.jaspersoft.studio.report.description" value="Only specific items can be entered Form Excel format."/> <queryString> <![CDATA[sELECT 'A001' AS "Item1" FROM DUAL]]> </queryString> <field name="Item1" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Item1"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="30" splitType="Stretch"> <staticText> <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"/> </textElement> <text><![CDATA[About Locked/Unlocked Cell, Excel Sample Report]]></text> </staticText> </band> </title> <detail> <band height="66" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="100" height="30" uuid="86163db2-7c7c-4b7d-a8f9-01d9d22134e3"/> <textElement> <font fontName="SansSerif"/> </textElement> <text><![CDATA[item1]]></text> </staticText> <staticText> <reportElement x="0" y="30" width="100" height="30" uuid="ca7c0ea8-5076-4ba3-8018-7ace7b52ca29"/> <textElement> <font fontName="SansSerif"/> </textElement> <text><![CDATA[item2]]></text> </staticText> <textField> <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"/> </reportElement> <textElement> <font fontName="SansSerif"/> </textElement> <textFieldExpression><![CDATA["Unlocked"]]></textFieldExpression> </textField> <textField> <reportElement x="100" y="30" width="450" height="30" uuid="6ec762ac-bf82-4606-a351-17d3c7188fab"/> <textElement> <font fontName="SansSerif"/> </textElement> <textFieldExpression><![CDATA["Locked"]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

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" https://community.jaspersoft.com/questions/852006/locking-protecting-cell-or-column-jaspersoft-studio Those functions is very powerfull and wonderful for excel reports. Can Jaspersoft Studio does the same thing in XLSX format? Like those net.sf.jasperreports.export.xlsx.password net.sf.jasperreports.export.xlsx.cell.locked Please someone suggest to me!

Hi evryone. I want to use Japanese font name "ＭＳ 明朝" that contains multibyte character at the font name in RTF format. In XLS format, Japanese font name that contains multibyte character works fine! However in RTF format, multibyte characters "明朝" of the font name are garbled. Please someone help me!!

Hi everyone! I want know whether at Text Field element can use a function like MS Word pagraph setting option "Allow Latin text to wrap in the middle of word". does anyone know it? Attachments testjrxml

Me too.Does anyone know a good way about the issue?If there is a solution, I think that it is useful for business excel reports.