autofilter database range filter Tom Schindl How can I add an auto-filter using the api Dim rangeAddress As new com.sun.star.table.CellRangeAddress rangeAddress.Sheet = 1 rangeAddress.StartColumn = 0 rangeAddress.StartRow = 0 rangeAddress.EndColumn = 4 rangeAddress.EndRow = 5 Dim CalcDoc As Object CalcDoc = ThisComponent CalcDoc.DatabaseRanges.addNewByName( "myRange", rangeAddress ) CalcDoc.DatabaseRanges.getByIndex(0).AutoFilter=true Initial version