ODS file exported by JROdsExporter is loosing texts cells when opened with MS Excel. (Image1)
The same ODS file works correctly when opend by Openoffice. (Image2)
The same problem happends in the doc samples of the jasperreports-6.17.0 library.
I think it’s a problem at JROdsExporter.insertPageAnchor, that adds JR_PAGE_ANCHOR_0_1 in the name of first cell of ODS file.
If I open the file with Openoffice and remove the first cell that contains the name JR_PAGE_ANCHOR_0_1 and save , then the file opens correctly with MS Excel.
I am using the jasperreports-6.17.0 library, jdk1.8.0_281 and spring boot 2.5.1.
Do you have any settings to avoid this problem ?