>This is the mailing list of the developers (not macro coders).
>Register on the support forum:
> https://forum.openoffice.org/en/forum/ucp.php?mode=register
Andreas you're right, I am sorry about that.
>Filter criteria are limited to 8 criteria.
Is it capability for Autofilter?
> No macros can not access the auto-filter list.
I am not happy for that. Thanks for information.
Andrew, thanks for your respons.
Regards,
Wlada
2014-10-25 6:26 GMT+02:00 Andrew Douglas Pitonyak <and...@pitonyak.org>:
> On 10/24/2014 07:06 PM, Vladislav Stevanovic wrote:
>
>> Hello,
>>
>> Is it possible with code in Basic to access to the list of Autofilter data
>> in Calc? Reason: filtering with basic is limited maximum with 3
>> criteria...
>> Because I need more then 3 criteria I want with basic code to use
>> filtering capability of Autofilter.
>>
>> Thanks in advance,
>> Wlada
>>
>> First, Andreas is correct, you should post these types of questions to
> the forum not the Dev list.
>
> Second, I wrote a document called "Calc As A Simple Database" that is now
> part of the official LibreOffice documentation that has a macro called
> AddNewDatabaseRange that sets a range to use an autofilter.
>
> If you look at OOME, available from my web site, I also demonstrate how to
> create and use regular filters using macros. I expect that this is also in
> the aforementioned document.
>
> Sub AddNewDatabaseRange()
> Dim oRange 'DatabaseRange object.
> Dim oAddr 'Cell address range for the database range.
> Dim oSheet 'First sheet, which will contain the range.
> Dim oDoc 'Reference ThisComponent with a shorter name.
>
> oDoc = ThisComponent
> If NOT oDoc.DatabaseRanges.hasByName("MyName") Then
> oSheet = ThisComponent.getSheets().getByIndex(0)
> oRange = oSheet.getCellRangeByName("A1:F10")
> oAddr = oRange.getRangeAddress()
> oDoc.DatabaseRanges.addNewByName("MyName", oAddr)
> End If
> oRange = oDoc.DatabaseRanges.getByName("MyName")
> oRange.AutoFilter = True
> End Sub
>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info: http://www.pitonyak.org/oo.php
>
>
