Created attachment 116906 [details] Mockup version 5 In discussion of the bug #92219, it was found that functions pane in sidebar could use some improvements to improve its usefulness and usability. Kendy, Jay, Heiko, Mattias and others during a design session tackled the problem and one possible still unfinished and not agreed on mockup was created. I upload it here to get more comments before finalizing it. Also please note that some features might not be easy to implement, so developers' comments are welcome as well.
Screenshots from various apps of their formula dialogs have been added to a future design session document for the pane's improvement. https://docs.google.com/document/d/1FXeKpcP3x-WdvnzI7xtxHujDQClaKb7fCoJC6xSn0jA/edit?usp=sharing
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
Unfortunately no further comments. Please bring the ticket in some actionable state, i.e. pieces that can get implemented.
Nice GSoC project
*** Bug 146623 has been marked as a duplicate of this bug. ***
I just resolved #146623 as a duplicate of this issue. The mockup here already outlines some (but not all) ideas in my own ticket. What I do not see in the mockup yet is the ability to drill down / debug further, into referenced cells. This would essentially provide a adequate or even better replacement for the missing "Evaluate Formula" feature (see #77684). The drill-down feature should also work with "named" formulas. That is, formulas that are defined in the "Manage Names" dialog. Currently, LO lacks any feature to debug such formulas. See #146623 for a detailed description of how I think this feature should work.
Just mentioning that bug 122718 was fixed for the upcoming version 24.2, adding a search field to the deck.