https://bugs.documentfoundation.org/show_bug.cgi?id=161763
--- Comment #6 from [email protected] --- (In reply to Werner Tietz from comment #5) > (In reply to m_a_riosv from comment #4) > > Maybe the issue is with the option: > > Menu/Tools/Options/LibreOffice Calc/General/Update references when sorting > > range of cells. > > +1 > ( the issue happens __without__ this Option … but not with it) I was not aware of this setting. Therefore, I guess this thread should turn into: why is this option not enabled by default? Is it not the expected behavior in most cases? Actually I would go further and ask: why would anyone want to disable updating the references when sorting? And, it is not a matter of taste, in the case I presented the formula is clearly doing the job in a wrong way (e.g. calculating the discount for one item based on a completely different one, silently). Anyway, I plea for a 'enabled' default. I find it difficult to see how the 'don't update references when sorting' mode is the preferable, expected behavior for most users. Maybe I'm missing something and there are many cases when one would not want the references to be updated? (and risk incurring in 'hidden' errors as the one I presented?) -- You are receiving this mail because: You are the assignee for the bug.
