I would like to stop function prompts when editing formulas in Calc

[craigdurban]

In calc, if I am editing a formula, the software is excessively keen to help me.
This is a Microsoft approach, where they always assume the user is very very dumb.
Libre Office is not Microsoft. Thats why I use it. So I need help to de-Microsoft this feature.

For example:
I am editing this line.

=IF($V2="", "" , "INSERT INTO `treelookup` SET `kkey` =   ....

I change $V2 to $W2 without paying much attention. I get

=IF($WEBSERVICE()="", "" , "INSERT INTO `treelookup` SET `kkey` = ....

Calc helpfully thinks my W should be WEBSERVICE() so without asking me, it just inserts it.

Yes, I can work around it by paying more attention and tapping ESC to chase away the eager
tooltip but why should I.
I would love to turn this feature off.
Where do I do that?

[JohnSUN]

AutoInput?

[ROSt53]

@JohnSUN - You are right stopping AutoInput stops this behavior. However, I always had AutoInput on but never saw this strange behavior before I started with version 4.3. I just checked again with 4.2 (portable) and there this strange behavior is not to be seen.

Example:
Formula is =count(c1:c10) and I want to change c1 to a1.

In both used LIbO versions AutoInput is ON.

In 4.2, I can delete “c”, enter “a” and press ENTER and the formula looks =count(a1:c10). I consider this as correct.

In 4.3, when I delete “c” and replace it by “a” and hit ENTER, the formula becomes =count(abs():c10). The abs() is automatically filled in. I don’t know if this MSO style but I think it is a bug.

[JohnSUN]

@ROSt53 - It’s not my decision. I just checked that the solution of @mariosv work in my version 4.3.5.2

[ROSt53]

@JohnSUN - Your answer means that this is not a bug but a new feature. Guess that the people who decided on that did not work that much with Calc. Fortunately @mariosv 's workaround exists.