Issue 72530

Summary: adapting sum formula in TextTable when inserting/deleting rows
Product: Writer Reporter: eberlein <pet.ebe>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.4Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
showing inconsistency none

Description eberlein 2006-12-13 11:49:40 UTC
See thread

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.
Comment 1 michael.ruess 2006-12-13 13:03:19 UTC
Created attachment 41397 [details]
showing inconsistency
Comment 2 michael.ruess 2006-12-13 13:24:36 UTC
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.
Comment 3 joesch 2006-12-14 12:15:43 UTC
I think sum(above) has not the right funktion. When the values are:

A1: 3
A2: 1
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(!) 

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. 

Comment 4 michael.ruess 2010-02-22 15:16:16 UTC
*** Issue 109510 has been marked as a duplicate of this issue. ***
Comment 5 Marcus 2017-05-20 11:22:07 UTC
Reset assigne to the default "".