Hope someone can advise please. Using Libreoffice Calc 6.4.7.2 on Ubuntu 20.04.3. I have created a couple of macros by recording. If I go to organise macros, select a macro and click run, they will both run perfectly, no issues. However, if I select Tools>Macros>Run Macro and select either macro then neither will produce a result. So I could run the macro I want from the organiser, but I want to assign the macros to buttons, which I have done but again no result, as I guess that is the same as the run macro command. Highly likely I have done something wrong (it may be an age thing 
) but any advice on how to get past this would be much appreciated. Thanks in advance, Pete.
ever considered upgrading ?
likely a problem of context,
similar to Problem with running a macro in LibreOffice calc - #2 by fpy
As far as I can see 6.4.7.2 is the latest stable version for Ubuntu 20.04.3. The only later one I can see is 24.2.4, but that is stated as being for technology enthusiasts, early adopters or power users, so a bit reluctant to go for that yet - is it easy enough to downgrade if necessary?
What I have done is assigned a keyboard shortcut to the macro, and that worked, and then I assigned that shortcut to the menu bar, and that works. I can’t find a way to assign the shortcut to the button I created, but that’s OK, I can just use the menu item. Puzzled as to why it doesn’t appear to work the way it should, but I can live with this method.
Thanks for your help, Pete.
3 ways to install LibreOffice on Ubuntu:
-
The debian packages from the Ubuntu repository is the one you have. Although being old, it should work pretty well while getting security updates from Ubuntu developers. In case of problems like this one, not reproducible by anybody else, you should contact the Ubuntu community. With this particular problem, I would try to install Ubuntu’s Java Runtime Environment (JRE) from the same repository. I remember that the “Run Macro” dialog used to be dependent on JRE. This is no longer the case with recent versions.
-
Flatpak packages from Ubuntu. They fulfill a common desire for the latest versions right from the Linux distributor, and building containers like Flatpak is very convenient from the maintainer’s viewpoint. These packages come with poor system integration. Easy to install, but very soon you hit the container walls.
-
Debian packages downloaded from the project website Download LibreOffice | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with Microsoft offering the latest two versions 7.6 (old versioning scheme) and 24.2 (new year.month versioning scheme). Both versions are very similar to each other. IMHO, 24.2.4 is mature enough to be installed anywhere. It is the 4th maintenance release of the version that was released in February 2024.
How to install the debian packages from libreoffice.org: Download a tar.gz archive (something like a zip file) to your downloads folder and extract the archive.
Then open the extracted folder, right-click subfolder “DEB” and choose “Open in terminal”.
In the terminal, you entersudo dpkg -i *.deband everything should install smoothly.
1 Like
Thank you! Installing JRE solved the issue. Thanks for your help.