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)
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: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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