https://bugs.documentfoundation.org/show_bug.cgi?id=138896
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #10 from Mike Kaganski <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
