Bug 39764 - UI: Function list category "Last Used" always inserts function from the top and duplicates existing list
Summary: UI: Function list category "Last Used" always inserts function from the top a...
Status: RESOLVED DUPLICATE of bug 87558
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.2 release
Hardware: Other All
: medium major
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2011-08-02 07:50 UTC by Rainer Bielefeld Retired
Modified: 2014-12-22 11:44 UTC (History)
11 users (show)

See Also:
Crash report or crash signature:

Reproduced Bug along with new Problems (52.49 KB, image/png)
2011-08-02 18:48 UTC, Jeffrey

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2011-08-02 07:50:21 UTC
I see that with "LibreOffice 3.4.2  – WIN7  Home Premium  (64bit) English UI [OOO340m1 (Build:203)]".

Steps to reproduce:
1. open new spreadsheet
2. Insert some formulas like '=now()', '=today()', '=SUM(A1:A2)'
3. click any cell
4. Menu 'Insert -> Function List' (if not already active) or open Function List
5. Select "Last Used" from Picker
   You should see a short list with at least functions from step 2
6. Select a function from somewhere in the middle of the list, I selected SUM
7. Doubleclick selected function
   Expected: SUM inserted into cell from step 3
8. NOW inserted into cell from step 3, NOW is the most top entry in
   the list "Last Used Functions"

I also see that with Master "LibO-dev 3.4.5  – WIN7  Home Premium  (64bit) English UI 
[(Build ID:d337f79-a24c961-2865670-9752b71-7f8fd43
Comment 1 wope 2011-08-02 08:13:50 UTC
confirmed on Suse 11.4 64Bit
Comment 2 Korrawit Pruegsanusak 2011-08-02 08:17:31 UTC
*Cannot* reproduce with LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice- on Windows XP 32 bit

Seems to be regression
Comment 3 Korrawit Pruegsanusak 2011-08-02 09:39:41 UTC
Set whiteboard to CONFIRMED

Please feel free to reassign if it’s not your area
Comment 4 Korrawit Pruegsanusak 2011-08-02 09:41:24 UTC
Sorry for my resetting of platform. Set to All.
Comment 5 Jeffrey 2011-08-02 18:48:11 UTC
Created attachment 49855 [details]
Reproduced Bug along with new Problems

Confirmed on LibreOffice 3.4  340m1(Build:103) for OpenSuse Linux. I seem to encounter another problem as well, as evidenced in the attached screenshot.

After double-clicking SUM, not only does Last Used Function not update, but the current list is duplicated twice under. So it begins with SUM, TODAY, NOW, and then there is another set of SUM... after it and a third set as well. Just posting it here to see if anyone else encountered this. Will open a new bug on this.
Comment 6 Rainer Bielefeld Retired 2011-08-02 23:19:27 UTC
Confirm Jeffrey's observation concerning duplication of the list. 
May be Developer should decide whether duplication is related to wrong insertion?
Comment 7 Björn Michaelsen 2011-12-23 13:25:57 UTC
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Comment 8 Mateusz 2013-01-23 18:41:07 UTC
*** Bug 39787 has been marked as a duplicate of this bug. ***
Comment 9 Konrad 2013-01-23 18:54:01 UTC
When I want insert function from Function List (Last used) I always get first function in this list and functions will be replicated.

LO 4.0 RC1 (2013-01-21_10:33:51)
Kubuntu 12.04 32bit
Comment 10 Konrad 2013-03-06 01:36:22 UTC
*** Bug 60231 has been marked as a duplicate of this bug. ***
Comment 11 Mateusz 2013-05-28 15:42:39 UTC

Currently build still suffer from this bug.

Build ID: 670ff6a6d2f39754fb9a39b6cd0757b4ffa3913
TinderBox: Win-x86_9-Voreppe, Branch:libreoffice-4-1, Time: 2013-05-27_13:25:39

I also tested present-day Apache OpenOffice 4 build and this bug is fixed there

AOO400m1(Build:9700)  -  Rev. 1479897

so It's chance to copy their solution and fix LO's error.
Comment 12 sophie 2013-10-23 08:54:59 UTC
*** Bug 70793 has been marked as a duplicate of this bug. ***
Comment 13 Kevin Suo 2014-06-13 03:24:18 UTC
Based on comment 2, I set keyword "regression".

This still reproduce in LibreOffice beta2 and

Just for info, this bug behaviour does not reproduce in Apache OpenOffice beta 4.1.0 , AOO410m14(Build:9760).
Comment 14 Jean-Baptiste Faure 2014-06-13 18:08:15 UTC
I do not completely reproduce with LO under Ubuntu 14.04 x86-64.
When I double-click on the name of the function (or if I click on the button Add) in the last used functions list, I get the right function in the selected cell, but the list is wrongly modified: the chosen function name is added at the top then the full list is added at the top of the list. This duplicated list is cleared if I close the file and reopen a new one.

Not reproducible too with LO
Reproducible with LO 4.1.6

Best regards. JBF
Comment 15 Kevin Suo 2014-12-02 02:05:30 UTC
I still reproduce with
Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889

Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e
Locale: zh_CN

Actually there are two issues in this bug which may be the same root cause:

One issue is: When you double-click a function in the list, the function name appeared in the cell is always the name of the "top" one in the list, while the parameters are of the function you are clicking (does not match the function name).

Another issue is: When you double-click a function in the list, the list is duplicated.
For example, if originally there are "MAX,SUM,IF,MIN,AVERAGE" in the list, double-click on "IF" will result in the list to be "MAX,SUM,IF,MIN,AVERAGE,IF,MAX,SUM,IF,MIN,AVERAGE,IF,MAX,SUM,IF,MIN,AVERAGE". (It duplicated starting from IF, then start from the top one MAX through AVERAGE, then for another time.
Comment 16 Kevin Suo 2014-12-02 02:06:57 UTC
Just for information: this issue does not exist in 
Apache OpenOffice 4.1
AOO411m6(Build:9775)  -  Rev. 1617669
2014-08-13 09:06:54 (Mi, 13 Aug 2014)
Comment 17 Kevin Suo 2014-12-22 11:44:26 UTC

*** This bug has been marked as a duplicate of bug 87558 ***