User Manual/Tutorial for LibreOffice Basic Macros

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
   Runtime Library
   Introduction to the API
   Working with Documents
   Text Documents
   Spreadsheet Documents
   Drawings and Presentations
   Charts (Diagrams)
   Databases
   Dialogs
   Forms

References:

Apache OpenOffice BASIC Programming Guide
https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide

First Steps with OpenOffice.org Basic
https://tinyurl.com/y2qf99mt

Posted in LibreOffice | Tagged , , | Leave a comment

Identifying the OS (Linux or Windows) in a LibreOffice Basic Macro

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?
Continue reading

Posted in LibreOffice | Tagged , , | Leave a comment

Save the Current Workbook using a LibreOffice Calc Macro

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.
Continue reading

Posted in LibreOffice | Tagged , , | Leave a comment

Testing Development Versions of LibreOffice

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”.
Continue reading

Posted in Applications, Commands, LibreOffice | Tagged , , | Leave a comment

Changing Icons in Android Pie

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.
Continue reading

Posted in Android, Moto G3, Tweaks | Tagged , | Leave a comment

Waking up the Moto G3 under Android Pie

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.
Continue reading

Posted in Android, Applications, Moto G3 | Tagged , | Leave a comment

Upgrading to Android Pie on the Moto G3

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.
Continue reading

Posted in Android, Moto G3 | Tagged , , | Leave a comment

Modifying the Netflix key on an Nvidia Shield TV remote control

I recently switched to an ISP that provides TV through an on-line connection to an Android TV device. I chose Nvidia’s Shield TV for this purpose. The system has a nice remote control with a dedicated (large) button to access Netflix. The problem is that the button is very sensitive. It’s really easy to brush against the button and load Netflix inadvertently. Fortunately, there is a relatively easy fix.
Continue reading

Posted in Android, Applications | Tagged , , , , | Leave a comment

Updating the GRUB2 boot menu

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!]
Continue reading

Posted in Applications, Commands, GRUB, Mint | Tagged | Leave a comment

Verifying a Linux Mint ISO file with a GUI

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).
Continue reading

Posted in Applications, Mint | Tagged , | Leave a comment