https://bugs.freedesktop.org/show_bug.cgi?id=86304
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Jean-Baptiste Faure <[email protected]> --- Hi Paulo, Please could you explain why do you think that the legacy behavior is the correct one for absolute references? Don't worry, it is a real question, I am trying to understand this mess about sorting. Another thing which is confusing me is that, if you change the option UpdateReferenceOnSort from false to true in the master (next version 4.4.0) absolute references are _not_ updated when sorting the range of cells A3:E5 of your test file. You have the same behavior with 4.3.4 but there the option is hidden the expert configuration. So we can give 2 opposite definitions of updating references. Based on your test file : Definition n°1: the cell in column A corresponding to data 1, 1, 1 changes to reflect the change in the position of these data. So SUM(B$5:D$5) in A5 becomes SUM(B$3:D$3) when data 1, 1, 1 in B5:D5 move in B3:D3 Definition n°2: the formula in A5 (SUM(B$5:D$5)) is changed to keep the link with the referenced data (1, 1, 1) when this cell is moved in A3 accompanying data from B5:D5 to B3:D3 What is your own definition? Def n°1, def n°2 or other one ? ;-) Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
