Ask Your Question

Formula to Value greyed out

asked 2017-03-15 14:27:32 +0100

this post is marked as community wiki

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


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 flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-15 15:00:41 +0100

Lupp gravatar image

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.

edit flag offensive delete link 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?

joea gravatar imagejoea ( 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

erAck gravatar imageerAck ( 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.

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

Thanks to all.

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

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

Lupp gravatar imageLupp ( 2017-03-15 19:17:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-15 14:27:32 +0100

Seen: 129 times

Last updated: Mar 15 '17