Always show formula in input/formula bar, even after closing Calc [closed]

asked 2014-05-28 16:39:12 +0100

singingstrings gravatar image

In Calc, is there a way to keep a formula visible when you click on a cell, even after saving a closing/re-opening a Calc document? Currently after the formula is used, upon re-opening the spreadsheet it only displays the formulas results in the input line. I would like to have the formula's visibility retained in the input/formula line at all times. Only in the cell do I wish to have the formulas output displayed.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-23 21:24:25.960200


What you want is default and I never observed a behaviour as you described it. The only way I know to exclude formulae from showing in the edit control is using the protection tool. Can you describe in detail what you did before closing and reopening your Calc file?

Lupp gravatar imageLupp ( 2014-05-28 16:56:20 +0100 )edit

Please, what file format do you use to save?

m.a.riosv gravatar imagem.a.riosv ( 2014-05-28 22:39:22 +0100 )edit