LibreOffice Calc V6.0.4.2 on Win 10.
If I save the example xml content “books.xml” from this page to a local file I do not succeed with any formula I try using FILTERXML()
.
=FILTERXML("file:///C:/Users/MyID/folderpath/books.xml";"//book/year")
or something using Xpath strings like /bookstore/book[1]/year
only returns the #VALUE!
error whether entered for array-evaluation or otherwise.
What’s wrong with my formulae?