5/27/2023 0 Comments Libre calculator![]() OSimpleFileAccess = createUnoService( ".SimpleFileAccess" ) 'this is the Sefvice in getting the data from the web URL = URL & sSearch 'create the searchstring URL = "" 'we will use the google maps api If Len(sSearch) = 0 Then Exit Function 'we dont need empty cells -) Use the basic module for our two functionsĭelete now everything in the editor and paste the following code:įunction GetGeoData(sSearch as String) as String Now we will create a so called Macro or lets name it a user defined function: But lets get our hands dirty: open up Calc and type in one cell your address. Just to clear things up: I am using the little outdated Open Office 4.0.3 for Mac. If you are really into open stuff we show OSM geocoding as well. ![]() We will do this using the googlemaps API. ![]() ![]() Now let’s move a little bit away from this crazy web 2.0 stuff and get a little bit more desktop orientated: Let us geocode addresses directly in LibreOffice (and OpenOffice probably as well). In a recent post I’ve described a way to geocode in a Google Spreadsheet quite easily. ![]()
0 Comments
Leave a Reply. |