[Libreoffice-bugs] [Bug 113029] New: EDITING: AutoInput doesn' t recognise RC references and autocompletes with a formula

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113029
           Summary: EDITING: AutoInput doesn't recognise RC references and
                    autocompletes with a formula
           Product: LibreOffice
           Version: 5.3.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jrussell_88 at yahoo.com.sg

LibreOffice Calc Version: 5.3.1.2
Build ID: 1:5.3.1-0ubuntu2

Ubuntu 17.04 x64 on a MacBook Retina Pro

With Formula Syntax RC, and AutoInput on, entering a formula ending with the
relative column reference, i.e. a trailing 'C' in a reference such as 'R[1]C'
or 'R2C' causes Calc to suggest 'Ceiling()' function. 

If the C is followed by another symbol such as a '+' Calc accepts the
reference. 

Turning off 'Tools - AutoInput' stops this behaviour for new entries, but not
when editing formulae which have already been entered. 

If 'AutoInput' is on when the reference is entered for the first time, then the
formula autocompletes to 'Ceiling()'. I overrode that by entering the column
number: 'R98C1'

With AutoInput off, the same cell when edited to '=R98C' autocompletes to
'Ceiling()', whereas entering the same formula in another cell '=R98C' does not
provoke autocomplete. 

If I completely overwrite the first cell ('=R98C1') with the formula '=R98C'
with the same formula, it accepts it.

If AutoInput is turned on again, both cells autocomplete to 'Ceiling()'

If the cell (e.g. 'R4C') hasn't been referenced already, it autocompletes to
'Ceiling()'.

If it has been used already then it accepts the reference.

This bug is a significant issue when editing formulae which have been entered
with AutoInput on. 

As a rule, if RC formula referencing is in use then any expression starting
'R?C' or 'R[?]C' shouldn't be subject to autocomplete; the issue seems to be
that autocomplete doesn't recognise RC references. 

I understand that it is possible to cancel autocomplete suggestions using the
Delete key, however Mac keyboards don't have a Delete key so this workaround is
not available to me. 

The same behaviour applies to the R in RC references, however as this is
followed by another character, the autocomplete suggestion is overridden.

Can I suggest that a filter is added in AutoInput to detect RC references and
avoid autocompleting them?

-- 
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/20171010/4cf6fc35/attachment.html>