Ask Your Question

Is there a work-around for the formula/value display problem? [closed]

asked 2013-02-23 01:25:42 +0200

keepitsimpleengineer gravatar image

updated 2015-10-20 23:54:44 +0200

Alex Kemp gravatar image

At first I thought I had made an error and asked this question. But now it seems to be a bug. I first saw this in Calc I tried to downgrade to the prior version but was stymied by a library dependency. So I upgraded to and the same thing occurs.

To wit: After editing a spreadsheet formula, the cell will no longer display the value (text) but only will display the edited formula. Unedited formula cells still show values. Changing the formula display in Calc options has no affect.

I don't know how long it will take to get these bugs fixed, and I'm pretty much stuck on a project until I can get a workaround at least.

Bugs filed are: Display formula in cell instead of value of result after editing formula, unedited cells not affected and VIEWING: Values not shown in cells, only formulae.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 23:54:58.418724

3 Answers

Sort by » oldest newest most voted

answered 2013-02-23 06:30:38 +0200

qubit gravatar image

updated 2013-02-23 06:49:28 +0200

Hi @keepitsimpleengineer,

Couple of notes here:

  1. Take a look at @mariosv's Answer
  2. When mentioning bugs filed on fdo, it can help us when we skim the question if you include the bug # and the current status, like this:

    2a. Including the bug title like this is helpful as well, but don't feel obligated to do so :-)

    • fdo#60755 - Display formula in cell instead of value of result after editing formula, undedited cells not affected
  3. There are some useful repro steps and an attachment on fdo#61316. Could you please add those to fdo#60755? That could help us to repro the bug.

In fact, when you move those over, please post a reply with @qubit in it -- that'll give me a ping, and I'll try to hop over and repro fdo#60755 for you.

Thanks for all your help!

edit flag offensive delete link more

answered 2013-02-24 20:26:34 +0200

petef. gravatar image

Does this problem occur only when the cell in question is formatted as a text cell??

If so this workaround has worked for me in the past:

  1. Before editing the formula, change the cell format from text to Number - General.
  2. Edit the formula in the cell, after editing it should display the value not the formula.
  3. You can now reformat the cell as text, and it should continue to display the value.

Hope this works for you.

edit flag offensive delete link more

answered 2013-02-23 01:41:57 +0200

m.a.riosv gravatar image

Hi keepitsimpleengineer,
I have never find this issue, using calc daily.

Have you tried to reset the user profile?, sometimes solve strange issues.

edit flag offensive delete link more


@mariosv -- I think if we use the @name syntax in posts, people will be more likely to get a ping about the update to the question.

qubit gravatar imagequbit ( 2013-02-23 06:21:29 +0200 )edit

qubit. I don't want the Inquisition here. And I don't want anyone modifying my posts or giving me unnecessary advices, except there is a true reason, and maybe I am not the only one. So please don't do it any more.

m.a.riosv gravatar imagem.a.riosv ( 2013-02-24 23:46:13 +0200 )edit

Question Tools

1 follower


Asked: 2013-02-23 01:25:42 +0200

Seen: 1,706 times

Last updated: Feb 24 '13