# Formula to Value greyed out

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Version: 5.2.5.1

Created a formula in a cell. Did: Data, Calculate, Formula to Value. Worked fine to display value.

However, now I wish to modify the formula slightly. However, when I try to reverse this to display formula, I find it greyed out.

What to do?

edit retag close merge delete

Sort by » oldest newest most voted

Any cell can contain exactly one of the following: a number, a text, or a formula.

As soon as you replaced a formula by its result (either number or text) the formula is no longer present. The only way to get it back is the > 'Edit' > 'Undo' tool (also Ctrl+Z) of the user interface, but only as long as the undo-stack was big enough, and the document was not saved.

more

Thanks. There must be a way to retain the (an) original formula, perhaps in a "protected" cell, and have the results show in another cell?

( 2017-03-15 15:23:59 +0100 )edit

You can always refer to the formula cell in another cell to display its value, e.g. with your formula in A1 just enter into any other cell =A1

( 2017-03-15 15:31:09 +0100 )edit

By default the result of the formula should be shown anyway in the cell containing the formula. If you got shown there permanently (not only during editing) the formula, you must have the setting
'Tools' > 'Options' > 'LibreOffice Calc' > 'View' > 'Display' > 'Formulae'
switched on (wrongly). This is an option only (rarely) useful during the design/debugging of complicated sheets.

( 2017-03-15 15:41:00 +0100 )edit

Thanks to all.

( 2017-03-15 17:01:30 +0100 )edit

@joea:L Would you mind to tell in what way you got rid of your problem?

( 2017-03-15 19:17:35 +0100 )edit