<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - strange behaviour when typing formula containing named cell '_C'" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118654#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - strange behaviour when typing formula containing named cell '_C'" href="https://bugs.documentfoundation.org/show_bug.cgi?id=118654">bug 118654</a> from <a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> Winfried Donkers</a> <pre>> At this point, the formula became "=1 - alpha/__C" ( with double underscore" > after pressing ENTER. > Later, it changed to '_C' at > <a href="https://cgit.freedesktop.org/libreoffice/core/commit/">https://cgit.freedesktop.org/libreoffice/core/commit/</a> > ?id=9fc83ae4e479f7e6784dfdce87de35c283fbadd2 > > Adding Winfried Donkers to the loop as well... This commit may well make the problem apparent, as <Enter> is interpreted as 'use the first match in the list of the entered text as function'. The problem with _C also occurs when you define a named range with the same name as a function, the underscore is not the reason. I _think_ (I have not digged into this deep enough to be certain) that cause of the problem has more to do with named ranges being included in the matching functions list used for automatic function name completion. I cannot look into this matter any deeper soon, as I'm currently busy tackling another bug.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>