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

Eike Rathke <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from Eike Rathke <[email protected]> ---
The name "table" is defined to use relative references. Originally defined on
Sheet1_2.M35 it references B15:C38. Using the name in another cell shifts
relative references accordingly, in this case it even wraps them around the
sheet border. Define the name to use absolute references instead, i.e.
$B$15:$C$38

There's a bug in displaying a wrapped reference and it displays with #REF
parts, invoke Manage Names (Ctrl+F3) on cell M35 to get the correct value and
edit it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to