Description: N/A Steps to Reproduce: 0. Open a fresh document. 1. Create a new table. 2. Reference a row within an expression e.g. = <Table1.B2> + 1 which correctly renders 2. Actual Results: Hovering on <Table2.B2> shows me the formula, = <Table1.B2> + 1 Expected Results: There is some means to edit for the formula outside of re-creation. Reproducible: Always User Profile Reset: No Additional Info: Additional Info: Version: 7.5.4.2 (X86_64) / LibreOffice Community Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-NZ (en_NZ); UI: en-US Calc: CL threaded
Created attachment 188485 [details] Example
The Table menu has "Edit Formula (F2)"; and it is explained in the help: https://help.libreoffice.org/latest/en-US/text/swriter/main0214.html?&DbPAR=WRITER https://help.libreoffice.org/latest/en-US/text/swriter/guide/calculate.html?&DbPAR=WRITER Please describe what specifically you propose.
I think this is already covered by bug 147233 comment 10 and bug 85754. I suggest to close as a duplicate of one of those, and James, you could share your suggestion of a solution there?
Just want to add that I agree: it should be (1) more obvious that a cell contains a formula, and (2) easier to edit said formula. I'd be OK with keeping this report open if it focuses on the enhancement "Automatically show formula bar when in a cell with formula" (I could not find this already suggested on Bugzilla).
(In reply to Stéphane Guillou (stragu) from comment #4) > Just want to add that I agree: it should be (1) more obvious that a cell > contains a formula, and (2) easier to edit said formula. > > I'd be OK with keeping this report open if it focuses on the enhancement > "Automatically show formula bar when in a cell with formula" (I could not > find this already suggested on Bugzilla). Yes that would be an ideal solution and it is the case with Calc.
OK, seems like a sensible enhancement request to me, marking as new and inherited from OpenOffice. (no need to credit me in the summary :) )
Simply showing the Formula bar may not be enough as it is too easy with it shown to clobber any formula by click navigation to a different table cell or text entry on the now active Formula bar! Made worse bcz <Ctr>+Z does not back out formula changes. Recipe for "Expression is faulty" results unless the current .uno:InsertFormula gets some edit cursor focus logic added. The current <F2> toggle, and <Esc> does offers effective work flows for content review--just no indicator the cell holds a formula.
(In reply to V Stuart Foote from comment #7) > The current <F2> toggle, and <Esc> does offers effective work flows for > content review--just no indicator the cell holds a formula. as suggested for bug 85754 leaving the F2 toggle, rather than on mouseover or edit cursor focus, for exposing the Formula bar.
I have recently tested the F2 keybind via; Version: 7.5.5.2 (X86_64) / LibreOffice Community If I can make a suggestion then, how about a (on-by default) tool-tip toggle to indicate to the user that it exists however that pressing the key will remove the current input.