In an earlier post (Save the Current Workbook using a LibreOffice Calc Macro), I bemoaned the fact that I couldn’t seem to locate a really useful user manual or tutorial for macro programming using LibreOffice Basic. In particular, I noted that the keywords I was using for a Google search were not productive. Both aspects of this issue were resolved when I recalled that LibreOffice is actually a fork of OpenOffice. The trick is to search on Google for something like: OpenOffice basic macro user manual.
One of the hits this search string identifies is to the Apache OpenOffice BASIC Programming Guide. This web-based guide is quite comprehensive and offers chapters on:
The Language of Apache OpenOffice Basic
Introduction to the API
Working with Documents
Drawings and Presentations
Apache OpenOffice BASIC Programming Guide
First Steps with OpenOffice.org Basic
In the last post I described how to save the open Calc workbook from a macro. One of the parameters used was file:///media/DataDisk/agl.ods which clearly indicates that Calc was being run under Linux. But, those of us with dual-boot systems can also run LibreOffice Calc under Windows in which case we would want to save the file as something like D:/agl.ods. It would be useful if we could use the same Calc workbook, and the same macro, with both operating systems. So, how are we going to code the macro to use the correct disk folder designation?
I often find it difficult to track down how to develop macro code in LibreOffice Basic to do what I consider to be routine tasks. Perhaps I haven’t found the requisite beginner’s guide, or don’t use the right search strings in Google. For Microsoft’s Excel, the latter technique using “VBA” usually does the trick; however, including “LibreOffice”, “Basic” and “macro” doesn’t necessarily find the answer for Calc.
If you are not a computer programmer, graphics designer, technical writer, or a web developer, one way to assist in the development of open-source software, such as the LibreOffice suite, is to test pre-release versions of the software as these are developed. If any bugs are identified these can be reported to the development team so that they can be fixed in future builds. A really neat feature of LibreOffice is that a development version can be installed in parallel with a stable release that is being used as a “daily driver”.
Most of the icons used in Android Pie look fine, but I really don’t like the default icon for the Calendar app. Previously, with Android Nougat, I had used the Icon Changer free app developed by Juyeong to switch the default icon to a different image. However, a note in this app’s description indicates that it does not support Android Oreo (Version 8.0) and, presumably, this also applies to later versions such as Android Pie (Version 9.0). The good news is that many web postings recommend Awesome Icons from Momo apps for the same task.
As noted in the previous post, with Android Pie installed, waking up the phone seems to require (in my case) opening the wallet-style cover, double-tapping on the screen, and swiping up the screen to unlock it. This is a lot more steps that I have been used to since, previously, I could just open the cover and swipe up the screen. Fortunately, the WaveUp app solves my problem.
For the past several months I have been using a custom ROM of Android Nougat on my Moto G3 smartphone (See: A Stable Custom ROM for the Moto G3) that has been receiving monthly, over-the-air (OTA), security updates. Now, MSe1969, the ROM’s developer from Frankfurt, Germany, has announced the availability of an Android Pie version of his software and has noted that this will become a replacement for the Nougat variant.
Some time ago, I indicated how to manually update the grub boot menu (see: GRUB2 revisited). This required quite a lot of effort to change file permissions and edit several text files. A much simpler method, that uses a graphical user interface, is to use the Grub Customizer application developed by Daniel Richter [Thanks Daniel!]
Some time ago, I downloaded and authenticated the ISO file for Linux Mint Version 18 (see: Verifying the Linux Mint 18 ISO file), using a mostly manual method, through a series of Linux commands. A much easier method is to use the GtkHash app which provides a graphical user interface (GUI).