# How do I stop text from turning into functions?

Whenever I type certain words into a field in Calc, they are automatically turned into a function followed by parenthesis. For instance if I write the word "at", it changes it to "ATAN()", which means arctangent and is used to calculate something I have no interest in. This has happened with other words for other functions as well. Can someone share how I can turn this feature off? Thanks!

edit retag close merge delete

But, only happend if you first type symbol =, not?

( 2019-10-10 05:47:10 +0200 )edit

Yup, that was the issue. Actually, I was using the - sign, making a list using bullet points... Thanks!

( 2020-01-13 19:05:45 +0200 )edit

Sort by » oldest newest most voted

Input starting with =, + or - will tell Calc to expect a formula. With that, you get automated suggestions for function names in many cases.

I routinely disable all autocorrect options and autoinput (on the Tools menu) and also untick "Extended tips" in Tools - Options, LibreOffice - General. This seems to reduce the number of cases where function suggestions occur. However, in some cases such as when you backspace to a possible function name, the suggestion pops up anyway.

The expected solution would be to format cells as text cells when you don't want formula help. This defeats all calculation and accepts input verbatim, except that those function suggestions still pop up if initial character is as indicated above. Looks like a bug to me.

A workaround: start input with an apostrophe ('). This will tell Calc that input is to be interpreted as verbatim text, and no suggestions will pop up (as far as I have checked it). This is how "format cell as text" also should work. That leading apostrophe will not show in the cell grid display and not be part of cell content, but it will show with the content preview in the formula bar in some cases.

Pitfall: if the cell is already formatted as text, a leading apostrophe will become part of the cell content (and as such, show up in the cell grid display).

more