I confess I am converting a macro heavy Excel spreadsheet into Calc. I’m absolutely fine with the fact that I need to convert stuff, and a lot of initial hurdles have already been overcome… however, I have one hurdle I’m really struggling with.
In Excel, I use Worksheet_Change subroutines to detect when a cell changes on a particular sheet so action can be taken and I use Application.EnableEvents = True / False to enable or disable the triggering of that change macro.
I’ve learnt that in Calc, this becomes Sub OnSheetContentChange.
What I’m not sure about is how to enable/disable the triggering of OnSheetContentChange… I want to use the OnSheetContentChange macro to insert new lines when someone enters data into certain cells… But I don’t want the OnSheetContentChange macro to recursively call itself.