<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Inconsistent behaviour of option "Expand References..."" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128846#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Inconsistent behaviour of option "Expand References..."" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128846">bug 128846</a> from <a class="email" href="mailto:villeroy@t-online.de" title="Andreas Säger <villeroy@t-online.de>"> Andreas Säger</a> <pre> > with AOO 4.1.5 and "[x] expand references": > - select row 12 > - context menu: insert row > -> formula in B11 changes from =SUM($A$6:A11) to =SUM($A$6:A12) > The formula does not calculate the running total anymore. The meaning of this single formula in B11 has changed. It does not sum up the other column until the same row. The R1C1 notation shows this more clearly. > btw: excel suggest using: =SUM(INDIRECT("A6:A"&ROW())) <a href="https://support.office.com/en-us/article/Calculate-a-running-total-in-Excel-1359BF89-180B-4771-B5B4-C6F6558549C5">https://support.office.com/en-us/article/Calculate-a-running-total-in-Excel-1359BF89-180B-4771-B5B4-C6F6558549C5</a> describes the proceeding with normal formulas, cell insertion and formula copy. I have to assume that Excel does not modify the existing formula because this would mix wrong formulas into the calculated field. And OpenOffice still shows the correct behaviour where certain references do NOT expand. At the moment I have difficulties describing a rule for this. The old source code should explain it better than I can right now. It could be that references adjacent to the inserted cells and in the opposite direction to the move direction remain untouched but I'm not sure.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>