HansMaulwurf
Newbie
Joined: 24 Apr 2012
Posts: 1
|
 Posted: Tue Apr 24, 2012 1:10 am Post subject: Calc: Macro and AutoFilter (again) |
 |
|
Hallo 
for a few days now, I try to set the AutoFilter by my macro. I want it exactly the way, OOo does it, if you choose it manual.
| Code: | oRange = oWorkingSheet.getCellRangeByPosition(0, 0, iiSpalten, iiZeilen).getRangeAddress()
oVorlage.DatabaseRanges.addNewByName( "myRange", oRange )
oVorlage.DatabaseRanges.getByName("myRange").AutoFilter=true
oVorlage.DatabaseRanges.removeByName("myRange")
|
It sets AutoFilter correctly, but the dropdown-menus in the first rows are empty (ok, there are the standard-entries). I don't know what to do with FilterDescriptor or anything else, to fill these dropdown-menus. Someone can help me?
thanks
Hans |
|
