Apache OpenOffice (AOO) Bugzilla – Issue 72530
adapting sum formula in TextTable when inserting/deleting rows
Last modified: 2017-05-20 11:22:07 UTC
See thread http://sw.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=1606451 If in a TextTable the cell formula in b4 is sum<b1:b3>, adding a row after b2 will expand the formula to sum<b1:b4>. Adding a row after b3 will not expand the formula. Deleting the row (b3 belongs to) will cause an error in the formula. This behavior should be changed like MS Word does in the sum(above) field.
Created attachment 41397 [details] showing inconsistency
This is similar to issue 58307, but this also refers to adding rows in a table. The sum formula should be adapted, at least this would cover the expectations of the user.
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.
*** Issue 109510 has been marked as a duplicate of this issue. ***
Reset assigne to the default "issues@openoffice.apache.org".