[Libreoffice-bugs] [Bug 118772] FILTERXML function doesn't work with some XML Responses from mojikiban API
https://bugs.documentfoundation.org/show_bug.cgi?id=118772 Tomofumi Yagi changed: What|Removed |Added Whiteboard||interoperability --- Comment #3 from Tomofumi Yagi --- (In reply to himajin10 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 himajin10, 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118772] FILTERXML function doesn't work with some XML Responses from mojikiban API
https://bugs.documentfoundation.org/show_bug.cgi?id=118772 --- Comment #2 from himajin100...@gmail.com --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118772] FILTERXML function doesn't work with some XML Responses from mojikiban API
https://bugs.documentfoundation.org/show_bug.cgi?id=118772 --- Comment #1 from Tomofumi Yagi --- Created attachment 143560 --> https://bugs.documentfoundation.org/attachment.cgi?id=143560=edit Sample ods -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs