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
confirmed on Suse 11.4 64Bit
*Cannot* reproduce with LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-220.127.116.11 on Windows XP 32 bit
Seems to be regression
Set whiteboard to CONFIRMED
Please feel free to reassign if it’s not your area
Sorry for my resetting of platform. Set to All.
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.
Confirm Jeffrey's observation concerning duplication of the list.
May be Developer should decide whether duplication is related to wrong insertion?
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.
*** Bug 39787 has been marked as a duplicate of this bug. ***
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
*** Bug 60231 has been marked as a duplicate of this bug. ***
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.
*** Bug 70793 has been marked as a duplicate of this bug. ***
Based on comment 2, I set keyword "regression".
This still reproduce in LibreOffice 18.104.22.168 beta2 and 22.214.171.124.
Just for info, this bug behaviour does not reproduce in Apache OpenOffice beta 4.1.0 , AOO410m14(Build:9760).
I do not completely reproduce with LO 126.96.36.199beta2+ 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 188.8.131.52+
Reproducible with LO 4.1.6
Best regards. JBF
I still reproduce with
Build ID: 8fd0451cc08e6a5310bed8b7ad1c46b93c1c6889
Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e
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.
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)
*** This bug has been marked as a duplicate of bug 87558 ***