Ask Your Question

Calc showing sometimes function, sometimes value

asked 2017-02-12 14:55:05 +0200

JackSF gravatar image

I'm using Win10 and LibreOffice

I'm trying to use the function IFS - let's say in this way: IFS(a1=1;"A";a1=2;"B") etc

Now, in some cells I do indeed get what I want: either A or B depending on the value of the cell A1. But sometimes, seemingly completely arbitrarily, I only see the function itself, not the result.

Tools/options/calc/view/formulas NOT on!!

I have tried to write the function directly as well as using the wizard, but what stays is the seemingly random behavior: some cells continue to show value, some the function. And the cell formatting is exactly the same (number or text, doesn't change anything by the way).

Feels like a Bug. Any comments?

edit retag flag offensive close merge delete


I find no problem on v5.3.0.3 using Linux Mint 18. In the cells displaying the function itself, does the function begin with = or is it displayed as in your question?

Ratslinger gravatar imageRatslinger ( 2017-02-12 15:45:48 +0200 )edit

When the cell displays the function, it does include the equals sign. Somehow it treats the function as text. But the randomness is the worrying thing...

JackSF gravatar imageJackSF ( 2017-02-12 16:31:29 +0200 )edit

When I do have the function doing what is should and then go and change the characters inside the quotation marks or the numbers in the condition part, then the interpretation of the cell changes from function to text.

JackSF gravatar imageJackSF ( 2017-02-12 16:35:00 +0200 )edit

An example of the "from" (working) to the "changed" (displays function) would probably help.

Ratslinger gravatar imageRatslinger ( 2017-02-12 16:43:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-02-12 17:11:05 +0200

karolus gravatar image

Most propably you has the cells in question formattet as Text, before you entered the Formulas.

Text-formattet Cells lets the Cellinput as it is, !!!ANY INPUT!!!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-12 14:55:05 +0200

Seen: 128 times

Last updated: Feb 12 '17