Excel Date is different

Support
#1

Hello Team,

I made a modification in the messages.properties in order to change the date format: dateFormat = dd-MM-yyyy.
Now even the date is displayed correctly in the application, when I print the Excel table (Excel button) the date is displayed in the old format:
image

Please advise!
-n

#3

Done!
Finally I use for each date

 <column id="myDate" caption="myDate">
                    <formatter class="com.haulmont.cuba.gui.components..formatters.DateFormatter" format="dd-MM-yyyy "/>

            </column>

Also I use CUBA/Project Properties/Available locale/Show data format dd-MM-yyyy.
(After I set …dateFormat and press OK, in order to view recently modifications you have to select English…)

#4

Hi,

pay attention DateFormatter returns the String value and date cell in the created file will have String type, not a Date. You can use this property in the main message pack:

excelExporter.dateFormat=d-mmm-yy

Java and Excel date formatting slightly differ. You should check which format will work with Excel. Also see org.apache.poi.ss.usermodel.BuiltinFormats class for available formarts.