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

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 3.6.5.2. I tried to downgrade to the prior version but was stymied by a library dependency. So I upgraded to 4.0.0.3 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.