@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
Calc AdvancedFilter+RegEx: two bugs in one
Calc AdvancedFilter+RegEx: two bugs in one
- Attachments
-
- AdvancedFilter-test (compressed).ods
- (96.24 KiB) Downloaded 158 times
Ubuntu 18.04 LTS • LibreOffice 7.5.3.2 Community
Re: Calc AdvancedFilter+RegEx: two bugs in one
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice