[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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #10 from Mike Kaganski <mikekaganski at hotmail.com> ---
I think steps in comment 0 are pretty clear.
And I repro the problem as described, using "Update references when sorting
range of cells" under Options|Calc|General.

With the mentioned setting disabled, I get a different resulting formula in
M56: it's

> =IF(J56="";"";IF(J57="";SUM(J53:J56);""))

and it is much saner.

I suppose that you should check if this setting solver this for you, or use
things like OFFSET in your formula. My opinion is that it works as designed,
taking into account the absolute impossibility to define "updating references
to ranges (which may change randomly) when sorting".

-- 
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/20201219/1a27b39f/attachment.htm>