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…