https://bugs.documentfoundation.org/show_bug.cgi?id=167117

--- Comment #6 from Buovjaga <[email protected]> ---
In the Ask forums we find other ways to define the filter:

https://ask.libreoffice.org/t/macro-to-manipulate-an-autofilter-without-a-database-range/57846/8

Sub main()
        sel = ThisComponent.CurrentController.Selection
        range = get_range(sel)
        fd = range.createFilterDescriptor(True)
        range.filter(fd)
End Sub


Function get_range(cell)
        cursor = cell.SpreadSheet.createCursorByRange(cell)
        cursor.collapseToCurrentRegion()
        get_range = cursor
End Function

https://ask.libreoffice.org/t/macro-automatic-filter-or-standard-filter-in-calc/57808/13

"The only way I know to create an AutoFilter via the API is to create a
DatabaseRange and to set its .Autofilter property to TRUE."

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to