Clicking on another sheet when typing in a formula, randomly goes to another cell

[Done]

Hello everybody,
I just updated to ver 25.2.1 after years with an old ver 7 and I found this problem.
Before the update, when I wanted to involve a cell or range from another sheet in a formula, I just had to click on the other sheet tab while typing. Choosing a cell or a range, then, would add it to the formula.

Now, when I click on the other sheet tab the selected cell switches from the one I’m typing the formula to a seemingly random one. That obviously interrupts the formula.
I tried uninstalling and trying a less recent version (24.8.5), but the probelm remains. I haven’t tried getting back to ver 7 because I’d really love to use the search.x function, not available back then.

Can someone please help me?
Many thanks in advance.

[LeroyG]

Test in safe mode (menu Help).
What is your operating system? Please, edit your question to share the info there (use the button in menu Help - About LibreOffice).

@Done

a seemingly random one

What if you click in “other sheet”.A1? You get the same “random” reference always?

[shantanuo]

My comment is not related to your question. But what is “search.x function” that you referred to?