Date format changes from "February 20, 2017" to "F 20, 2017" when exported to excel

[plar]

Hi

We have a studio report where we are using "new java.util.Date()" field to populate the date in the report. The date field appears fine on the report but when exported to excel the format changes.

For example, In the report date field appears as "February 20, 2017" but when it is exported to excel it changes to "F 20, 2017". So, we have to manually format the filed in excel to short date and it appears as 2/20/2017.

Our objective is to eliminate the manual job to update the date filed format in excel, please suggest me ideas. 

Is there anything that we can do in Jaspersoft?

Thank you,

Arjun

[hozawa]

I remember doing this but not sure if this is the way I did it. I think I've set "net.sf.jasperreports.export.xls.pattern" property and used xlsx export.

[plar]

Hi Hozawa

Thank you for the response.

Could you please help me with detailed instructions on adding the property, I am new to Jaspersoft.

 

[plar]

I tried giving this property to report but it doesn't seem to be working. '

Went to Properties view and selecting "Advanced" tab and select "Misc" -> "Properties"

Name = net.sf.jasperreports.export.xls.pattern

Value = true

Any other sugegstion?

 

[reportdev]

1. try replacing the field with DATEFORMAT(new Date(), "MM/dd/yyyy" )
2. Enter the Source code of jrxml by clicking on the Source tab for the report
3. you should find some property name, value pairs like below
<property name="ireport.jasperserver.user" value="reportdev"/>
4. At the end of these properties copy below property and save/publish
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>