Calc AdvancedFilter+RegEx: two bugs in one

Creating a macro - Writing a Script - Using the API

Calc AdvancedFilter+RegEx: two bugs in one

Postby eeigor » Sat Feb 06, 2021 1:58 pm

@Villeroy, @Lupp, and other participants, I suggest you investigate this issue thoroughly. To do this, I prepared a small example and described everything.
Questions:
1) The DatabaseRange.Filter method does not work, if you do not take some actions.
2) There is an error that occurs when copying the FilterFields() structure.

See the example attached.
Thank you in advance.

Can't attach the file. A little bit later... Done
Attachments
AdvancedFilter-test (compressed).ods
(96.24 KiB) Downloaded 34 times
Ubuntu 18.04 LTS • LibreOffice 7.1.1.2 Community
eeigor
 
Posts: 126
Joined: Sun Apr 12, 2020 10:56 pm

Re: Calc AdvancedFilter+RegEx: two bugs in one

Postby Villeroy » Sat Feb 06, 2021 7:39 pm

If you think that LO made a mistake, then you should post a bug report. Obviously they broke something that used to work in old versions. So it may be even flagged as a regression. No matter how much macro code you throw at a spreadsheet, you will never get a spreadsheet that works as smoothly as the worst database (which is Base without doubt).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29546
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests