Created attachment 112037 [details] example usage FILTERXML workbook excel Hi, FILTERXML in combination with array function returns the same value for all cells. In the example attached, I'd expect "Dlow" and "Sri Lankan presidential election, 2015" for the first two entries as of today (jan 9 , 2015) , but I get "Dlow" and "Dlow". It would be nice to have this fixed:) Thanks, Oyvind
Created attachment 112041 [details] Sample file Hi, thanks for reporting. I'm not sure if the used Xpath expression it's fine to get all records without define what number of record get. In the attached one sample on how get every record. I don't know about Xpath, but I'm curious about, obtaining some information in http://www.w3schools.com/xpath/xpath_examples.asp Not clear for me this is a bug, and if your expression must work in the way you expect. Does it work with Excel?
Thanks for responding so quickly. As for your question about excel, the attached sample works in excel. See https://support.office.com/en-us/article/FILTERXML-function-4df72efc-11ec-4951-86f5-c1374812f5b7?ui=en-US&rs=en-001&ad=US It seems natutal that this should work, as you would like to represent a list of entries from a webservice in a sheet this way. Hope this helps, Oyvind
Seems that the function only returns the first element.
** 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.0.4 or later) 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
Seems it is solved for: Win10x64 Version: 5.1.0.2 (x64) Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; but remains with: Version: 5.0.4.2 (x64) Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Seems solved for: Version: 5.0.5.1 (x64) Build ID: 7609023f63524a6c8326f6c82e7e23f55a5b7bb5
Not solved for 5.1.1.3 (x64) version for windows
Hi @aborruso, are you sure you have set up the formula properly?. The first file in this report doesn't work for me, but changing the formula to: A5: =FILTERXML(A$3;"//rc["&(ROW()-4)&"]/@title") it does. and my second sample file works for me.
Sorry for the mistake. Reviewing issue, it's clear that the function doesn't work properly. It doesn't return an array where there are several values. On the new sample attached {=FILTERXML($A$3;"//book/title")} Workaround it's call every row of data explicitly. {=FILTERXML($A$3;"//book["&(ROW()-6)&"]/title")}
Created attachment 124138 [details] New sample
Created attachment 124487 [details] A new example I can confirm this. In Excel if used in array, the first element in the FILTERXML query gets numerated (will the second one be also numerated for 2D arrays?). I simplified the example slightly. I suppose it replaces all previous ones.
I mark this as new/enhancement request.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7d733e16513a1b9413303d60feb03c5a0de941fc Resolves: tdf#88257 handle FILTERXML array/matrix context It will be available in 5.3.0. 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.
Yay!
Thanks Eike, nice. Verified Win10x64 Version: 5.3.0.0.alpha0+ Build ID: 327f5cc66f122979943d2c896eb1824791a854c9 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2016-08-17_23:39:34 Locale: es-ES (es_ES); Calc: CL Version: 5.3.0.0.alpha0+ (x64) Build ID: 327f5cc66f122979943d2c896eb1824791a854c9 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-08-18_00:02:16 Locale: es-ES (es_ES); Calc: CL Perhaps it could be backported.
Pending review https://gerrit.libreoffice.org/28460 for 5-2
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7f6770fac8787203220cd73246ffc058a1b14d00&h=libreoffice-5-2 Resolves: tdf#88257 handle FILTERXML array/matrix context It will be available in 5.2.2. 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.