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+unsubscr...@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