Ask Your Question
0

Calc formulas don't work that worked previously

asked 2019-12-02 16:01:32 +0100

nonnox15 gravatar image

I have a calc sheet that I have used for years. Today he formulas are working.
All it shows is the formulas and not the answer I am using Version: 6.2.7.1 (x64)

edit retag flag offensive close merge delete

Comments

Please delete all duplicates of this question.

Opaque gravatar imageOpaque ( 2019-12-02 16:05:02 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-12-02 16:08:23 +0100

Opaque gravatar image

Hello,

most probably you have set View -> [x] Show Formula. Unset and the formulas will evaluate and show the result.

Hop that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
0

answered 2019-12-02 18:09:26 +0100

nonnox15 gravatar image

Found this with search. "most probably you have set View -> [x] Show Formula. Unset and the formulas will evaluate and show the result."

edit flag offensive delete link more

Comments

You seem to be one of the most successful search tool users in the internet.

Opaque gravatar imageOpaque ( 2019-12-02 18:52:06 +0100 )edit
1

It is unfortunate that @nonnox15 didn't tell us the name of the site where the answer was found. It is worth a bookmark.

ve3oat gravatar imageve3oat ( 2019-12-02 20:20:23 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2019-12-02 16:01:32 +0100

Seen: 42 times

Last updated: Dec 02