[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
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #13 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Colin from comment #11)
> (In reply to Mike Kaganski from comment #10)
> I get the same result as you but on closer examination, you will discover
> that the cells being SUMmed are now future events for which there can never
> be any valid data.

Of course. And this shows how you use Calc wrong. You use relative references
*as a substitution for a semantical relation". This is implying that Calc
"understands" your ideas about your data, such as "I refer to these N preceding
events", instead of "N cells above". It's you who has the mental model that
cells above are preceding events, but don't imply Calc to be human.

If you want to refer to data that has some semantical relation to this cell,
independent of relative position on sheet, then you should create formulas
based on those traits, not on relative referencing.

How to create such a formula for a specific task is off-topic here, please ask
e.g. on ask.libreoffice.org.

Closing NOTABUG.

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