A fairly unassuming macro causes the Add Sheet button to add infinite sheets to a workbook.

This is affecting my current project which isn't large but has complexity. I've narrowed it down to a small 100% reproducible test case.

Steps to reproduce
1. Start with Calc (and all Office apps) complete closed. Open Calc.
2. Tools -> Macros -> Edit Macros
3. In the editor click the Modules toolbar button to add 'Module1' to 'Untitled 1'. Modules button -> expand 'Untitled 1' -> select 'Standard' -> New... -> accept defaults by clicking Ok -> Close Macro Organizer dialog
4. In the navigation on the left, select the newly added 'Module1': Expand 'Untitled 1' -> Expand Standard -> double click 'Module1'.
5. Add macro to module. There will be a pre-populated template, delete that. Then add this:
function infiniteSheets(q1 as variant, q2 as variant, q3 as variant, q4 as variant)
        dim w1 as variant
        if IsEmpty(w1) then
                infiniteSheets = w1
                exit function
        end if
        infiniteSheets = ""
end function
6. Set a breakpoint on line 3 by double-clicking just to the left of the '3' line number. A red circle with a dot should appear.
7. Switch back to the untitled spreadsheet window.
8. In cell A1 enter the text '=infinitesheets(A2,B2,C2,D2)' then hit enter.
9. OBSERVE: the breakpoint isn't hit. This is probably a secondary bug worth its own bug report, but it's not the focus of this bug report.
10. In the status bar, click the Add Sheet button.
11. OBSERVE: The breakpoint is hit.
12. Press the run button in the Macro Editor window.
13. OBSERVE: The main Calc window is now adding an infinite number of sheets.
14. Clicking the Add Sheet button a second time halts the process.

In my original project there was some dependency on the macro arguments. I was passing in an array from a column of cells that happened to have no values or formulas. This was argument number 5 of 6 arguments. The problem would reproduce when this empty array was in positions 4, 5, or 6, but not in 3 or 1.
The reproduction above takes 4 arguments but I haven't tried to find out if that's important or not. The reproduction doesn't actually use any of the arguments, unlike my project.

While I've been typing this, I let the process run. It has stopped adding sheets after 3688 sheets, but the cursor is still in the spinning wheel form indicating processing is ongoing, just no longer adding sheets.
UPDATE: Sheets are still being added, the UI is just updating with extreme lag. Currently at 4984.

In my project, I was able to avoid the issue by removing parts of the macro, but it wasn't clear why that worked. In the reproduction case, the delay of responding to the breakpoint hit to press run to let it continue appears to be critical. Run the reproduction and skip setting the breakpoint in step 6, the problem won't occur. I suspect that how long the macro runs vis a vis the Add Sheet functionality running is important.

Part of my project is a macro that instantiates a new templated sheet. Today is the first time I hit the Add Sheet button on my project in quite a long time. I don't know if this bug is new in 7.2.2.2 or has been around for a while.

Data:

studog@home:~$ uname -a
Linux home 5.4.0-87-generic #98~18.04.1-Ubuntu SMP Wed Sep 22 10:45:04 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
studog@home:~$ lsb_release -a
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 18.04.6 LTS
Release:	18.04
Codename:	bionic

Version: 7.2.2.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.2~rc2-0ubuntu0.18.04.1~lo1
Calc: threaded

7.2.2.2 is a recent upgrade:
2021-10-17 01:30:37 upgrade libreoffice-base-drivers:amd64 1:7.1.6~rc2-0ubuntu0.18.04.1~lo1 1:7.2.2~rc2-0ubuntu0.18.04.1~lo1
2021-10-17 01:30:38 upgrade libreoffice-calc:amd64 1:7.1.6~rc2-0ubuntu0.18.04.1~lo1 1:7.2.2~rc2-0ubuntu0.18.04.1~lo1