We have an issue reported by a customer with the format being used when users export date fields to Excel.
For example, when exporting a date field from an adhoc view into Excel, it appears the date fields are defaulting to the text format in Excel.
Steps followed :
1. An end user has an adhoc view that contains a date field with a timestamp.
2. They are exporting this adhoc view into xls format. When we check the excel document, we can see the format of the date field as General in the exported xls file. (this can be seen by right-clicking the field in Excel, and selecting the Format Cells option)
3. However, the end user would like to have the format of the date field default to be Date format in the given excel file which doesn't seem to be possible in the current version of JasperReports Server. At the moment they have to do this activity manually as a workaround, which can be time-consuming.
Components | JasperReports Server |