Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

Hello Mike,

Le 29/11/2020 à 18:33, Michael D. Setzer II a écrit :
Does a file with them exist in full or part.

nope. Well, not that I know of. The LibO API (application programming interface) is a quite complex beast.

Was recently looking thru menus and found something interesting that I
had not noticed before.
Data / Calculate / Formula to Value

I did a test, and it did what I wanted, so recorded the macro.

The LibreOffice macro recorder is a *very* limited tool, which has nothing to see with some other Office suite recorder. The LibO recorder just records your actions in the GUI (keyboard and mouse actions) and translates them using a special object, the Dispatcher.

The resulting code has very little to see with actual macro code you might write to accomplish the very same actions in "purer" Basic.

This doesn't mean the recorder is useless. I use it everytime I need a quickly automated process. But don't rely on it to manage (not so) complex processes.

If you want to delve in Basic macro coding, as an English-speaking user you should read Andrew Pitonyak's books. Check Andrew's website here: His macro document is a collection of predefined macros, while his book is more elaborated. Both are highly recommended reads!

For a quick start, you might also find the 9 reference sheets available from the LibO extension pages handy:

Jean-Francois Nifenecker, Bordeaux

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.