https://bugs.freedesktop.org/show_bug.cgi?id=81659
--- Comment #4 from GerardF <gerard.farg...@orange.fr> --- (In reply to comment #3) > There is obviously a change, but where is the bug or incorrect behavior? In > the current version or in the previous? > > Best regards. JBF When inserting new row with "Expand references ...." enabled, References in formulae must be expanded if: + new row is adjacent to references + original reference contains at least 2 rows. Example 1: Formula =SUM(A2:B3)and insert row before row 2 make formula becomes =SUM(A2:B4) (there is 2 rows in the SUM range) Example 2: Formula =SUM(A2:B2)and insert row before row 2 make formula stay =SUM(A2:B2) (there is 1 row in the SUM range) Plus : this bug change also references when row inserted is *not* adjacent to the range. Inserting a new row in row 2 with formula =SUM(A5:B5) in C5 change the formula in =SUM(A5:B6) Same behaviour for columns. This is indeed a major bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs