https://bugs.documentfoundation.org/show_bug.cgi?id=161763
--- Comment #11 from [email protected] --- (In reply to ady from comment #8) > 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. > While I agree as a general approach, it is not too much of a big deal (it has to be very well justified, of course). It's a bit too early to discuss this, but if it turns out it deserves to be changed because it will improve the product, then why not? The way it is right now seems quite 'dangerous' to me because it creates room for 'silent' errors, which are often the most difficult to track and find. Maybe we should think of scenarios where changing this would negatively affect a given spreadsheet. Your sentence "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." is very close to what happened to me: I had some expectations and they were not fulfilled. The question is the same for me and your potential user: were those expectations reasonable? were they based on sound reasoning or just historical reasons? can it be improved? -- You are receiving this mail because: You are the assignee for the bug.
