[Libreoffice-bugs] [Bug 118654] strange behaviour when typing formula containing named cell '_C'

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118654

--- Comment #6 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
> At this point, the formula became "=1 - alpha/__C" ( with double underscore"
> after pressing ENTER.
> Later, it changed to '_C' at
> https://cgit.freedesktop.org/libreoffice/core/commit/
> ?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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180711/1c7fe101/attachment.html>