[Solved] If there is a recipe book on AOO Basic?

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
no_such_UNO
Posts: 15
Joined: Sat Jun 24, 2023 2:42 pm

[Solved] If there is a recipe book on AOO Basic?

Post by no_such_UNO »

I wander if there is something like a recipe book on OO Basic. Especially on what can be done with arrays using for...each, for, loop.
Last edited by Hagar Delest on Thu Jul 27, 2023 2:18 pm, edited 1 time in total.
Reason: tagged solved.
LibreOffice 7.2.7.3 on LinuxMint 21.1
JeJe
Volunteer
Posts: 2789
Joined: Wed Mar 09, 2016 2:40 pm

Re: If there is a recipe book on OO Basic?

Post by JeJe »

What you mean by a recipe book? Do you mean a collection of examples?

https://wiki.openoffice.org/wiki/Docume ... uide/Loops
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
User avatar
Zizi64
Volunteer
Posts: 11365
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: If there is a recipe book on OO Basic?

Post by Zizi64 »

There is HELP for the Basic - if you want informations about the Basic statements and commands...
https://help.libreoffice.org/latest/en- ... n0601.html

There is a programming guide:
https://wiki.documentfoundation.org/Doc ... ASIC_Guide

There is a list for the API - if you want informations about the functions, subroutines (properties, methods, interfaces) of the programming objects of the Application Programming Interface...
https://api.libreoffice.org/

There are Forums with many sample code snippets - just search in them. One of them is this Forum.
https://ask.libreoffice.org/c/english/5

And there are Andrew Pitonyak's free Macro Books: what contain examples for usage of the Basic AND the API.
Temporarly (I hope it: only temporarly) is not available...
https://www.pitonyak.org/oo.php
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
JeJe
Volunteer
Posts: 2789
Joined: Wed Mar 09, 2016 2:40 pm

Re: If there is a recipe book on OO Basic?

Post by JeJe »

OOBasic, in the elements not specific to the office suite, is close to a clone of Microsoft's original Visual Basic so if you search for "VB6" or "Visual Basic 6" along with what you want information about there is often code or explanation that you can use in OOBasic too.

You may find these invaluable, I do:

Basic IDE Tools
https://extensions.openoffice.org/en/pr ... -ide-tools
(may be issues with newer version of OO/LO)

MRI
viewtopic.php?t=49294
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
User avatar
Lupp
Volunteer
Posts: 3553
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: If there is a recipe book on OO Basic?

Post by Lupp »

If you read the already mentioned famous texts ("the book" and "useful information") by Andrew Pitonyak you will find that LibO Basic (basically the same as OO.o / AOO / StarOffice Basic) is a rather simple Basic as compared to VBA which also provides lots of means to manipulate documents like an API would do.
LibO Basic isn't the API, but uses the API included with the LibO program with the help of a few predefined vaiables (StarDesktop, ThisComponent e.g.) and a short (rather "transparent") bridge to the API.

===Editing 2023-07-27 about 10:30 UTC===
Hmmm?
First time in decades Andrew's site didn't respond to me today.
Last edited by Lupp on Thu Jul 27, 2023 12:28 pm, edited 1 time in total.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
no_such_UNO
Posts: 15
Joined: Sat Jun 24, 2023 2:42 pm

Re: If there is a recipe book on OO Basic?

Post by no_such_UNO »

Guys, you left me speechless, thank all of you very much!
LibreOffice 7.2.7.3 on LinuxMint 21.1
caceyneinei
Posts: 1
Joined: Thu Jul 27, 2023 7:50 pm

Re: If there is a recipe book on OO Basic?

Post by caceyneinei »

Zizi64 wrote: Thu Jul 27, 2023 5:50 am There is HELP for the Basic - if you want informations about the Basic statements and commands...
https://help.libreoffice.org/latest/en- ... n0601.html

There is a programming guide:
https://wiki.documentfoundation.org/Doc ... ASIC_Guide

There is a list for the API - if you want informations about the functions, subroutines (properties, methods, interfaces) of the programming objects of the Application Programming Interface...
https://api.libreoffice.org/

There are Forums with many sample code snippets - just search in them. One of them is this Forum.
https://ask.libreoffice.org/c/english/5

And there are Andrew Pitonyak's free Macro Books: what contain examples for usage of the Basic AND the API.
Temporarly (I hope it: only temporarly) is not available...
https://www.pitonyak.org/oo.php
Do you have it also in another languages ? I am originally from india so a book in Hindi would be easier for me to learn from!
OpenOffice 3.1 on Windows Vista
musikai
Volunteer
Posts: 294
Joined: Wed Nov 11, 2015 12:19 am

Re: If there is a recipe book on OO Basic?

Post by musikai »

Lupp wrote: Thu Jul 27, 2023 10:30 am Hmmm?
First time in decades Andrew's site didn't respond to me today.
Yes, frightening.
Backup:
https://web.archive.org/web/20230421081 ... org/oo.php

Also the german translation by Volker Lenhardt vanished from the University Site:
http://www.uni-due.de/~abi070/count.php ... eutsch.pdf
A revised translation can now be found at:
https://www.prooo-box.org/live/dokument ... eutsch.pdf
Win7 Pro, Lubuntu 15.10, LO 4.4.7, OO 4.1.3
Free Project: LibreOffice Songbook Architect (LOSA)
http://struckkai.blogspot.de/2015/04/li ... itect.html
User avatar
MrProgrammer
Moderator
Posts: 4913
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [Solved] If there is a recipe book on AOO Basic?

Post by MrProgrammer »

Lupp wrote: Thu Jul 27, 2023 10:30 am First time in decades Andrew's site didn't respond to me today.
musikai wrote: Fri Jul 28, 2023 12:43 am Yes, frightening.
Another backup is SourceForce → OpenOffice.org Macros → Andrew Pitonyak_s Macro Doc which has his documentation from 2003 to 2006. Perhaps artificial intelligence is deleting valuable sources so that we will be forced to depend on AI for answers.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
robleyd
Moderator
Posts: 5089
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [Solved] If there is a recipe book on AOO Basic?

Post by robleyd »

:alarm: The rise of the machines has begun; Armageddon is upon us! Flee while you can!
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
Zizi64
Volunteer
Posts: 11365
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] If there is a recipe book on AOO Basic?

Post by Zizi64 »

Do you have it also in another languages ? I am originally from india so a book in Hindi would be easier for me to learn from!
The LibreOffice HElP is localized. Check it please if the Hindi exists or not.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
JeJe
Volunteer
Posts: 2789
Joined: Wed Mar 09, 2016 2:40 pm

Re: [Solved] If there is a recipe book on AOO Basic?

Post by JeJe »

robleyd wrote: Fri Jul 28, 2023 5:51 am :alarm: The rise of the machines has begun; Armageddon is upon us! Flee while you can!
Without a machine it will be a very tiring walk.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
User avatar
Lupp
Volunteer
Posts: 3553
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: [Solved] If there is a recipe book on AOO Basic?

Post by Lupp »

[Taking part in the sequence of partly funny, but also interesting OT comments.]

Gerd Gigerenzer: "How to remain Smart in a Smart World" (Also published 2021 -still readable?- in German under the title "Klick". )
Gerd Gigerenzer is a German psychologist and educational researcher, admittedly only three years younger than me, and therefore too old...
At least he wrote and published this book in English. Only afterwards it was translated into German by someone else (Hainer Kober). I wonder if AI worked under a pseudonym here?

This post by Lupp is translated from German into English with the help of DeepL.com, an AI based translator.
Lupp has to admit that he didn't yet finish the book. Too much "in the internt", on silly forums, e.g. ?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply