AutoFilter not functioning

Jun 23, 2011 at 11:01 PM
Edited Jun 23, 2011 at 11:12 PM

While using NPOI (1.2.4) to populate an Excel template (Excel 2003)
and the SetAutoFilter() function for turning on Excel's AutoFilter feature, 
http://poi.apache.org/apidocs/org/apache/poi/hssf/util/CellRangeAddress.html 

 

                    Dim myTemplateRange As New CellRangeAddress(0, 220, 0, 10)
                    mySheet.SetAutoFilter(myTemplateRange)

 

 I'm coming across a problem where yes, NPOI is generating
the AutoFilter controls (the little grey boxes with a black triangle pointing downwards),
but when I click on any of the AutoFilter controls, nothing happens: no list appears. 

Even stranger, while NPOI clearly has turned "ON" Excel's Data > Filter > AutoFilter feature,
NPOI actually generated DropDown controls, because when I click on Excel's "Select Multiple Objects"
feature, it shows:
    Drop Down 1
    Drop Down 2
    Drop Down 3
    etc...
    Drop Down 11

Excel's normal AutoFilter feature does not create DropDown objects selectable
through the Drawing Toolbar's "Select Multiple Objects" feature.

Thoughts?