Ask Your Question
0

basic - where to find help programming macros?

asked 2020-02-10 07:00:53 +0100

stabiloboss gravatar image

Hi,

I often find it difficult to find help programming macros in Basic. Things like a list of available properties and methods. What is the property for the backgroundcolor of a control? Is it backgroundcolor, or backcolor, or controlbackcolor, or something else still? In msoffice i find my answers on MSDN or by browsing through the available options in code completion, which displays a list of all available properties and methods. As far as I know, LO doesn't have code completion, so what are my options in LO?

Also code examples. I just posted an embarrassingly simple question on how to loop through cells in Calc, but I couldn't find the answer myself on google or on forums. Maybe I asked the wrong question, or maybe I searched in the wrong place. I found one example of a "for each" loop, but when I tried it I got the cryptic message "wrong data type". But then I don't know where to find out what the proper data type is?

I clearly need help on where to find help...

Thanks!

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2020-02-10 08:37:29 +0100

robleyd gravatar image

Try OpenOffice.org Macros Explained by Andrew Pitonyak. You might also find an object inspector such as MRI a useful tool. There is a tutorial on MRI here.

Some further topics can be found by searching macro documentation in the search bar above.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.

In case you need clarification, edit your question (not an answer) or comment the relevant answer.

edit flag offensive delete link more

Comments

Andrew Pitonyak's site also has a collection of links to resources on OOo Basic (some of them, unfortunately, are dead): http://www.pitonyak.org/oo.php

gabix gravatar imagegabix ( 2020-02-10 12:14:51 +0100 )edit

thanks everyone for the suggestions, i'll have a look. @robleyd: are you sure MRI is still working? I cant install it on LO 6.2.8.2 on linux. I get a cryptic runtimexception regarding some pythonloader: (com.sun.star.uno.RuntimeException) { { Message = "<class 'syntaxerror'="">: invalid syntax (MRI.py, line 21), traceback follows\X000a File \"/opt/libreoffice6.2/program/pythonloader.py\", line 149, in writeRegistryInfo\X000a mod = self.getModuleFromUrl( locationUrl )\X000a File \"/opt/libreoffice6.2/program/pythonloader.py\", line 102, in getModuleFromUrl\X000a codeobject = compile( src, encfile(filename), \"exec\" )\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

stabiloboss gravatar imagestabiloboss ( 2020-02-11 03:18:36 +0100 )edit
0

answered 2020-02-10 09:54:56 +0100

kiloran gravatar image

I've always found this site very useful, with a load of examples http://openoffice3.web.fc2.com/index....

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-02-10 07:00:53 +0100

Seen: 104 times

Last updated: Feb 10