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).
- 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
- Combine two columns that's are on a column "B" and column "C" and then make them into one column on column "E" with even and odd position each others
- How to determine luminance %?
- Widen/narrow line sections of plot so that x-axis breaks at peaks are evenly spaced
- Merging Google Sheets formulas into1 to get the same Result
- Finding the total numbers between values in TI nspire spreadsheets
- Use macro to dynamically insert static formula reference to an Excel sheet
- Collapsing Wide Data into Tall Data in Google Sheets
- Google Sheets QUERY Issue When Name Includes '
- How to render Latex markup using Python?
- offer price with target ROI
- Enter Cell Formula using VBA
- How to add a pound symbol(£) before the formula in textbox