Calc AdvancedFilter+RegEx: two bugs in one

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
eeigor
Posts: 214
Joined: Sun Apr 12, 2020 10:56 pm

Calc AdvancedFilter+RegEx: two bugs in one

Post by eeigor »

@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 157 times
Ubuntu 18.04 LTS • LibreOffice 7.5.3.2 Community
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc AdvancedFilter+RegEx: two bugs in one

Post by Villeroy »

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
Post Reply