Automatically sort strings after calling autofilter method in Apache POI

Perhaps this is a simple question, but I have not found any information about this anywhere. I am creating an Excel file and I have a little problem when creating the file. The problem is that I call the autofilter method to filter all columns, and then I call the autosize method, but it does not seem to take into account the space that the down arrows in the cells fall into.

For example, I have a column with the heading "AA", and when the file is generated, the column is shrunk, so I can only see the down arrow, not the header text. Unfortunately, the column values ​​are not long enough to make the column longer when the autosize method is called ...

So, does anyone have a solution for this?

Thanks in advance!

+1
source share

Source: https://habr.com/ru/post/1490729/


All Articles