When generate the jasper report export to excel getting warning messages

[surima.tvs3]

When generate the xlsx report from Jasper using Spring boot. Report generated successfully but getting some warning messages.
In the report design we have not used any group by functions and any other functions. Report is created by drag and drop the field as a simple report.

Please find the below warning content

We found a problem with some content in "test.xlsx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

After click yes, getting the below

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

Please suggest the steps to resolve the warning issue.

[Jivan Phadtare]

Found same error on : https://community.jaspersoft.com/wiki/get-problem-some-content-error-when-opening-report-exported-xlsx

Below is the suggestion :

This problem can be related to complex date format patterns. For example pattern like this:

EEE, d MMM yyyy h:mm a z

This is a Java pattern and it doesn't have a match in Excel. It gets transformed into something like this: 42433.5511111109 and will be the source of this error.

 

Hope this finds you useful.

[surima.tvs3]

Thanks for the answer. But even a blank report also getting error only.
Anyone please suggest any solution.

[surima.tvs3]

Even a blank report also getting error only.
Anyone please suggest any solution.