Calc Sheet events onSelectChange, onChange, onCalculate

torreone · March 19, 2020, 8:49pm

Hello to all. I have some problems handling sheet events. In the attached file I manage following events

onSelectChange: each click on the target cell (C3) the event handler should be called only once to increase the counter displayed in column A (it can be reset with a click on cell F3). Instead, the handler is almost always called 3 times, episodically only once
onChange: a combobox in C12 changes its value (but also selecting the previous one activates the handler). However, with a link to external data refreshed periodically the event does not trigger even if some cells change the value
onCalculate: here a very strange thing happens: in the declaration of the event handler, inserting as in the previous cases the formal parameter pEvent in which calc should pass a reference to the calculated cell, during the call the error “wrong number of” is given parameters ". Why ?

Thanks at the start for any help

Ubuntu 16.04
Libreoffice 6.2.6.2
calcSheetEventTest.ods

torreone · March 19, 2020, 9:08pm

I also took this answer into account Which Event Macro on spreadsheet contents change? and others like it, but it doesn’t seem to explain the absence of onchange handler call.

At least the first time, after saving the document, the handler should have been called, but not called

torreone · April 13, 2020, 8:59pm

I finally find someone with my same problem, but he too has not solved it