formulaopenoffice-writerlibreoffice-writer
How to view and re-edit formulas in tables of LibreOffice or OpenOffice Writer text documents?
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?
Solution
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).
- How to use VLOOKUP() + QUERY() + IMPORTRANGE() with multiple conditions?
- Formula to Get nth to Last in Comma Separated List
- Formula to change how a number is displayed in crystal reports
- Query and Importrange function with conditions
- Google Sheets - Import Range issue and building a formula that both Import Ranges but based on corresponding Data Validation in another column
- How do I use IFS to conditionally apply a percentage?
- How to properly get if a number is between two given numbers in excel?
- Excel - Highlight rows based on set conditions
- Formulas Referencing a Form Response sheet moves rows when a new row is inserted in the response sheet
- Timezone conversion in a Google Sheets with DST (Daylight savings)
- Google Sheets Formula Filter Combined Values - Separated by Comma's
- Find values from specific condition
- Total hours of overtime
- google sheets if- condition wrong evaluation as false
- Google Sheets Query - Changing Query Data Range Based using a reference cell
- Google Sheets query formula partially working
- How to add a pound symbol(£) before the formula in textbox
- Calculate percentage saved between two numbers?
- CSS: How can I adjust my font size fill all the space in a justified layout?
- Explanation of formula to count # of iterations in a loop
- Weird hidden character in Excel that counts up in COUNTIF
- Excel formula to split an amount per year depending on expenditure days within a date range
- Excel formula to count duplicates as one
- How to calculate intersection point between lines and ellipses using only math equation
- How to Concatenate cells separated by comma when adjacent cell is checked (or is there an easier way without the checkbox?)
- Can VBA be used to set print area as a formula in a sheet?
- Excel Formula Combine MATCH , INDEX, COUNT
- Google Sheets Cell Reference Shifts When Deleting Column
- Base64 length calculation?
- excel get sheet name from address