[Libreoffice-bugs] [Bug 138896] AutoFilter sort reference not updated with nested IF statement

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from Colin <that.man.colin at gmail.com> ---
As I mentioned, attempting to truncate the range resulted in even more
catastrophic erroneous cell references so what I provided is what best
demonstrates the feature - WYSIWYG

1. Set autofilter Column C to "All" - this obviates one of the the existing
autofilter bugs on newly opened sheets.
2. Ensure autofilter column B is set to "Sort Ascending"
3. Observe the value in M434 - This is the anticipated "Correct Value" 
4. Observe the range references in M434 they are current, 1 following & 3
preceding rows - the preceding rows array grows according to the current
location of the focus cell in the daily "cluster"
5. Set Auto Filter on column B - "Sort Descending"

   NOTE: M56 is the new location of the focus cell in the current daily cluster

6. Observe the range references in M56 - they are NOT the current focus array
references, they are "out" by 378 rows
7. Observe the value in M56 - this is incorrect

-- 
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/20201215/7ee33e0c/attachment.htm>