Description: I am putting together an example to demonstrate building a form from python. The example automatically creates control and adds them to the spreadsheet. Event listeners are added to the form controls. Everything works fine until I select another sheet and then go back to the sheet that has the form controls. Many of form control events no longer work. I even tried reattaching the events but no luck. Interestingly some events still work such as property events using XPropertyChangeListener and spin events using XSpinListener Other listeners such as XItemListener and XTextListener stop working after sheet regains focus. More details and example links are found on ASK: https://ask.libreoffice.org/t/calc-form-controls-stop-working-when-sheet-is-de-activated-why/100427 Steps to Reproduce: 1. Add a form control to a Calc Sheet 2. Attach a listener to the form control 3. Assert that event listener work ( it should ) 4. Switch to another sheet 5. Switch to sheet that contains form. Actual Results: After switching back some listeners such as Other listeners such as XItemListener and XTextListener stop working. Expected Results: Listeners continue to work. Reproducible: Always User Profile Reset: No Additional Info: Also as noted in my post on ASK the model no longer are attached to the controls after switching to another sheet and back again.
Confirm this bug in my system: Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 16; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US 7.6.4-2 Calc: threaded
NEW per previous comment.