I’ve opened a saved LO calc doc then it disappeared when I moved it to another screen. I tried to open the same doc again, and that one disappears too. On my Windows 11 taskbar I hover over the LO Calc icon and it shows as as OPEN
Try Win+Tab key, to show all (virtual) desktops.
I remember the behaviour to open additional windows on the same virtual desktop as the other/first.