https://bugs.documentfoundation.org/show_bug.cgi?id=155316
ady <adylo811...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |andreas.heini...@yahoo.de
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #2 from ady <adylo811...@gmail.com> ---
Experienced/advanced spreadsheet users will probably understand the request
easier than generic users. This is why bug 104487 has so many specific detailed
explanations, and this request is based on that.
The following STR are based on LO 7.6. Older versions will behave differently
(because of the implementation of tdf#104487).
1. Start with LO completely closed (i.e. new LO session). Start a new Calc
spreadsheet.
2.
A1: 1
A2: 2
A3: 3
3. In cell A4, click on the Function Wizard icon. Note that the Category field
is "All"; the cursor blinks within the Search field.
4. Search for "average". The Function list is filtered.
5. In the Function list, select AVERAGE and follow the FW -> A4:
=AVERAGE(A$1:A$3)
6. Go to cell A5; click on the Function Wizard icon. Note that the Category
field is "Statistical"; the cursor blinks within the Search field.
7. Search for "concat" (a function that is not in the same Category as the
prior function). The Function list is filtered.
8. In the Function list, select CONCAT and follow the FW -> A5:
=CONCAT(A$1:A$3)
9. Go to cell A6; click on the Function Wizard icon. Note that the Category
field is "Text"; the cursor blinks within the Search field.
10. Click on the Category field and select "Last Used" (i.e. shows the
"recently used" functions). At least AVERAGE and CONCAT will be shown in the
Function list in the FW.
11. In the Function list of the FW, select any function you would like and
continue with the FW up to finishing it, inserting a new formula in cell A6.
For example, A6: =SUM(A$1:A$3)
12. Go to cell A7; click on the Function Wizard icon.
In order to show the complete set of possibilities (or algorithm, or logic), I
would have to add many more steps. Please read tdf#104487 and comment 0 in this
bug 155316.
Current behavior (LO 7.6, _not_ in older versions, see comment 0):
On a cell that has no function (i.e. empty, direct values, or with simple
operators), the default Category when opening the F.W. would be the same as the
category of the _main_ function that was last _seen_ in the F.W. (This is never
the "Last Used" category.)
Expected behavior:
See comment 0.
Let's CC Andreas Heinisch (quote from bug 104487 comment 18, "it is clear
now").
--
You are receiving this mail because:
You are the assignee for the bug.
