https://bugs.documentfoundation.org/show_bug.cgi?id=118772
Bug ID: 118772
Summary: FILTERXML function doesn't work with some XML
Responses from mojikiban API
Product: LibreOffice
Version: 6.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ya...@mknada.sakura.ne.jp
Description:
FILTERXML function can't get a value from some XML Responses(ex. XML Responses
from mojikiban API).
Steps to Reproduce:
1. Paste '=WEBSERVICE("https://mojikiban.ipa.go.jp/mji/MJ010057.xml";)' to cell
A1 and press Enter
2. Paste '=FILTERXML(A1,"//MJ文字情報一覧表/MJ文字情報/MJ文字図形名")' to cell A2 and press
Enter
Actual Results:
Cell A2 is "#N/A"
Expected Results:
Cell A2 is "MJ010057"
That works well on Excel 2016.
Reproducible: Always
User Profile Reset: No
Additional Info:
LibreOffice version
バージョン: 6.2.0.0.alpha0+ (x64)
Build ID: 4b7ce45c2384fdd65c17ab18036899cd76577254
CPU threads: 8; OS:Windows 10.0; UI render: default;
ロケール: ja-JP (ja_JP); Calc: group threaded
バージョン: 6.0.4.5
Build ID: 6840e4519a6ce8bcc1328eb2d87b5c46c6df1038
CPU threads: 4; OS:Mac OS X 10.13.5; UI render: default;
ロケール: ja-JP (ja_JP.UTF-8); Calc: group
The information about mojikiban API(MJ文字図形取得API / MJ文字情報取得API) is follows.
https://mojikiban.ipa.go.jp/search/help/api
--
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
