Summary: | Automatically show Writer's Formula bar when focused on a table cell with formula | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | James <user2650> |
Component: | Writer | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | stephane.guillou, vsfoote |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=85754 https://bugs.documentfoundation.org/show_bug.cgi?id=147233 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 122755 | ||
Attachments: | Example |
Description
James
2023-07-20 04:46:52 UTC
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. |