[Libreoffice-bugs] [Bug 140184] Sort changes relative references same as absolute ones

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 171243
  --> https://bugs.documentfoundation.org/attachment.cgi?id=171243&action=edit
Sample relative/absolute named ranges

How relative and absolute 'named ranges' work it's a bit tricky.

When a relative range is created, it is relative to the cell where you are at
the moment of creation, if you go to another cell then it changes with rows and
columns relatives to the change of position.
Enter =cell() in A1 and A2
e.e go to C2, [Ctrl+F3], create 'test' 'sheet1.A1'
In C2: =test -> result is 'A1'
In C3: =test -> result is 'A2'
Copy C2 to C3: result in C3 is 'A2'
Such kind of behavior is very useful to solve some situations, but no easy to
understand with two cells with a formula with the same 'named range' give
different results.

So messing that with sort adapting references looks to me not easy to
understand the result.

-- 
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/20210416/fee87ae2/attachment.htm>