https://bugs.documentfoundation.org/show_bug.cgi?id=161763
--- Comment #8 from ady <[email protected]> --- (In reply to J22Gim from comment #6) > 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?) As suggested, there other possible layouts and formulas that would avoid your problem, whichever that setting would be. Even using the same formulas and layouts as in attachment 194929, there might be possible cases in which the current setting is adequate. For instance, there could be a case in which you always want to follow the specific location ($initial.C2), whichever value ends up in-there. If you would changed the formula in the 'discount' worksheet, cell C2, from: =$initial.C2/2 to: =$initial.$C$2/2 ...then it should track the specific cell, even after re-sorting the data. BUT, the "problem" is that then you cannot simply copy (or fill down) the formula to the rest of the cells down the column. Other layouts and/or other formulas (as suggested in prior comments) should work better. As for changing the default behavior of "Update references when sorting range of cells", I'm not sure that's a good idea at this point. First, it would change the default behavior for everyone. What would happen when a user already expects the current behavior to be the default (e.g. on a new installation of LO)? Suddenly, the results would be different, without being aware of it. It would also help to know what's the current behavior on other spreadsheet tools, before thinking about introducing disrupting changes. Or, maybe, this setting is there exactly for this reason: to make Calc behave as other tools, per users' choice. -- You are receiving this mail because: You are the assignee for the bug.
