I am using the AutoFilter on my sheet to have a filter on columns, so far so good.
But what it does, is that the window you get when opening the filter; it's the width of the column itself. So the options within the filter like 'All', 'Top 10' and 'Custom', these are sometimes not completely visible because the data in the column itself is only like 3 characters for example. It takes this width of 3 characters for the autofilter window as well, so I only see 'Cus' for example when it should show 'Custom'. How do I solve this? I have my columns set to autoSizeColumn but I expect the same thing to happen when I just let the default column width there.
Further to this, if I open my generated sheet, remove the autoFilter POI has generated, and put back the autoFilter through Excel, it's all okay. The width of the filter window is 'normal' (not column width), and what I found is that the cursor has also changed. With the POI generated AutoFilter I get a 'hand' as a mouse symbol, where as the Excel autofilter has an 'arrow' mouse symbol when hovering over the filter.
I saved my sheet in XML with the POI autoFilter and Excel's autoFilter, but I can't really determine what's causing the autoFilter windows to differ.
Any suggestions are most welcome.
Re: AutoFilter width