To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72530
------- Additional comments from [EMAIL PROTECTED] Thu Dec 14 04:15:43 -0800 2006 ------- I think sum(above) has not the right funktion. When the values are: A1: 3 A2: 1 A3: A4: 2 then sum(above) (in A5) has the result 2 (and not 6!). The right formula in this situation is sum(A1:A4) (in MS Word). I think sum<b1:b4> (in OOo-Writer) works in main correctly. When the formula is sum(A1:A4) and i adding a row after A4, there a two(!) capabilities: 1. before ein insert the new row i mark the cell A4 (or the row 4), then i can insert a new row and the formula is change correctly 2. before ein insert the new row i mark the cell A5 (or the row 5), then the formula is not change when i isert a new row, but this *is* correct, because the range in the original-formula is *from* A1 *to* A4, and not from A1 to 'a little bit after the cell-border of A4' (in other words: the (virtuell) cell- boder between A4 and A5 is not a component of the range A1:A4) >From this point of view, I think this issue is a issue for a new Feature and not a description of a bug. Please dont *change* this Funktion to the behavior sum(above), only you can add a *new* feature in the sense of sum(above). Not correct is only the described behavior when i delete the row 4. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]