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).
- formula to calculate bounding coordinates of an arc in space
- SUMPRODUCT formula confusing performance in conditional conditional formatting
- Creating a progress indicator with a rounded rectangle
- FILTER formula with both row and column condition resulting in #VALUE error
- Excel validate entries in list of lists
- How can I get my R formula to correctly parse a true/false statement as one of its arguments?
- How to utilize date add function in Google spreadsheet?
- How to unnest data from one column to fit the entire dataset - Google Sheets
- Mass Editing Hyperlinks in Excel
- Is it possible to group dates together and return a start and end date for that group?
- How to extract URL from Link in Google Sheets using a formula?
- How to make previous dates data from one tab appear in another tab
- In Unity how do I convert a Vector3 isometric (tilemap) direction to a normal direction in degrees
- Sort values and remove "0" with formula
- I want Excel to interpret an operator as a caracter in a formula
- Lua level formula
- Adding numbers in Excel, based on a condition
- Using EOMONTH in Google Sheets considering time not just date
- Sumif times (datetime format) are greater than 22:30
- If formula (the sum is less than 30 then roundup tp 30)
- How to use fraction string in Excel/Calc/Sheets as formula
- svyby - how to call in different variables for by formula in a function?
- QUERY function with multiple conditions using time frame
- Function in excel contains unrecognized text from a code I made in microsoft VBA
- Sorting the string combined with arrayformula()
- how to sort a string contains list of number in google sheet?
- formula for number of blocks with mortar in a distance
- Is the mktime64 implementation simple by pure coincidence or by design?
- Google Sheets: SUMPRODUCT Formula for Summing Income and Expenses by Month Across Multiple Sheets
- Return one value from a report list, not sum or record count in Sheets