Hello,
I’m designing a Calc spreadsheet where each sheet is associated with a page style, named accordingly (ex: “MySheet” sheet is associated with the “PageMySheet” page style name).
The style is automatically created, named and associated when the user adds a new sheet to the spreadsheet. For this, I intercept the sheet creation event by using a listener. The same goes for a sheet deletion. So far so good.
But I’d like to take sheet name changes into account. Say the user changes “OldSheet” name to “NewSheet”. I’d like to change the “PageOldSheet” existing page style name to “PageNewSheet”.
I can’t find an event I might intercept when the sheet name is changed. I’ve tried using the generic XEventListener (checking “OnModeChanged” event name), to no avail: this event only carries the old sheet name.
Has anyone a clue in this matter?
Thanks a lot,
JF Nifenecker, Bordeaux