Bug 92416 - SIDEBAR: Functions pane improvements
Summary: SIDEBAR: Functions pane improvements
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) rc
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Sidebar-Functions
  Show dependency treegraph
Reported: 2015-06-29 09:01 UTC by mahfiaz
Modified: 2023-09-19 22:29 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Mockup version 5 (279.98 KB, image/png)
2015-06-29 09:01 UTC, mahfiaz

Note You need to log in before you can comment on or make changes to this bug.
Description mahfiaz 2015-06-29 09:01:57 UTC
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.
Comment 1 Yousuf Philips (jay) (retired) 2015-06-29 16:58:46 UTC
Screenshots from various apps of their formula dialogs have been added to a future design session document for the pane's improvement.

Comment 2 Robinson Tryon (qubit) 2016-08-25 05:39:04 UTC Comment hidden (obsolete)
Comment 3 Heiko Tietze 2017-09-21 13:47:11 UTC Comment hidden (no-value)
Comment 4 Heiko Tietze 2018-02-26 11:16:02 UTC
Nice GSoC project
Comment 5 Damian Hofmann 2023-02-16 19:40:11 UTC
*** Bug 146623 has been marked as a duplicate of this bug. ***
Comment 6 Damian Hofmann 2023-02-16 19:52:45 UTC
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.
Comment 7 Stéphane Guillou (stragu) 2023-09-19 22:29:28 UTC
Just mentioning that bug 122718 was fixed for the upcoming version 24.2, adding a search field to the deck.