I could, at one time see formulas in cells.

Where you want to see the formula? In the actual cell, or in the formula editor box?

1.: In the Formula edit box;

Select a cell. The formula box will show the formula of the selected cell. If the Formula box is not visible, then you can customize the user interface.

2.: In the cell;

Double click on the cell. The cell will show the formula instead of the value. You can edit the formula in the cell.

*Picture for 1. & 2.*
- ShowFormula1.png (14.14 KiB) Viewed 690 times

3.: You can adjust the setting:

Tools - Options - Open/LibreOffice Calc - View - Display - Formulae.

The Calc will show the formulas in the cells permanently (instead of the referenced/calculated values).

Tibor Kovacs, Hungary; LO4.4.7, LO5.4.6 on Win7x64Prof.

PortableApps, winPenPack: LO3.3.0-LO6.0.2 and AOO4.1.5

Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.