Hello everybody!
First of all, I would like to thank very warmly everyone involved with this great project.
LibreOffice is amazing.
We are trying to setup a mail merge in my institution, based on LibreOffice, of course. And I would
like to suggest 2 improvements:
1) Put more filter criterias in the Standard Filter window. We use 3 for a basic search. Yes, our
database is complex. Doubling it to 6 would be good, using an dynamically extensible list of
criterias (similar of what iTunes provide when creating a new smart playlist) would be great! Is
there a simple hack to do it or do I need to fill a bug/feature report?
2) Also in the Standard Filter window, we got a logical problem. We wanted to filter criterias A
AND (B OR C) but there is no way to do it. If you try to put 3 criterias 1 AND 2 OR 3 you will
obtain the logic (1 AND 2) OR 3. Tried also the inverse without better luck: 1 OR 2 AND 3 is also
resolved as 1 OR (2 AND 3).
As our or is on looking text in the same field, I also tried to put in a single criteria as "text"
like 'this|that' but the Standard filter doesn't seem to use the | operator.
Any help on how I could do this logic?
I'm new here, please advice me if this kind of problem is better in a feature request than in the
mailing list.
For the moment, the only workaround I see to my problem is making new views in my database
anticipating the filters. I would like to avoid it and use Libreoffice to filter on the fly, as the
number of cases we face is potentially big/not previsible.
Thanks for reading all of this, any help is welcome!
Best regards,
Vitorio Delage
01 42 34 57 89
Académie nationale de médecine
Gestion du parc informatique
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- [libreoffice-users] Mail Merge -> Standard Filter issues · Vitorio Delage
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.