search

gramener / geocode-excel

Convert addresses to lat-longs (and vice versa) in Excel
49 stars 23 forks source link

Error Nominatim Reverse Geocoding #8

Open killian-santos opened 2 years ago

killian-santos commented 2 years ago

Hi,

First of all, thank you for your work!

I am currently testing the reverse geocoding feature with Nominatim.

I have a cell with latitude, another with longitude and using the formula =NominatimReverseGeocode(lat, lng), I get an error when I have complex GPS coordinates like for example: 38.8950368,-77.0365427. test reverse nomi

It only works with values without decimals.

Am I missing something?

Killian

BaptisteVerneuil commented 4 months ago

I would suggest replacing :

Function NominatimReverseGeocode(lat As Double, lng As Double) As String

by : 

Function NominatimReverseGeocode(lat As String, lng As String) As String