https://bugs.freedesktop.org/show_bug.cgi?id=45146

Eike Rathke <[email protected]> changed:

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

--- Comment #26 from Eike Rathke <[email protected]> ---
A relative in-sheet reference is supposed to point to a cell relative to the
formula cell containing the reference and hence changes the value if the
formula cell is moved during sort. If the reference shall stick to the same
cell then an absolute reference must be used. This behavior is identical to how
Excel treats it.

With the fix for bug 79441 the behavior now again is also identical for 3D
references that include a sheet part, which makes the reference sticky just
like in Excel.

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

Reply via email to