Where can I found a full list of LIbreOffice Calc scripts or macros in all script languages (python, js, etc.). Thanks.
As soon as you visit every person on this planet who could ever write their scripts or macros for LibreOffice Calc, and create such a full list, I will create another one, and make your list not full.
1 Like
Oh, my dear friend Mike, of course you undoubtedly have all the reason in what you literally say in your response to this post. I meant, rather, a list of almost all scripts currently available, not even including scripts that will be written in the future. Greetings. I appreciate your comment.
Full list of LIbreOffice Calc scripts or macros in all script languages
There is not separated Library or Modules for CALC macros in your LibreOffice on your computer. Maybe they are stored together with the Writer macros, Draw macros, etc⊠because the LO is an integrated office suite with a common API.
Of course you can list your own macros and the installed Basic macros (extenions and others) in the built-in IDE.
As there is no law to register every âpublishedâ macro you ask for a list wich is impossible to create and (without keywords etc) to big to be used. A lot of macros are also useless (especially outside the environment, where they are created), repetitive, have errors or are outdated.
.
So: Do you search something specific? Or do wish to start creating âthe listâ?
ps: My answers to your question are
- Nowhere
- For a start use google, bing etc. (Should keep you occupied for some time.)
I just asked for a list or guide of the current macros or scripts already included in CALC, with a short description of its purpose. I am referring only to the macros that are already provided, which can be accessed by pressing Alt+F11 or by âChoose Tools - Macros - Organize Macros - Basic, or press Alt+F11â (if not assigned by your system). Thanks to all of you.
You know, @VincenzoNatale , everyone who has already written that a complete list (in the sense of âexhaustiveâ) is impossible to create is right. However, I remember that there was an attempt to collect a decent collection of code, it was made by Andrew Pitonyak. How do you like chapter 6. Calc macros? Yes, there is no Python, no JavaScript, no BeanShell, but thatâs not a problem, is it?
Check help first:
https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03/lib_tools.html
https://help.libreoffice.org/latest/en-US/text/sbasic/shared/03/lib_ScriptForge.html
This list of Functions by Category contains all functions shipped with Calc.
Of course this list is far from what you ask for. But as @mikekaganski I can imagine no way for compiling a list of all scripts in all languages.
Thanks a lot for your response, to all of you.
Use Tools > Macros > Organize Macros. Select e.g. Basic. The part âApplication macrosâ contains those macros, that are shipped together with the installation. Most of them are in Basic. These are stored in the installation directory in folder âshareâ. The Basic macros are in folder âBasisâ, the others are in folder âScriptsâ.
The examples in the SDK are another source . You can download the SDK from the usual download page Download LibreOffice | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with Microsoft
In case you will start writing own macros look at Information and resources for LibreOffice macros - The Document Foundation Wiki.