Esteemed Forum Participants and Lurkers:
===============================
I was (a few years ago) a fairly strong programmer in VBA macros for Excel. I also am reasonably proficient in Python. I am presently totally confused about using Python to write Calc macros. I do most of my work in Mint 15 Mate (32 bit) LiveDVD which includes LibreOffice Calc 4.0.2.2 and Python 2.7.4.
Could somebody please post everything needed to execute a macro IN PYTHON to do the following:
Assume any open/active Calc sheet, where cell A2 contains text "TEST" (or any other text) and cell E6 contains the number "1" (or any other integer) (all other cells empty):
On event "double-click" on cell A2:
write text in default format "Hello world" in cell C4
increment cell E6
Name the Macro "hellotest" and allow it to be accessed through:
Tools > Macros > Macro Selector > "hellotest"
This is not a complex task and it should help a beginner to get a feeble start. Just getting this far would explain a lot to me.
Thank you for any and all comments, suggestions, and assistance in this endeavor.
Blessings in abundance, all the best, & ENJOY!
Art in Carlisle, PA USA