[Libreoffice-bugs] [Bug 118772] FILTERXML function doesn't work with some XML Responses from mojikiban API

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118772

Tomofumi Yagi <yagit at mknada.sakura.ne.jp> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Whiteboard|                            |interoperability

--- Comment #3 from Tomofumi Yagi <yagit at mknada.sakura.ne.jp> ---
(In reply to himajin100000 from comment #2)
> Hi, Mr.Yagi.
> 
> Have you taken the XML's "default namespace" into account?
> 
> https://superuser.com/questions/1048743/how-does-one-use-libreoffice-
> filterxml-function-on-xml-documents-with-namespaces
> 
> IMHO, I don't like Excel's ignorance of default namespace.

Hi himajin100000,
Thanks for your advice.

I have correct the expression(such as the following),then FILTERXML function
worked well on LibreOffice and Excel 2016 both.

=FILTERXML(A1,"//*[name()='MJ文字情報一覧表']/*[name()='MJ文字情報']/*[name()='MJ文字図形名']")

=FILTERXML(A1,"//*[name()='MJ文字図形名' and
namespace-uri()='urn:mojikiban:ipa:go:jp:mji']")

Umm, I think Excel 2016 can accept some fuzzy or incorrect expressions, but
kindly a bit in this case.
After all, FILTERXML function on LibreOffice is right.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180716/5935d309/attachment.html>