[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 #6 from yallabalagan at gmail.com ---
Confirmed on 7.1.2.2  Kubuntu 64bit PC.

The problem is *much* worse: multiple reproducible bugs around relative (and
absolute) name ranges, rendering them untrustworthy of calculations.

multiple examples screencast / videos of these bugs: 
https://youtu.be/R0y8Zg_d-vs
https://youtu.be/TOphlzoWfvE


bug1:
1. create a absolute named range
2. convert it to relative
3. result - formulas (sometimes) give error 522 (circular reference)

bug 2:
1. create a relative named range
2. go to another cell
3. press Ctrl+F3
4. result: The named range shows another address!

bug 3
1. create relative named range
2. create a formula referring to that named range (e.g. "=named+4" )
2. sort
3. named range points to another address; formula gives a wrong result

bug 4:
1. change named range from relative/absolute, to half-relative ($B$6 -> B$6 ,
$B6).
2. exactly same address, different results or error messages


wait, there's more but difficult to reproduce:
sometimes relative named range error (522) magically fixed after changing
values in the sheet. or the error is removed, but showing abnormal values.

-- 
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/19fab0a2/attachment.htm>