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?
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