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, 


                    Dim myTemplateRange As New CellRangeAddress(0, 220, 0, 10)


 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
    Drop Down 11

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