Ask Your Question

A calc sheet created before only shows formulas instead of results after formula edit

asked 2013-02-12 23:29:53 +0200

keepitsimpleengineer gravatar image

updated 2015-08-26 21:53:33 +0200

Alex Kemp gravatar image

A well used calc spread sheet returns as display in cell the text of the formula whenever the formula has been edited, and not the value of the formula calculation. Unedited formulas still return values (until edited).

Menu:Tools→Options⇒Options(Popup)⇝LibreOff Calc⇝View:Display:Formula Box is unchecked. Toggling this has no effect, except that text of formulas are displayed for all formulas when the box is checked.

Re-entering formula even using formula wizard has no effect.

The calc sheet has multiple sheets and cross sheet references.

Update: bug filed:

I suspect this is a bug but bugzilla is down. Show stopper for this calc sheet.

edit retag flag offensive close merge delete


@mariosv Thanks, but using a new profile in this case did not change the result.

keepitsimpleengineer gravatar imagekeepitsimpleengineer ( 2013-02-13 00:12:10 +0200 )edit

I think this question should be closed.

keepitsimpleengineer gravatar imagekeepitsimpleengineer ( 2013-02-23 01:28:55 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-02-27 03:12:41 +0200

qubit gravatar image

Bug filed as fdo#60755 - Display formula in cell instead of value of result after editing formula, undedited cells not affected - UNCONFIRMED

edit flag offensive delete link more

answered 2015-05-20 18:34:47 +0200

Foxtrot gravatar image

updated 2015-05-20 19:00:32 +0200

I found that this problem occurred when you change a formula when the cell is formatted as "Text" (use Ctrl-1, Numbers to see or change the format of the cell). If you change the format to something else, while the cell displays the changed formula instead of the result, the problem does not go away. It looks like Calc considers the formula as text, and will keep on doing that whatever format the cell is given after that. However, if you go back (using Ctrl Z) to a point before you started changing the formula, and then change the format of the cell (using Ctrl 1, Numbers) to something else (All/Standard works for me) the cell will show the result of the formula. You can also cut the changed but "corrupted" formula out of the cell, change the format to something else than Text, and copy back in the formula. It works for me!!

edit flag offensive delete link more

answered 2013-02-12 23:55:06 +0200

m.a.riosv gravatar image

Try resetting the user profile. Sometimes solve strange issues.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2013-02-12 23:29:53 +0200

Seen: 579 times

Last updated: May 20 '15