Need Help with Calc Spreadsheet!
You can add the command .uno:ToggleFormula to a toolbar. It is the command “ShowFormula” in category “View”. With this icon, you can toggle showing formulas or values, that is more useful than the corresponding setting in the options dialog. But in contrast to Excel it acts on the whole sheet and not only on the active cell.
1 Like
There is a function to see the formula in a cell:
=FORMULA(A1)
also there is an extension that maybe can help:
http://extensions.libreoffice.org/extension-center/display-formula-and-value-simultaneously