LibreOffice is a free suite of apps for creating text documents, spreadsheets, presentations, and more, which you can then save in Microsoft Office formats. Thank you for using the LibreOffice application help. Press F1 whenever you need help using the LibreOffice software, and you will be redirected to this site.
How to do a "great circle" calculation in MS Excel or Libre. Office? The Haversine method is good as long as you're willing to accept an error factor, or if you must implement with a worksheet formula only. For short distances and non critical situations it will probably be ok. But if you need precision, you need to use something like the algorithm developed by Thaddeus Vincenty. It's results are considered accurate down to millimeters based on the accuracy of the lat/long pairs used. How much difference between the two? Between JFK and Tokyo it's a difference of about 1.
Home of site. Macroの杜 (OpenOffice.org/LibreOffice Basic編) Calc No.1 *****【 Index 】***** Cell操作 [ General ]. One of the very useful features of spreadsheets is the capability to create charts and graphs of the data. After all, it is said that a picture is worth a thousand. As found here by BrianAdkins, this Excel formula to calculate distance between two latitude/longitude points works for me both in LibreOffice Calc and Microsoft Excel.
Between Los Angeles and Honolulu, you'll only be about 3 miles short of the island. A good implementation of the Vincenty algorithm in Visual Basic (as for Excel) can be found at. The code will run 'as- is' on 3. Excel, but will fail with a 'formula too complex' error in the 6. Excel. Just below the posting of the entire code I have posted a fix to that problem that enables it to run on both 3.
VBA engine. Regards. J. Latham, Microsoft MVP, Excel 2.