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

Eike Rathke <er...@redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|                            |er...@redhat.com
            Version|7.2.4.1 release             |Inherited From OOo

--- Comment #3 from Eike Rathke <er...@redhat.com> ---
Automatically finding labels prioritizes on column labels if the next cell
above/below the found label cell does not have text content at the moment the
cell formula is compiled (not interpreted). What happens here is that in both
documents the intersection of the label in 1.A1/2.A2 and the formula cell in B3
is A3 instead of the expected 1.B1/2.B2. If a numeric value is entered in A3 in
either document it can be observed.

Automatic labels are fragile (and should be deprecated in the UI option
settings). Best use defined label ranges,
Sheet -> Named Ranges and Expressions -> Labels...

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to