Apache OpenOffice (AOO) Bugzilla – Issue 114658
query displays first row's data multiple times
Last modified: 2010-10-05 08:25:53 UTC
I open a spreadsheet. I choose F4 and a query there. After input the necessary parameters I get only the value of the first row as often as the query result has rows Each row contains the same values. This is a regression against 3.2.1. the function F4 is unusable. so I nominate it as a stopper
sound like a duplicate of issue 114026 to me, which in turn is a duplicate of issue 113631, which was fixed in fs33a, which was integrated into m7 ... which unfortunately means some of those "duplicate" claims is wrong, as you encounter the issue in m7. Mind to attach a sample doc? I doubt it happens with each and every query ...
assuming that your query selects from tables with aliases, this one is a duplicate of issue 114026. Sadly, issue 114026 is not fixed in m7, which means it indeed is not a duplicate of issue 113631. I thus re-opened issue 114026, and will look into it, as long as oj is not available. *** This issue has been marked as a duplicate of 114026 ***
Closing.