Insert: The items here include ones to insert images, charts, and shapes.
View: The items in this menu include ones that allow you to open each one of the toolbars, open or close the sidebar, open and close the navigator, and access the data sources.It has items to search and replace text in a document. Edit: The menu has items to copy, cut, and paste text and other items.File: This menu contains items to create a new document, save a document, access remote servers, to access templates and wizards, and print a document.Sheet and Data are the menus that are unique to Calc. Each application has different items in the menus they have in common with other applications. Most of these menus can be found in Writer and Impress as well. SThisString = oTextStream.The menu bar has the following items in it. OTextStream.InputStream = oInputStream 'this is the dataĪDelimiters = Array(ASC(">"),ASC("" and ""),ASC("<"),ASC(" "),ASC("=")) OTextStream = createUnoService(".TextInputStream") 'get the data from the web OInputStream = oSimpleFileAccess.openFileRead(URL) 'use the URL 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 kommentar(er)
