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).
But, only happend if you first type symbol
=
, not?Yup, that was the issue. Actually, I was using the - sign, making a list using bullet points... Thanks!