Marek D.

Facing the same problem in XLSx. In XLS everything works smoothly. Is there anyone who managed to find a workaround? Thank you!

I respectfully disagree. Jasper CAN automatically adjust column widths—I have tested this functionality extensively over the years, and it works flawlessly. However, as mentioned earlier, this feature is only supported when exporting to the .XLS (Excel) format and not .XLSX. Secondly, of course not to other formats, such as PDF, Word - for them such a parametr does not exist of course. The Jasper engine itself does not perform the adjustment. It simply instructs Microsoft Excel to activate a flag that enables this functionality (you can see that in the attachment). You can refer to the official documentation for confirmation or test on your own. https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.auto.fit.column Additionally, a similar issue has been earlier discussed on this forum (but unfortunatelly was not resolved). Please see the link for more details. Thank you.

I would like to export a complex Jasper report containing multiple columns, which need to auto-fit to column widths, to Microsoft Excel (.XLSX) format. Everything works fine when exporting to .XLS format. However, when I try exporting to .XLSX, the parameters: <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> seem to be completely ignored - they should stretch the columns width according to the text content inside them - but in .XLSX this obviously does not work. The column widths are not adjusted according to the text content. Instead, they remain unchanged. I have tested this issue across multiple JasperSoft Studio versions, but the problem persists in all of them. Attached are the "problematic" sections of the .jrxml file and the generated outputs in both .XLS (which displays the correct behavior) and .XLSX (where the parameters appear to be ignored, resulting in a distorted output). The data in the attachments has been anonymized for privacy. I would like to know: If this is a known issue or bug. When a fix might be available. If there are any "workaround" solutions to resolve the issue. Thank you in advance for your assistance. JRXML.xml XLSX - wrong.xlsx XLS - correct.xls

Try this solution in my case this worked perfectly!

Thank you for the clarification. The property: <property name="net.sf.jasperreports.export.docx.frames.as.nested.tables" value="false"/> worked perfectly—I included it in the Jasper Server configuration file to apply it to all reports. However, setting the property: <property name="net.sf.jasperreports.export.docx.table.fitColumns" value="true"/> did not make any difference in my (our) case, so I omitted it. Still, I’m saving this solution for future reference, in case something similar arises. Thank you very much for your advice!

I have been facing the same issue since Microsoft released version 2409 of MS Office Word. Unfortunately, there doesn’t seem to be a workaround yet. I re-posted the issue on the forum, hoping it will be resolved soon, but unfortunately, I think it’s a bug on Microsoft’s side, not the Jasper team’s.

I would like to export a Jasper report containing multiple Text Fields grouped under a FRAME element to Microsoft Word (.docx) format. Since MS Word version 2409, I have encountered a formatting issue with tables (FRAME elements). The column widths are noticeably shifted to the left, making the report difficult to read and edit, even though the alignment of headers and values is correctly configured (as confirmed by the PDF output, which displays the columns properly alligned). I have tested this issue across multiple JasperSoft Studio versions, but it persists in all of them. Attached are the "problematic" section of the .jrxml file and the generated outputs in both PDF and Word formats (with anonymized data for privacy). I would like to know: If this is a known issue or bug When a fix might be available If there are any "workaround" solutions to resolve the issue Thank you in advance for your assistance. JRXML.txt PDF table.pdf WORD table.docx