Results 1 to 2 of 2
  1. #1
    RahX is offline Member
    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0

    Default AutoFilter width

    Hello,

    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.


    Danny

  2. #2
    RahX is offline Member
    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0

Similar Threads

  1. Multiple criteria autofilter, one column
    By cbake in forum New To Java
    Replies: 2
    Last Post: 02-01-2012, 10:31 PM
  2. array.width?
    By noobgrammer in forum New To Java
    Replies: 2
    Last Post: 07-01-2010, 03:35 AM
  3. Width (-1) and height (-1) cannot be <= 0
    By LovJava in forum AWT / Swing
    Replies: 5
    Last Post: 04-24-2010, 01:16 AM
  4. How to set the AutoFilter to Excel Sheet with Wither POI or JXL
    By lnarayana_boga in forum Advanced Java
    Replies: 0
    Last Post: 01-29-2008, 10:05 AM
  5. Autofilter and POI-HSSF
    By nefarius in forum JDBC
    Replies: 0
    Last Post: 09-23-2007, 04:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •