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.
I am working on this ticket as a GSoC Project, and I wanted to split it to smaller achievable tickets. At first, I want to enhance the current mock-up a bit in terms of the design and determine all the needed sections, and functionalities. The smaller tasks that needs to be done are: - Turn the functions list into collapsible sections (tree like view) - Help button to show a wiki for the selected function - Functionality to save formulas and edit them (is this needed? if yes, what are the features you wish to see?) - Enhance the searching functionality - The editor area I am not really sure what is expected to be done here. The things we can add are such as formatting, syntax highlighting, cell referencing and debugging. Is it expected to do all? or just some of them? or totally different features? and in the debugging functionality, does it need to calculate intermediate results or just highlight the very first error? I want to know your opinions if there is something needs to be added or removed or adjusted
(In reply to Ahmed Hamed from comment #8) > I want to know your opinions if there is something needs to be added or > removed or adjusted You could create new tickets and block this one like we handle META tickets. Once all goodies are done we may come back and see if this can be closed (probably since there is a parent anyway).