[Calc] Workbook events sheet management

[mwpowelllde]

I need to know, are the workbook events I can assign a macro towards.

I have the sheet events down, but when I create a new sheet, duplicate, whatever, that sheet also needs the benefit of the sheet events I installed on the first sheet.

[fpy]

question being if you even read answers

Setting array formula Err:508

It might be better if you describe what you want to achieve (with an example file)… Maybe there is one (or more) other way…

[mwpowelllde]

I started by setting a sheet event to begin with. That does well enough.

When I duplicate a sheet, I want to set the same EH for that sheet.

I’m looking into perhaps Activate document events as a way to inspect workbook or ThisComponent.Sheets events.

Maybe as indicated there are more or better ways of connecting those dots.

Edit: Really, though, I just need a “new sheet” or “sheet duplicated” event, if I can find it.

[mwpowelllde]

To clarify, prototype sheet, I did this manually, from Sheet > Sheet Events menu.

How do I do that in code, for new sheets, duplicated sheets, etc.

I need a way of connecting with the workbook sheet events, if possible. Alternatively, I am exploring a slightly more circuitous route via activated documents, but this does not seem quite right either.

[mwpowelllde]

Any constructive ideas? Thoughts? Events I might look into otherwise connecting these dots?

Best.

[Zizi64]

@mwpowelllde

Any constructive ideas?

Read Andrew Pitonyak’s books, and use the Google:
https://www.pitonyak.org/oo.php
.
.

How to programmatically get/set a form control's events

OK, thanks to Mauricio for pointing me in the right direction to get this figured out. The confusing part was that the events assigned to a form control object are not (as one would presume) contained within the control itself, rather its parent, the form object. Perhaps in the future the control object will have additional properties and methods for viewing, getting and setting events associated with it. While Python is a very popular way to run macros in Libre Office, this discussion uses B…

How to assign a macro to an event by a macro

Hello, Do not under the reasoning (or even some logic - options form?) of why you are attempting this. Seems like a security issue lurking. Edit: Regardless, your sample is not comparable to the request. It is a Event for a sheet and in comparison to modifying a form or control event, it is quite different. You can access the Base and Form events with your code. Should be able to access with ThisDatabaseDocument.Events.replaceByName("CHOSEN_EVENT", Prop()) End Edit For Form controls (a…

[mwpowelllde]

Thank you for that. That’s one half the question. The front side of it is, which document or other events might I be subscribing to in order to resolve either addition, duplication, etc, of a sheet? Alternatively, document being active may be an adequate fall back position. Again, I do not know the best possible way here, just asking the question, if there are suggestions, I’m happy to consider all. Thanks so much…