[Bug]: Microsoft Excel Writer action: Auto Size Columns function is not working

[mmoz77]

Apache Hop version?

2.9.0

Java version?

11

Operating system

Windows

What happened?

Using Microsoft Excel Writer action, I have noticed that the Auto Size Columns function is not working.
I've checked the option Auto Size Columns in the Content tab (first image), but the excel output doesn't autosize columns (second one).
The same job in Pentaho produces an autosized excel sheet.

Issue Priority

Priority: 3

Issue Component

Component: Actions, Component: Transforms

[nadment]

We can try to upgrade Apache POI 5.2.4 to 5.3.0 because of the bug below:
https://bz.apache.org/bugzilla/show_bug.cgi?id=68094

[hansva]

.take-issue

[hansva]

I cannot reproduce the issue, might be because I am not on Windows.
After reading apache/poi#541 the update should fix the widths in most cases but there are still some edge cases.