[Libreoffice-ux-advise] [Bug 92219] Formula bar function wizard button should open the functions pane of sidebar

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=92219

--- Comment #10 from Philippe Jung <phil.jung at free.fr> ---
My point of view on this:

1) The distance (in term of mouse movement) between the toolbar button and the
sidebar is longer than the distance between the toolbar button and the popup.
When you will have to select cell ranges, your mouse will have to go to the
sheet, back to the sidebar, back to the sheet, back to the sidebar...

2) When you are editing a formula, the use case is rather "modal". You select a
cell, edit the formula, press enter, go to next cell. You end the action when
everything is completed, all parameters given with correct value. From my point
of view, the sidebar is more oriented to single, atomic, "asynchronous"
operations such as apply a style (you click, the operation is done). Here we
have several consecutive operations: select a function, select parameters by
hidding the dialog to select cell ranges and so on. What happens if only half
of the parameters are ok when you change cell selection ? I believe the cinetic
of the sidebar is not adequate.

3) From a need / use case point of view, my experience with the fx button (if
we are really speaking of the fx button :-) ) :
- I don't need a dialog box to do completion or pre-evaluation of the
parameters
- I would like inline completion of the formula in the formula bar, tooltips,
syntax coloring
- I click fx button when and only when I have no f**ing idea of the name of the
function that does what I want to do. My (the?) real need is to type a keyword
and get a list of functions that are related to this keyword. Exemple of
keyword: regression, loan, average, prediction, total, month, trend

-- 
You are receiving this mail because:
You are on the CC list for the bug.