How to view and re-edit formulas in tables of LibreOffice or OpenOffice Writer text documents?

Question

In LibreOffice or OpenOffice Writer, editing a text document, I can create a table and add a formula to a table cell by entering an equal sign. However, I cannot find a way to view and re-edit the formula once it's been entered.

LibreOffice help only explains how to enter a formula, but doesn't mention viewing or re-editing it.

How to view and re-edit formulas?

Martin · Accepted Answer · 2019-03-31T13:26:24.970

1

The LibreOffice help isn't precise enough at this point. You can do it by selecting the table cell with your formula and then press F2.

To do a test I created a 3x3 table in LO Writer, typed = sqrt 9 in the first cell and pressed Enter. Now a 3 appears in this cell. By pressing F2 the formula bar is shown up and I can do my edit (see selection).

edited Mar 31 '19 at 13:26

answered Mar 31 '19 at 12:47

Martin

178
10

This describes how to insert a new formula, but it doesn’t work for viewing and editing an existing one. – not2savvy Mar 31 '19 at 13:00
I edited my answer just to be clear (LO Version: 6.2.1.2 (x64)). – Martin Mar 31 '19 at 13:27

How to view and re-edit formulas in tables of LibreOffice or OpenOffice Writer text documents?

1 Answers1