Cannot retrieve TravelDistance using filterxml

Hi all.

All I require is the “TravelDistance” from a cell.
I just can’t do it.
No matter what I try, I just get #N/A
Can someone enlighten me?

Distance.ods

Somehow removal of

xmlns="http://schemas.microsoft.com/search/local/ws/rest/v1"

“fixes” it. I’d think it’s a bug. Please file it to bug tracker.

For now, you may use this workaround, which just ignores current namespace:

=FILTERXML(C3;"//*[local-name() = 'TravelDistance']")

EDIT: this isn’t a bug, see tdf#118772.

Excellent.
That worked a treat.
thank you