Using the standard filter when doing a mail merge does not appear to affect the output of the merge at all. I've tried multiple databases and files with this. To reproduce: 1. Add fields from a data source. 2. Add a filter. (Note: the filter will work in the data browser/viewer, giving the impression that it will work in the merge.) 3. Complete the merge (to a document or printer, it doesn't appear to matter.) All the records seem to be in place, without respecting the filter that has been applied.
There was a similar issue with setting filters via the wizard, it might be related, and if it is, a fix has already been entered. See here : https://bugs.freedesktop.org/show_bug.cgi?id=50800 Alex
@ jfacemyer: Thank you very much for your bug report! Could you please check yourself if this problem has been fixed, just as Alex Thurgood suggested? The fix mentioned by Alex Thurgood (for bug 50800) should be both in LibreOffice >= 3.5.6 and in LibreOffice >=3.6.0, so you can try this with any of the current versions (3.5.7 or 3.6.2). And after checking this, please report your results by adding an additional comment to this page. This would be very helpful. Thank you very much! (@ Alex: Thank you very much for the hint about bug 50800!)
I've just installed 3.6.3.2. Going through the mail merge wizard exhibits exactly the behaviour that the OP describes. Using File > Print and choosing the option to print to a file, the filter appears to work correctly.
There are detailed steps to reproduce: 1. Open new text document 2. From menu: View → Data sources 3. In upper part of window, select "biblio" table 4. Set standard filter to Author = 'Gris, Myriam' 4a. Five rows will remain, identifiers GRM00 to GRM04 5. From menu: Insert → Fields → Other... 6. In Database tab, select Mail Merge fields on left, Bibliography → biblio → Identifier on right; Insert. Close this window. 7. From menu: Tools → Mail Merge Wizard... 8. Go directly to step 6 ("Edit document"). Result: Identifier field on document will change to "ARJ00", which is NOT visible in Data Sources table. You can cycle through all 20 default biblio table entries. Expected result: mail merge wizard should take filter into consideration and work only on rows matching filter settings (that are shown in Data Sources table). Yes, I know, expected behavior is arguable (should filter just help finding matching data or actually change a range on which mail merge works?). But this is what original reporter expects. I also got personal message from other user who also finds current behavior broken. This is in no way related with 50800 mentioned earlier. That one is about Base queries, this one is about Mail Merge in Writer. I could reproduce it on 3.6.5, Debian testing amd64; therefore I mark this as NEW and change OS setting. I also lower importance to comply with <https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg>.
Caolan : you're our mm expert I seem to recall - any ideas ?
Step ^ of the wizard is currently lacking a UI dialog, so testing on master somewhat difficult. The workaround, and the way I have always done this : 1) Set the filter in the data source broswer window. 2) Select the upper left corner of the data source browser and drag and drop this onto the empty Writer document 3) The other mailmerge wizard will start and only copy over the filtered data - the user gets to decide which fields to insert
Adding self to CC if not already on
I can confirm this bug is still active. I use Lubuntu 14.10 with LO 4.3.5.2 Build ID: 430m0(Build:2) Like Joshua said, I can also filter correctly when using File / Printer, but using the Wizard it always shows the first records. When I filter in Base, then filtering works as expected. Recap, Having 6 records, filtering the 4th, 5th and 6th in writer: File / Printer (to file) gives me record 4, 5 and 6. Wizard gives me record 1, 2 and 3. Filtering in Base, wizard gives me record 4, 5 and 6. (But this would take an extra step, which is not very user friendly.)
Hello, I encounter the same probleme today and I read in an old documentation (French documentation for mail merge OpenOffice document 14.10.2007 http://www.openoffice.org/fr/Documentation/Guides/GuidePublipostage.odt page 25 and 27) that this bug affect "mail merge wizard" and not "mail merge". 1-If I use a query to change my selection and if I click next after have edit my document (Mail merge wizard 7- Personnalise document), the preview, print and save merge document (Mail merge wizard 8-Save, Print or sent) are wrong. 2 If I use a table and a filter to do the same, the preview, print and save merge document are wrong. Workaround since 14.10.2007, use "mail merge" instead off "mail merge wizard" and query or filter work normally. Hope it's help you to resolved this (old) bug Regads Nicolas
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.5 or 5.2.1 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920
I can confirm that this behavior is still present in LibreOffice 5.2.3, it does not respect the filter when merging. PS: Miroslaw suggests the expected behavior is arguable. I would personally definitely expect the filter to change the range on which mail merge works. I think this is more intuitive than queries and prevents inexperienced users having to write Base-queries. Else the only use for the filter is to find matching data, and I can only imagine that being useful in rare cases where you have to check/preview the merge for a specific case.
Bug always present in 5.2.6 / Win 8.1 Pro 64 The buttons in the new Mail Merge toolbar ("Edit Invidual Documents", "Save Merged Documents" etc...) don't take in account any filter or even sort order done through the "Data Sources" window ( Ctrl-Shift-F4). It's really annoying and disturbing for end users because filter / sort in Data Sources window is easy and safe ( easier and safer than modifying a query in the database).
This bug is about standard data sources filter. Looks like there's a workaround: use filter in Select address list, step 3. of Mail Merge Wizard.
(In reply to Timur from comment #13) > This bug is about standard data sources filter. Looks like there's a > workaround: use filter in Select address list, step 3. of Mail Merge Wizard. Yes, but it's a workaround only for filter, no workaround for sorting. It will be really fine if the buttons in the Mail Merge toolbar could use filter / sort options of DataSources toolbar ... and less unsettling
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Hello, dont't know if this is the right way. So, for me the bug is still open. Version 6.1.5.2, 6.4.4.2, 7.0RC1 And Mail Merge doesn't even accept the result of a query inside the database nor the filter set inside the data explorer. Sorry, if this should be the wrong way. michael
This bug is still open for me on 7.0.3.1 Win10 I found out that the filter will be carried on to the print windows, if I filtered the _table_ in the data source window. If I, however, select a query in the data source window it does not carry on to the printing window (after approving mail merge). May be that helps to narrow it down a bit. The database I am using is a text-based database (link to .ods)
Sorry, for the duplicate but I did not actually fill in the header bit for the post. Not sure, how important it is... This bug is still open for me on 7.0.3.1 Win10 I found out that the filter will be carried on to the print windows, if I filtered the _table_ in the data source window. If I, however, select a query in the data source window it does not carry on to the printing window (after approving mail merge). May be that helps to narrow it down a bit. The database I am using is a text-based database (link to .ods
Hi, I confirm that this issue stil affects LibreOffice : Version: 7.1.3.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Ubuntu package version: 1:7.1.3~rc2-0ubuntu0.20.04.1~lo1 Calc: threaded This fonctionnality was very useful and now, the mailing is an important weakness of LibO for a professionnal use. Regards, Thierry
Dear Joshua, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug