Manually editing an existing formula now aggressively autocompletes function names. Example: 1/ I have a cell containing the formula =D1*5 2/ I want to edit the formula to reference cell E1 instead, so I postion my cursor in the Formula Editor, delete the letter 'D', type 'E' and press [ENTER]. 3/ The formula is autosuggested to read =EASTERSUNDAY()*5 While not major, it interrupts workflow substantially for any user typing formulas with cell references: seems to have been in place since about 4.3.5.1, have verified that it wasn't the can in an old install of 4.1.6.2 I would like to turn it off: I don't suppose there's just a setting I've missed?
Hi Alex, I conform the issue. Experienced it myself, but didn't really check what is going on: just using RIGHT before ENTER. But I agree that it's annoying. ( did not search for duplicates did not search for first known commit/version that has the bug therefore NEEDINFO - but not from Alex AFAIAC ) Cor
maybe the autocompletion of function should not work if there is no space after the cursor.
Thanks Cor. As you note, it can be worked around relatively easily, but this is at odd with my decades-old editing habits. That's likely to be the case for other users too, but mostly sits at the level of petty annoyance, where I make an edit without thinking, realise the formula is borked and have to go back to change. Your suggestion of No autocomplete if there is no space after the cursor sounds good -probably best if it could still show the suggestion so user can select if they want, but not insert automatically. THat way anyone with old habits is not impeded, which is better for switchers (and those upgrading from older LO releases.) Thanks!
I'm setting this back to NEW as the bug is already confirmed. I want to re-confirm it. Found on LibreOffice 4.3.5.2, Build ID: 430m0(Build:2) on Ubuntu 14.04.1 LTS.
I also consider the autocomplete of formulas rather aggresive (LibreOffice 4.4.2.2). It could be prevented, if suggestions started for at least two characters, I didn't find any setting for this.
Works OK in LibreOffice 3.5.0 Build ID: d6cde02 -> regression. Very annoying, I think importance should be higher than minor
@Winfried: Maybe one for you, as you were already working in this area? Function name completion should not hit when editing and the next character is alphanumeric, for example (just a quick guess).
also bad for these: # bad: [f1142b286f151d5588a07bef2c2700a465160e3b] source-hash-4815d3da5647b274894bbf4edafcadab179ce8f0 # bad: [c820bc14ec13b8f216ebc27c0633b3006b4bc293] source-hash-8ac30e7c450acf3147454e6cb2a86978f1359c54 count go any further down because got terminate called after throwing an instance of 'com::sun::star::uno::DeploymentException' on older versions
(In reply to Marek Dolezel from comment #8) > also bad for these: > # bad: [f1142b286f151d5588a07bef2c2700a465160e3b] > source-hash-4815d3da5647b274894bbf4edafcadab179ce8f0 > > # bad: [c820bc14ec13b8f216ebc27c0633b3006b4bc293] > source-hash-8ac30e7c450acf3147454e6cb2a86978f1359c54 > > count go any further down because got terminate called after throwing an > instance of 'com::sun::star::uno::DeploymentException' on older versions @Marek: I'm on it, and know exactly where the problem is. Making the patch work for all languages (as formulas can be in all sorts of language, with their specific characters) takes some time.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f3d748937a177cbbc0033bcf54d0d0fd57a1b409 tdf#89031 remove agressiveness from Calc function suggestions It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=579f5cbfc4636ae28e545b0d2e456e100b08b4ad&h=libreoffice-5-0 tdf#89031 remove agressiveness from Calc function suggestions It will be available in 5.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=865afb6ed25891129efb6907595c892e417a191a&h=libreoffice-4-4 tdf#89031 remove agressiveness from Calc function suggestions It will be available in 4.4.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/17014 for 5-0-0
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-0-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0d83531e915cf5dda33c41025d4d6afba4d6908d&h=libreoffice-5-0-0 tdf#89031 remove agressiveness from Calc function suggestions It will be available in 5.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks a lot Winfried - saves quite some recently learned additional key strokes in various operations ;)
Finally got to testing this - perfect! Thanks!
It seems that $ should be added to the list of characters that disable autocomplete of preceding string, see bug 96986. Best regards. JBF
*** Bug 96986 has been marked as a duplicate of this bug. ***
(In reply to Jean-Baptiste Faure from comment #17) > It seems that $ should be added to the list of characters that disable > autocomplete of preceding string, see bug 96986. I will look into this and see if I can fix it soon.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1e2bcb3177d58e6f446296ae28fcff7f5da9b620 follow-up of tdf#89031 It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e2b222cc98b1378b85d0c37eb9f5ef562247b3cf&h=libreoffice-5-1 follow-up of tdf#89031 It will be available in 5.1.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Winfried Donkers committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=26bafaacd071dcba4bf7f75776e31c5786cfd725&h=libreoffice-5-0 follow-up of tdf#89031 It will be available in 5.0.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tested on LO 5.1.1.0.0+ under Ubuntu 15.10 x86-64: works as expected. Thank you very much. Closing again as Fixed. Best regards. JBF