Created attachment 59117 [details] 4 files - odt, odb(datasource), txt(used to create odb),jpg(print screen) When printing a odt with a mailmerge field the it was showing more items to print than it should have. The datasource had 371 item but mailmerge was showing 401. When I scrolled down the list at about item 40 I noticed some entries from the beginning of the list had been duplicated. See print screen that shows the datasource having 371 but the mailmerge is showing 401 for the same table. If you try and print you get the 401 items. I found that if you click on another table than back to original mailmerge then shows the 371 correctly. Also if you do any sorting or filtering it seems to remove the duplicates. I have attached a sample odt, odb, txt, and jpg.
Hi Rn, thanks for the report. Some things I notice: the number of 401 indeed shows up in the old mail merge dialoge (File > Print <question ...> Yes ) It does not show when I choose Tools > Mail merge and then jump to step 8. ( The second method also is about 15 to 20 times faster by the way ;-) ) Nevertheles: indeed there are to much records shown. Was OK in 3.4.6. Could you pls try to find out which rows are bupleicated, what exactly happens? Maybe there are some line feeds instead of returns, or special characters that make the listing go wrong? thanks
I see the problem also in 3.5.0-beta1
(In reply to comment #1) > Hi Rn, > > thanks for the report. > Some things I notice: > > the number of 401 indeed shows up in the old mail merge dialoge (File > Print > <question ...> Yes ) > It does not show when I choose Tools > Mail merge and then jump to step 8. > > ( The second method also is about 15 to 20 times faster by the way ;-) ) > > Nevertheles: indeed there are to much records shown. Was OK in 3.4.6. > > Could you pls try to find out which rows are bupleicated, what exactly happens? > Maybe there are some line feeds instead of returns, or special characters that > make the listing go wrong? > thanks Records 12 to 41 are repeated in records 42 to 71
This bug still exists in 3.6.1.2
I am experiencing (and have been) this same problem in version 3.6.6.2 on Fedora 18 x86_64. Is there any progress on this?
@lionel: looking at the numbers at the bottom of comment #3 ... makes that ring a bell with you? thanks!
Cannot test/debug in my master build because of bug 64283
Most probably a bug in the driver for flat text file. Should not happen with any other database driver. The mail merge code opens two connections to the table (.txt file), and the two stomp over each other.
thanks for your comment Lionel. It's not Windows only, by the way
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6b946f228397c370e09f487c470bafd9d046eee5 fdo#47951 flat text table: update m_nRowPos when moving by bookmark The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8f3147df3c309127382f800f9a2b19f355bd9d15&h=libreoffice-3-6 fdo#47951 flat text table: update m_nRowPos when moving by bookmark It will be available in LibreOffice 3.6.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=08a9b322ae0069d563730cfd7d61f2dfa0af3a26&h=libreoffice-3-6 fdo#47951 work around underlying cause It will be available in LibreOffice 3.6.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fd3e9a136da6f119e6f722ac409ff32bd52c8ea0&h=libreoffice-4-0 fdo#47951 flat text table: update m_nRowPos when moving by bookmark It will be available in LibreOffice 4.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=500aa2b680c036f0d171b274423ab8a832459572&h=libreoffice-4-0 fdo#47951 work around underlying cause It will be available in LibreOffice 4.0.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I downloaded and tested libreoffice-4-0~2013-05-24_06.51.45_LibO-Dev_4.0.4.0_Win_x86.msi and can confirm the bug has been fixed for the test files on win xp. Thanks for the fix Lionel Ron Gregor