Re: [libreoffice-users] Question on getting a list of all the macro commands

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: 
https://www.pitonyak.org/oo.php.
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:
https://extensions.libreoffice.org/?Tags%5B%5D=173


HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy