Hi all, I am trying to use the net.sf.jasperreports.export.xls.pattern.{arbitrary_pattern} in Jasper studio pro 7.1 to set the time format for a cell that I export to excel. Mt textfield code looks like this: <textField pattern="h:mm a"> <reportElement x="625" y="18" width="100" height="16" uuid="bcea4688-0afe-4091-880e-f52b375c7a95"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.rightIndent" value="px"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="px"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Bottom"> <font size="6"/> <paragraph leftIndent="2" rightIndent="2"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField>[/code]I have set the pattern in the following ways: <property name="net.sf.jasperreports.export.xls.pattern.h:mm a=h:mm AM/PM"/>[/code]or <property name="net.sf.jasperreports.export.xls.pattern.h:mm a=h:mm AM/PM"/>[/code]In both cases, when I export to excel, my time in the cell looks like 13:43 a and when I look in the formula window, I see 5/31/2019 1:43:26 PM. Can someone please tell me what I am doing incorrect?
