https://bugs.freedesktop.org/show_bug.cgi?id=86304
Paulo da Silva <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from Paulo da Silva <[email protected]> --- Hello Jean. Trying to respond in the same order of your questions ... 1. My versions were 4.2.7.2 and 4.3.3.2. I have right now updated to 4.3.4.1 and, btw, things are working as expected (or as I expect). Thanks. 2. "updated when sorting": Considering the example, 1st. table: Row 5 goes to row 3 when sorting. Then, the _new_ contents “=sum(b5:d5)” of cell e3 must be updated (changed) to “=sum(b3:d3)” to reflect its move 2 rows up. On the contrary, the _new_ contents “=sum($b$5:$d$5)” of cell a3 must be kept as is “=sum($b$5:$d$5)” because the rows references “5” (b and d) have “$”s protecting them. When I am talking about “updated” or “changed” I mean _after_ the move caused by the sort. When I put a $ before a row reference I want to preserve this reference in the formula. The fact of this formula being moved to another row by sorting must not modify it inside the _new_ cell. I am assuming this reference in the formula is moved during the sort but kept untouched on its destination cell. 3. About legacy ... I am a power user of spreadsheets since their very 1st. appearance, both at work and at home. This builds a “sense”. I don't know if it is a right “sense” or even a good “sense” but it is a common “sense” for those who have being using spreadsheets for long time. I recognize that there may be some situations where this behavior may have some inconveniences but, IMHO, it should be the default. This also is the behavior of other spreadsheets. 4. If I am reading your question "Definitions" right I think the Definition 1 is the correct one. To clarify here is the example: Before sorting: A B C D E 3 =SUM(B$3:D$3) 3 3 3 =SUM(B3:D3) 4 =SUM(B$4:D$4) 2 2 2 =SUM(B4:D4) 5 =SUM(B$5:D$5) 1 1 1 =SUM(B5:D5) After sorting: A B C D E 3 =SUM(B$5:D$5) 1 1 1 =SUM(B3:D3) 4 =SUM(B$4:D$4) 2 2 2 =SUM(B4:D4) 5 =SUM(B$3:D$3) 3 3 3 =SUM(B5:D5) *** 4.3.4.1 is right. So, for me, this bug can be closed. *** Regards. -- 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
