Summary: | XMLpath in FIlterxml does not work with arrayfunction | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Oyvind <oyvfos> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | mariosv, oyvfos |
Version: | 4.3.4.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: |
example usage FILTERXML workbook excel
Sample file |
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. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
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